VIEW: APPS.WIP_PARAMETERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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