View: WIP_PARAMETERS_V

Product:	WIP - Work in Process
Description:	Foreign-key data for WIP_PARAMETERS
Implementation/DBA Data:	APPS.WIP_PARAMETERS_V

View Text

SELECT WP.ROWID ROW_ID
, WP.ORGANIZATION_ID
, WP.LAST_UPDATE_DATE
, WP.LAST_UPDATED_BY
, WP.CREATION_DATE
, WP.CREATED_BY
, WP.LAST_UPDATE_LOGIN
, WP.DEFAULT_PULL_SUPPLY_SUBINV
, MTS.LOCATOR_TYPE SUBINV_LOCATOR_TYPE
, MTP.STOCK_LOCATOR_CONTROL_CODE
, WP.DEFAULT_PULL_SUPPLY_LOCATOR_ID
, WP.LOT_NUMBER_DEFAULT_TYPE
, WP.BACKFLUSH_LOT_ENTRY_TYPE
, DECODE(WP.BACKFLUSH_LOT_ENTRY_TYPE
, 1
, 1
, 2
, 2
, 3
, 2
, 4
, 4
, 5
, 4
, 6
, 6
, 7
, 6) LOT_SELECTION_METHOD
, DECODE(WP.BACKFLUSH_LOT_ENTRY_TYPE
, 1
, 0
, 2
, 0
, 3
, 1
, 4
, 0
, 5
, 1
, 6
, 0
, 7
, 1) LOT_VERIFICATION
, WP.INCLUDE_COMPONENT_YIELD
, WP.DEFAULT_DISCRETE_CLASS
, WP.DYNAMIC_OPERATION_INSERT_FLAG
, WP.MANDATORY_SCRAP_FLAG
, WP.SO_CHANGE_RESPONSE_TYPE
, WP.REPETITIVE_VARIANCE_TYPE
, WP.AUTORELEASE_DAYS
, WP.OSP_SHOP_FLOOR_STATUS
, WP.ATTRIBUTE_CATEGORY
, WP.ATTRIBUTE1
, WP.ATTRIBUTE2
, WP.ATTRIBUTE3
, WP.ATTRIBUTE4
, WP.ATTRIBUTE5
, WP.ATTRIBUTE6
, WP.ATTRIBUTE7
, WP.ATTRIBUTE8
, WP.ATTRIBUTE9
, WP.ATTRIBUTE10
, WP.ATTRIBUTE11
, WP.ATTRIBUTE12
, WP.ATTRIBUTE13
, WP.ATTRIBUTE14
, WP.ATTRIBUTE15
, /* SUM THE COUNTS OF THE STEP RECORDS IN WVIS
, IF 0
, DECODE TO 2 */ /* ALSO
, IF TO MOVE
, ONLY COUNT THOSE THAT ARE RECORD_CREATOR = USER */ DECODE(SUM(DECODE(WVIS.STEP_LOOKUP_TYPE
, 1
, 1
, 0))
, 0
, 2
, 1) QUEUE_ENABLED_FLAG
, DECODE(SUM(DECODE(WVIS.STEP_LOOKUP_TYPE
, 2
, 1
, 0))
, 0
, 2
, 1) RUN_ENABLED_FLAG
, DECODE(SUM(DECODE(WVIS.STEP_LOOKUP_TYPE
, 3
, DECODE(WVIS.RECORD_CREATOR
, 'USER'
, 1
, 0)
, 0))
, 0
, 2
, 1) TO_MOVE_ENABLED_FLAG
, DECODE(SUM(DECODE(WVIS.STEP_LOOKUP_TYPE
, 4
, 1
, 0))
, 0
, 2
, 1) REJECT_ENABLED_FLAG
, DECODE(SUM(DECODE(WVIS.STEP_LOOKUP_TYPE
, 5
, 1
, 0))
, 0
, 2
, 1) SCRAP_ENABLED_FLAG
, WP.COMPLETION_COST_SOURCE
, LU1.MEANING COMPLETION_COST_SOURCE_MEANING
, WP.COST_TYPE_ID
, CCT.COST_TYPE
, WP.AUTO_COMPUTE_FINAL_COMPLETION
, WP.MOVES_OVER_NO_MOVE_STATUSES
, LU2.MEANING SYSTEM_OPTION
, WP.COMPONENT_ATP_RULE_ID
, MAR.RULE_NAME AS COMPONENT_ATP_RULE_NAME
, WP.PO_CREATION_TIME
, WP.DEFAULT_OVERCOMPL_TOLERANCE
, WP.PRODUCTION_SCHEDULER_ID
, WP.SHIPPING_MANAGER_ID
, PE1.FULL_NAME PRODUCTION_SCHEDULER
, PE2.FULL_NAME SHIPPING_MANAGER
, NVL(WP.USE_FINITE_SCHEDULER
, 2) USE_FINITE_SCHEDULER
, NVL(WP.MATERIAL_CONSTRAINED
, 2) MATERIAL_CONSTRAINED
, NVL(WP.HORIZON_LENGTH
, 0) HORIZON_LENGTH
, WP.DEFAULT_SCRAP_ACCOUNT_ID
, WP.SIMULATION_SET
, NVL(WP.OPTIMIZATION
, 1) OPTIMIZATION
, WP.DUE_DATE_PENALTY
, WP.DUE_DATE_TOLERANCE
, WP.MAXIMUM_PENALTY
, WP.ALLOCATE_BACKFLUSH_COMPONENTS
, WP.MOBILE_TRANSACTION_MODE
, WP.DEFAULT_SERIALIZATION_START_OP
, WP.DEFAULT_WIP_AUTO_ASSOC_SN
, WP.DEFAULT_MOVE_TO_STEP_TYPE
, LU3.MEANING DEFAULT_MOVE_TO_STEP
, WP.INCLUDE_RESOURCE_UTILIZATION
, WP.INCLUDE_RESOURCE_EFFICIENCY
, WP.PICKSLIP_GROUPING_RULE_ID
, WPGR.NAME AS PICKSLIP_GROUPING_RULE_NAME
, WP.DEFAULT_PLAN_TASKS
, WP.PROPAGATE_JOB_CHANGE_TO_PO
, WP.EARLY_NEED_BY_DATE_TOLERANCE
, WP.LATE_NEED_BY_DATE_TOLERANCE
, WP.ALLOW_BACKFLUSH_QTY_CHANGE
, WP.ALTERNATE_LOT_SELECTION_METHOD
FROM PER_ALL_PEOPLE_F PE1
, PER_ALL_PEOPLE_F PE2
, MFG_LOOKUPS LU1
, MFG_LOOKUPS LU2
, MFG_LOOKUPS LU3
, CST_COST_TYPES CCT
, MTL_PARAMETERS MTP
, MTL_SECONDARY_INVENTORIES MTS
, WIP_VALID_INTRAOPERATION_STEPS WVIS
, WIP_PARAMETERS WP
, MTL_ATP_RULES MAR
, WSH_PICK_GROUPING_RULES WPGR
WHERE WP.ORGANIZATION_ID = WVIS.ORGANIZATION_ID
AND WP.ORGANIZATION_ID = MTP.ORGANIZATION_ID
AND WP.ORGANIZATION_ID = MTS.ORGANIZATION_ID
AND WP.DEFAULT_PULL_SUPPLY_SUBINV = MTS.SECONDARY_INVENTORY_NAME
AND WP.COST_TYPE_ID = CCT.COST_TYPE_ID(+)
AND WP.ORGANIZATION_ID = NVL( CCT.ORGANIZATION_ID(+)
, WP.ORGANIZATION_ID)
AND WP.COMPLETION_COST_SOURCE = LU1.LOOKUP_CODE(+)
AND 'CST_COMPLETION_COST_SRC' = LU1.LOOKUP_TYPE(+)
AND WP.SYSTEM_OPTION_ID = LU2.LOOKUP_CODE(+)
AND 'CST_SYSTEM_COMPLETION_OPTIONS' = LU2.LOOKUP_TYPE(+)
AND WP.DEFAULT_MOVE_TO_STEP_TYPE = LU3.LOOKUP_CODE(+)
AND 'WIP_INTRAOPERATION_STEP' = LU3.LOOKUP_TYPE(+)
AND WP.COMPONENT_ATP_RULE_ID = MAR.RULE_ID(+)
AND WP.PRODUCTION_SCHEDULER_ID = PE1.PERSON_ID (+)
AND SYSDATE BETWEEN PE1.EFFECTIVE_START_DATE (+)
AND PE1.EFFECTIVE_END_DATE (+)
AND WP.SHIPPING_MANAGER_ID = PE2.PERSON_ID (+)
AND SYSDATE BETWEEN PE2.EFFECTIVE_START_DATE (+)
AND PE2.EFFECTIVE_END_DATE (+)
AND WP.PICKSLIP_GROUPING_RULE_ID = WPGR.PICK_GROUPING_RULE_ID (+)
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(WPGR.START_DATE_ACTIVE (+)
, SYSDATE))
AND TRUNC(NVL(WPGR.END_DATE_ACTIVE (+)
, SYSDATE)) GROUP BY WP.ROWID
, WP.ORGANIZATION_ID
, WP.LAST_UPDATE_DATE
, WP.LAST_UPDATED_BY
, WP.CREATION_DATE
, WP.CREATED_BY
, WP.LAST_UPDATE_LOGIN
, WP.DEFAULT_PULL_SUPPLY_SUBINV
, MTS.LOCATOR_TYPE
, MTP.STOCK_LOCATOR_CONTROL_CODE
, WP.DEFAULT_PULL_SUPPLY_LOCATOR_ID
, WP.LOT_NUMBER_DEFAULT_TYPE
, WP.BACKFLUSH_LOT_ENTRY_TYPE
, DECODE(WP.BACKFLUSH_LOT_ENTRY_TYPE
, 1
, 1
, 2
, 2
, 3
, 2
, 4
, 4
, 5
, 4
, 6
, 6
, 7
, 6)
, DECODE(WP.BACKFLUSH_LOT_ENTRY_TYPE
, 1
, 0
, 2
, 0
, 3
, 1
, 4
, 0
, 5
, 1
, 6
, 0
, 7
, 1)
, INCLUDE_COMPONENT_YIELD
, WP.DEFAULT_DISCRETE_CLASS
, WP.DYNAMIC_OPERATION_INSERT_FLAG
, WP.MANDATORY_SCRAP_FLAG
, WP.SO_CHANGE_RESPONSE_TYPE
, WP.REPETITIVE_VARIANCE_TYPE
, WP.AUTORELEASE_DAYS
, WP.OSP_SHOP_FLOOR_STATUS
, WP.PO_CREATION_TIME
, WP.ATTRIBUTE_CATEGORY
, WP.ATTRIBUTE1
, WP.ATTRIBUTE2
, WP.ATTRIBUTE3
, WP.ATTRIBUTE4
, WP.ATTRIBUTE5
, WP.ATTRIBUTE6
, WP.ATTRIBUTE7
, WP.ATTRIBUTE8
, WP.ATTRIBUTE9
, WP.ATTRIBUTE10
, WP.ATTRIBUTE11
, WP.ATTRIBUTE12
, WP.ATTRIBUTE13
, WP.ATTRIBUTE14
, WP.ATTRIBUTE15
, WP.COMPLETION_COST_SOURCE
, WP.COST_TYPE_ID
, CCT.COST_TYPE
, WP.AUTO_COMPUTE_FINAL_COMPLETION
, LU1.MEANING
, LU2.MEANING
, LU3.MEANING
, WP.MOVES_OVER_NO_MOVE_STATUSES
, WP.COMPONENT_ATP_RULE_ID
, MAR.RULE_NAME
, WP.DEFAULT_OVERCOMPL_TOLERANCE
, WP.PRODUCTION_SCHEDULER_ID
, WP.SHIPPING_MANAGER_ID
, PE1.FULL_NAME
, PE2.FULL_NAME
, WP.USE_FINITE_SCHEDULER
, WP.MATERIAL_CONSTRAINED
, WP.HORIZON_LENGTH
, WP.DEFAULT_SCRAP_ACCOUNT_ID
, WP.SIMULATION_SET
, WP.OPTIMIZATION
, WP.DUE_DATE_PENALTY
, WP.DUE_DATE_TOLERANCE
, WP.MAXIMUM_PENALTY
, WP.ALLOCATE_BACKFLUSH_COMPONENTS
, WP.MOBILE_TRANSACTION_MODE
, WP.DEFAULT_SERIALIZATION_START_OP
, WP.DEFAULT_WIP_AUTO_ASSOC_SN
, WP.DEFAULT_MOVE_TO_STEP_TYPE
, WP.INCLUDE_RESOURCE_UTILIZATION
, WP.INCLUDE_RESOURCE_EFFICIENCY
, WP.PICKSLIP_GROUPING_RULE_ID
, WPGR.NAME
, WP.DEFAULT_PLAN_TASKS
, WP.PROPAGATE_JOB_CHANGE_TO_PO
, WP.EARLY_NEED_BY_DATE_TOLERANCE
, WP.LATE_NEED_BY_DATE_TOLERANCE
, WP.ALLOW_BACKFLUSH_QTY_CHANGE
, WP.ALTERNATE_LOT_SELECTION_METHOD

Columns