RCS_MFG_PARAMETERS

Details

Schema: FUSION
Object owner: RCS
Object type: VIEW

Columns

Name
ORGANIZATION_ID ORGANIZATION_CODE ORGANIZATION_NAME INVENTORY_ENABLED_FLAG BUSINESS_UNIT_ID INVENTORY_FLAG MFG_PLANT_FLAG CONTRACT_MFG_FLAG SUPPLIER_ID SUPPLIER_SITE_ID MFG_CALENDAR DEF_SUPPLY_SUBINV DEF_SUPPLY_LOCATOR DEF_COMPLTN_SUBINV DEF_COMPLTN_LOCATOR STARTING_OPRN_SEQ OPRN_SEQ_INCREMENT PHNTM_OPRN_INHERIT WORK_ORDER_PREFIX INC_COMP_YIELD_FLAG DEF_OVERCOMPLTN_TOL DEF_TRANS_MODE DEF_TRANS_QTY QTY_CHNG_BACKFLUSH AUTO_ASSC_SER_NUM_WO WO_STARTING_NUMBER WO_DOC_SEQ_CAT_CODE WO_DOC_SEQ_ID PURCHASE_REQ_CREATE_TIME DEF_WO_TRAVELER_TMPLT DEF_LABEL_TMPLT DEF_MNT_SCHED_METHOD STARTSTOP_CAPTURE_LVL BACKFLUSH_LOT_SELECTION MTL_REPORTING_LVL FORECAST_HORIZON GEN_WO_HORIZON PICK_SLIP_GROUPING_RULE PRINT_PICK_SLIPS_FLAG INCLUDE_PULL_COMP_FLAG ISSUE_PUSH_COMP_FLAG PRINT_LABEL_EXTERNALLY ALLOW_DIRECT_PURCH_WO ENABLE_PROCESS_FLAG DEF_WORK_METHOD PROJECT_REFERENCE_ENABLED TRACK_COUNTRY_OF_ORIGIN_FLAG ENABLE_IOT_FLAG MANUAL_ISSUE_ASSY_WO_FLAG ALLOW_NEG_ISS_WO_SN_FLAG ALLOW_RESRVTNS_WO_FLAG MAX_SCHED_DURATION DEFAULT_LOT_BHVR_CODE RESTRICT_LOT_FOR_RETURNS DEF_UNDERCOMPLTN_TOL DEFAULT_INCL_PLAN_BULK DEFAULT_INCL_PLAN_SUPPLIER ENABLE_ROBOTICS

Name

ORGANIZATION_ID

ORGANIZATION_CODE

ORGANIZATION_NAME

INVENTORY_ENABLED_FLAG

BUSINESS_UNIT_ID

INVENTORY_FLAG

MFG_PLANT_FLAG

CONTRACT_MFG_FLAG

SUPPLIER_ID

SUPPLIER_SITE_ID

MFG_CALENDAR

DEF_SUPPLY_SUBINV

DEF_SUPPLY_LOCATOR

DEF_COMPLTN_SUBINV

DEF_COMPLTN_LOCATOR

STARTING_OPRN_SEQ

OPRN_SEQ_INCREMENT

PHNTM_OPRN_INHERIT

WORK_ORDER_PREFIX

INC_COMP_YIELD_FLAG

DEF_OVERCOMPLTN_TOL

DEF_TRANS_MODE

DEF_TRANS_QTY

QTY_CHNG_BACKFLUSH

AUTO_ASSC_SER_NUM_WO

WO_STARTING_NUMBER

WO_DOC_SEQ_CAT_CODE

WO_DOC_SEQ_ID

PURCHASE_REQ_CREATE_TIME

DEF_WO_TRAVELER_TMPLT

DEF_LABEL_TMPLT

DEF_MNT_SCHED_METHOD

STARTSTOP_CAPTURE_LVL

BACKFLUSH_LOT_SELECTION

MTL_REPORTING_LVL

FORECAST_HORIZON

GEN_WO_HORIZON

PICK_SLIP_GROUPING_RULE

PRINT_PICK_SLIPS_FLAG

INCLUDE_PULL_COMP_FLAG

ISSUE_PUSH_COMP_FLAG

PRINT_LABEL_EXTERNALLY

ALLOW_DIRECT_PURCH_WO

ENABLE_PROCESS_FLAG

DEF_WORK_METHOD

PROJECT_REFERENCE_ENABLED

TRACK_COUNTRY_OF_ORIGIN_FLAG

ENABLE_IOT_FLAG

MANUAL_ISSUE_ASSY_WO_FLAG

ALLOW_NEG_ISS_WO_SN_FLAG

ALLOW_RESRVTNS_WO_FLAG

MAX_SCHED_DURATION

DEFAULT_LOT_BHVR_CODE

RESTRICT_LOT_FOR_RETURNS

DEF_UNDERCOMPLTN_TOL

DEFAULT_INCL_PLAN_BULK

DEFAULT_INCL_PLAN_SUPPLIER

ENABLE_ROBOTICS

Query

SQL_Statement
SELECT MP.ORGANIZATION_ID, MP.ORGANIZATION_CODE, MP.ORGANIZATION_NAME ORGANIZATION_NAME, MP.INVENTORY_ENABLED_FLAG, MP.BUSINESS_UNIT_ID, MP.INVENTORY_FLAG INVENTORY_FLAG, MP.MFG_PLANT_FLAG, MP.CONTRACT_MFG_FLAG, MP.SUPPLIER_ID, MP.SUPPLIER_SITE_ID, MFG.MFG_CALENDAR, MFG.DEF_SUPPLY_SUBINV, MFG.DEF_SUPPLY_LOCATOR, MFG.DEF_COMPLTN_SUBINV, MFG.DEF_COMPLTN_LOCATOR, MFG.STARTING_OPRN_SEQ, MFG.OPRN_SEQ_INCREMENT, MFG.PHNTM_OPRN_INHERIT, MFG.WORK_ORDER_PREFIX, MFG.INC_COMP_YIELD_FLAG, MFG.DEF_OVERCOMPLTN_TOL, MFG.DEF_TRANS_MODE, MFG.DEF_TRANS_QTY, MFG.QTY_CHNG_BACKFLUSH, MFG.AUTO_ASSC_SER_NUM_WO, MFG.WO_STARTING_NUMBER, MFG.WO_DOC_SEQ_CAT_CODE, MFG.WO_DOC_SEQ_ID, MFG.PURCHASE_REQ_CREATE_TIME, MFG.DEF_WO_TRAVELER_TMPLT, MFG.DEF_LABEL_TMPLT, MFG.DEF_MNT_SCHED_METHOD, MFG.STARTSTOP_CAPTURE_LVL, MFG.BACKFLUSH_LOT_SELECTION, MFG.MTL_REPORTING_LVL, MFG.FORECAST_HORIZON, MFG.GEN_WO_HORIZON, MFG.PICK_SLIP_GROUPING_RULE, MFG.PRINT_PICK_SLIPS_FLAG, MFG.INCLUDE_PULL_COMP_FLAG, MFG.ISSUE_PUSH_COMP_FLAG, MFG.PRINT_LABEL_EXTERNALLY, MFG.ALLOW_DIRECT_PURCH_WO, MFG.ENABLE_PROCESS_FLAG, MFG.DEF_WORK_METHOD, MP.PROJECT_REFERENCE_ENABLED, MP.TRACK_COUNTRY_OF_ORIGIN_FLAG, MFG.ENABLE_IOT_FLAG, MFG.MANUAL_ISSUE_ASSY_WO_FLAG, MFG.ALLOW_NEG_ISS_WO_SN_FLAG, MFG.ALLOW_RESRVTNS_WO_FLAG, MFG.MAX_SCHED_DURATION, MFG.DEFAULT_LOT_BHVR_CODE, MFG.RESTRICT_LOT_FOR_RETURNS, MFG.DEF_UNDERCOMPLTN_TOL, MFG.DEFAULT_INCL_PLAN_BULK, MFG.DEFAULT_INCL_PLAN_SUPPLIER, MFG.ENABLE_ROBOTICS FROM RCS_ORG_DEFINITIONS_LW_V MP, RCS_MFG_PARAMETERS MFG WHERE MP.ORGANIZATION_ID = MFG.ORGANIZATION_ID AND MP.MFG_PLANT_FLAG = 'Y'

SQL_Statement

SELECT

MP.ORGANIZATION_ID,

MP.ORGANIZATION_CODE,

MP.ORGANIZATION_NAME ORGANIZATION_NAME,

MP.INVENTORY_ENABLED_FLAG,

MP.BUSINESS_UNIT_ID,

MP.INVENTORY_FLAG INVENTORY_FLAG,

MP.MFG_PLANT_FLAG,

MP.CONTRACT_MFG_FLAG,

MP.SUPPLIER_ID,

MP.SUPPLIER_SITE_ID,

MFG.MFG_CALENDAR,

MFG.DEF_SUPPLY_SUBINV,

MFG.DEF_SUPPLY_LOCATOR,

MFG.DEF_COMPLTN_SUBINV,

MFG.DEF_COMPLTN_LOCATOR,

MFG.STARTING_OPRN_SEQ,

MFG.OPRN_SEQ_INCREMENT,

MFG.PHNTM_OPRN_INHERIT,

MFG.WORK_ORDER_PREFIX,

MFG.INC_COMP_YIELD_FLAG,

MFG.DEF_OVERCOMPLTN_TOL,

MFG.DEF_TRANS_MODE,

MFG.DEF_TRANS_QTY,

MFG.QTY_CHNG_BACKFLUSH,

MFG.AUTO_ASSC_SER_NUM_WO,

MFG.WO_STARTING_NUMBER,

MFG.WO_DOC_SEQ_CAT_CODE,

MFG.WO_DOC_SEQ_ID,

MFG.PURCHASE_REQ_CREATE_TIME,

MFG.DEF_WO_TRAVELER_TMPLT,

MFG.DEF_LABEL_TMPLT,

MFG.DEF_MNT_SCHED_METHOD,

MFG.STARTSTOP_CAPTURE_LVL,

MFG.BACKFLUSH_LOT_SELECTION,

MFG.MTL_REPORTING_LVL,

MFG.FORECAST_HORIZON,

MFG.GEN_WO_HORIZON,

MFG.PICK_SLIP_GROUPING_RULE,

MFG.PRINT_PICK_SLIPS_FLAG,

MFG.INCLUDE_PULL_COMP_FLAG,

MFG.ISSUE_PUSH_COMP_FLAG,

MFG.PRINT_LABEL_EXTERNALLY,

MFG.ALLOW_DIRECT_PURCH_WO,

MFG.ENABLE_PROCESS_FLAG,

MFG.DEF_WORK_METHOD,

MP.PROJECT_REFERENCE_ENABLED,

MP.TRACK_COUNTRY_OF_ORIGIN_FLAG,

MFG.ENABLE_IOT_FLAG,

MFG.MANUAL_ISSUE_ASSY_WO_FLAG,

MFG.ALLOW_NEG_ISS_WO_SN_FLAG,

MFG.ALLOW_RESRVTNS_WO_FLAG,

MFG.MAX_SCHED_DURATION,

MFG.DEFAULT_LOT_BHVR_CODE,

MFG.RESTRICT_LOT_FOR_RETURNS,

MFG.DEF_UNDERCOMPLTN_TOL,

MFG.DEFAULT_INCL_PLAN_BULK,

MFG.DEFAULT_INCL_PLAN_SUPPLIER,

MFG.ENABLE_ROBOTICS

FROM

RCS_ORG_DEFINITIONS_LW_V MP,

RCS_MFG_PARAMETERS MFG

WHERE

MP.ORGANIZATION_ID = MFG.ORGANIZATION_ID AND MP.MFG_PLANT_FLAG = 'Y'