RCS_MFG_PARAMETERS_V
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 INC_OPER_YIELD_FLAG |
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, MFG.INC_OPER_YIELD_FLAG FROM RCS_ORG_DEFINITIONS_LW_V MP, RCS_MFG_PARAMETERS MFG WHERE MP.ORGANIZATION_ID = MFG.ORGANIZATION_ID AND MP.MFG_PLANT_FLAG = 'Y' |