eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WMS_OP_PLAN_DETAILS_V

Source

View Text - Preformatted


SELECT d.OPERATION_PLAN_ID, d.OPERATION_PLAN_DETAIL_ID, d.OPERATION_TYPE, d.OPERATION_SEQUENCE, d.BULK_PICK_TYPE, d.DROP_LPN_OPTION, d.WAIT_FOR_GROUP_COMPLETION, d.SYSTEM_DISPATCHED, d.OP_SEGMENT_COMPLETED, d.ZONE_SELECTION_CRITERIA, d.PRE_SPECIFIED_ZONE_ID, d.ZONE_SELECTION_API_ID, d.SUB_SELECTION_CRITERIA, d.PRE_SPECIFIED_SUB_CODE, d.SUB_SELECTION_API_ID, d.LOC_SELECTION_CRITERIA, d.PRE_SPECIFIED_LOC_ID, d.LOC_SELECTION_API_ID, d.ACTIVITY_SEGMENT, d.CREATED_BY, d.CREATION_DATE, d.LAST_UPDATED_BY, d.LAST_UPDATE_DATE, d.LAST_UPDATE_LOGIN, d.ATTRIBUTE_CATEGORY, d.ATTRIBUTE1, d.ATTRIBUTE2, d.ATTRIBUTE3, d.ATTRIBUTE4, d.ATTRIBUTE5, d.ATTRIBUTE6, d.ATTRIBUTE7, d.ATTRIBUTE8, d.ATTRIBUTE9, d.ATTRIBUTE10, d.ATTRIBUTE11, d.ATTRIBUTE12, d.ATTRIBUTE13, d.ATTRIBUTE14, d.ATTRIBUTE15, d.LPN_SELECTION_CRITERIA, d.LPN_SELECTION_API_ID, d.LOC_MTRL_GRP_RULE_ID, d.LPN_MTRL_GRP_RULE_ID, d.IS_IN_INVENTORY, ml1.meaning dest_zone_sug_method, ml2.meaning dest_sub_sug_method, ml3.meaning dest_loc_sug_method, ml4.meaning dest_lpn_sug_method, ml5.meaning drop_LPN_option_name, ml6.meaning loc_mtrl_grp_rule, ml7.meaning lpn_mtrl_grp_rule, ml9.meaning operation_name, decode(wopb.activity_type_id, 1, wahc_loc.loc_dest_sug_API, NULL) loc_dest_sug_API, wahc_lpn.lpn_dest_sug_API lpn_dest_sug_API, zone.zone_name zone_name, Nvl(milk.CONCATENATED_SEGMENTS, '') loc_concatenated_segments , sub_plan.operation_plan_name SUBSEQUENT_OP_PLAN_NAME , sub_plan.operation_plan_id SUBSEQUENT_OP_PLAN_ID , ml10.meaning CONSOL_METHOD_NAME , d.consolidation_method_id CONSOLIDATION_METHOD_ID from wms_op_plan_details d, wms_op_plans_b wopb, (select lookup_code, meaning from mfg_lookups where lookup_type = 'WMS_OP_DEST_SELECTION_MODE') ml1, /* zone method*/ (select lookup_code, meaning from mfg_lookups where lookup_type = 'WMS_OP_DEST_SELECTION_MODE') ml2, /* sub method */ (select lookup_code, meaning from mfg_lookups where lookup_type = 'WMS_OP_DEST_SELECTION_MODE') ml3, /* loc method */ (select lookup_code, meaning from mfg_lookups where lookup_type = 'WMS_OP_DEST_SELECTION_MODE') ml4, /* lpn method */ (select lookup_code, meaning from mfg_lookups where lookup_type = 'WMS_DROP_LPN_OPTION') ml5, /* drop LPN option */ (select lookup_code, meaning from mfg_lookups where lookup_type = 'WMS_MTRL_GRP_RULES') ml6, /* Loc MMG */ (select lookup_code, meaning from mfg_lookups where lookup_type = 'WMS_MTRL_GRP_RULES') ml7, /* LPN MMG */ mfg_lookups ml9, /* Operation name */ (select zone_id, zone_name from wms_zones_tl where LANGUAGE = userenv('LANG') ) zone, mtl_item_locations_kfv milk, (select ml.meaning loc_dest_sug_API, wahc1.hook_call_id from wms_api_hook_calls wahc1, mfg_lookups ml where ml.lookup_type ='WMS_CHILD_SHORT_NAMES' and ml.lookup_code = wahc1.description_id union select wahc.description, wahc.hook_call_id from wms_api_hook_calls wahc where seed_flag = 'N' and module_hook_id = 100) wahc_loc, (select ml.meaning lpn_dest_sug_API, wahc2.hook_call_id from wms_api_hook_calls wahc2, mfg_lookups ml where ml.lookup_type ='WMS_CHILD_SHORT_NAMES' and ml.lookup_code = wahc2.description_id union select wahc.description, wahc.hook_call_id from wms_api_hook_calls wahc where seed_flag = 'N' and module_hook_id = 200) wahc_lpn , (select operation_plan_name, operation_plan_id from wms_op_plans_vl where user_defined = 'N' and activity_type_id = 2) sub_plan /* subsequent seeded outbound plan*/ , (select meaning, lookup_code from mfg_lookups where lookup_type = 'WMS_CONSOL_METHODS') ml10 /* consolidation method */ WHERE d.ZONE_SELECTION_CRITERIA = ml1.lookup_code (+) and d.SUB_SELECTION_CRITERIA = ml2.lookup_code (+) and d.LOC_SELECTION_CRITERIA = ml3.lookup_code (+) and d.LPN_SELECTION_CRITERIA = ml4.lookup_code (+) and d.DROP_LPN_OPTION = ml5.lookup_code (+) and d.LOC_MTRL_GRP_RULE_ID = ml6.lookup_code (+) and d.LPN_MTRL_GRP_RULE_ID = ml7.lookup_code (+) and ml9.lookup_type = 'WMS_OPERATION_TYPE' and d.OPERATION_TYPE = ml9.lookup_code and d.PRE_SPECIFIED_ZONE_ID = zone.zone_id (+) and d.PRE_SPECIFIED_LOC_ID = milk.INVENTORY_LOCATION_ID (+) and d.organization_id = milk.organization_id (+) and d.loc_selection_api_id = wahc_loc.hook_call_id (+) and d.lpn_selection_api_id = wahc_lpn.hook_call_id (+) and d.operation_plan_id = wopb.operation_plan_id and d.subsequent_op_plan_id = sub_plan.operation_plan_id (+) and d.consolidation_method_id = ml10.lookup_code (+)

View Text - HTML Formatted

SELECT D.OPERATION_PLAN_ID
, D.OPERATION_PLAN_DETAIL_ID
, D.OPERATION_TYPE
, D.OPERATION_SEQUENCE
, D.BULK_PICK_TYPE
, D.DROP_LPN_OPTION
, D.WAIT_FOR_GROUP_COMPLETION
, D.SYSTEM_DISPATCHED
, D.OP_SEGMENT_COMPLETED
, D.ZONE_SELECTION_CRITERIA
, D.PRE_SPECIFIED_ZONE_ID
, D.ZONE_SELECTION_API_ID
, D.SUB_SELECTION_CRITERIA
, D.PRE_SPECIFIED_SUB_CODE
, D.SUB_SELECTION_API_ID
, D.LOC_SELECTION_CRITERIA
, D.PRE_SPECIFIED_LOC_ID
, D.LOC_SELECTION_API_ID
, D.ACTIVITY_SEGMENT
, D.CREATED_BY
, D.CREATION_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_DATE
, D.LAST_UPDATE_LOGIN
, D.ATTRIBUTE_CATEGORY
, D.ATTRIBUTE1
, D.ATTRIBUTE2
, D.ATTRIBUTE3
, D.ATTRIBUTE4
, D.ATTRIBUTE5
, D.ATTRIBUTE6
, D.ATTRIBUTE7
, D.ATTRIBUTE8
, D.ATTRIBUTE9
, D.ATTRIBUTE10
, D.ATTRIBUTE11
, D.ATTRIBUTE12
, D.ATTRIBUTE13
, D.ATTRIBUTE14
, D.ATTRIBUTE15
, D.LPN_SELECTION_CRITERIA
, D.LPN_SELECTION_API_ID
, D.LOC_MTRL_GRP_RULE_ID
, D.LPN_MTRL_GRP_RULE_ID
, D.IS_IN_INVENTORY
, ML1.MEANING DEST_ZONE_SUG_METHOD
, ML2.MEANING DEST_SUB_SUG_METHOD
, ML3.MEANING DEST_LOC_SUG_METHOD
, ML4.MEANING DEST_LPN_SUG_METHOD
, ML5.MEANING DROP_LPN_OPTION_NAME
, ML6.MEANING LOC_MTRL_GRP_RULE
, ML7.MEANING LPN_MTRL_GRP_RULE
, ML9.MEANING OPERATION_NAME
, DECODE(WOPB.ACTIVITY_TYPE_ID
, 1
, WAHC_LOC.LOC_DEST_SUG_API
, NULL) LOC_DEST_SUG_API
, WAHC_LPN.LPN_DEST_SUG_API LPN_DEST_SUG_API
, ZONE.ZONE_NAME ZONE_NAME
, NVL(MILK.CONCATENATED_SEGMENTS
, '') LOC_CONCATENATED_SEGMENTS
, SUB_PLAN.OPERATION_PLAN_NAME SUBSEQUENT_OP_PLAN_NAME
, SUB_PLAN.OPERATION_PLAN_ID SUBSEQUENT_OP_PLAN_ID
, ML10.MEANING CONSOL_METHOD_NAME
, D.CONSOLIDATION_METHOD_ID CONSOLIDATION_METHOD_ID
FROM WMS_OP_PLAN_DETAILS D
, WMS_OP_PLANS_B WOPB
, (SELECT LOOKUP_CODE
, MEANING
FROM MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'WMS_OP_DEST_SELECTION_MODE') ML1
, /* ZONE METHOD*/ (SELECT LOOKUP_CODE
, MEANING
FROM MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'WMS_OP_DEST_SELECTION_MODE') ML2
, /* SUB METHOD */ (SELECT LOOKUP_CODE
, MEANING
FROM MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'WMS_OP_DEST_SELECTION_MODE') ML3
, /* LOC METHOD */ (SELECT LOOKUP_CODE
, MEANING
FROM MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'WMS_OP_DEST_SELECTION_MODE') ML4
, /* LPN METHOD */ (SELECT LOOKUP_CODE
, MEANING
FROM MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'WMS_DROP_LPN_OPTION') ML5
, /* DROP LPN OPTION */ (SELECT LOOKUP_CODE
, MEANING
FROM MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'WMS_MTRL_GRP_RULES') ML6
, /* LOC MMG */ (SELECT LOOKUP_CODE
, MEANING
FROM MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'WMS_MTRL_GRP_RULES') ML7
, /* LPN MMG */ MFG_LOOKUPS ML9
, /* OPERATION NAME */ (SELECT ZONE_ID
, ZONE_NAME
FROM WMS_ZONES_TL
WHERE LANGUAGE = USERENV('LANG') ) ZONE
, MTL_ITEM_LOCATIONS_KFV MILK
, (SELECT ML.MEANING LOC_DEST_SUG_API
, WAHC1.HOOK_CALL_ID
FROM WMS_API_HOOK_CALLS WAHC1
, MFG_LOOKUPS ML
WHERE ML.LOOKUP_TYPE ='WMS_CHILD_SHORT_NAMES'
AND ML.LOOKUP_CODE = WAHC1.DESCRIPTION_ID UNION SELECT WAHC.DESCRIPTION
, WAHC.HOOK_CALL_ID
FROM WMS_API_HOOK_CALLS WAHC
WHERE SEED_FLAG = 'N'
AND MODULE_HOOK_ID = 100) WAHC_LOC
, (SELECT ML.MEANING LPN_DEST_SUG_API
, WAHC2.HOOK_CALL_ID
FROM WMS_API_HOOK_CALLS WAHC2
, MFG_LOOKUPS ML
WHERE ML.LOOKUP_TYPE ='WMS_CHILD_SHORT_NAMES'
AND ML.LOOKUP_CODE = WAHC2.DESCRIPTION_ID UNION SELECT WAHC.DESCRIPTION
, WAHC.HOOK_CALL_ID
FROM WMS_API_HOOK_CALLS WAHC
WHERE SEED_FLAG = 'N'
AND MODULE_HOOK_ID = 200) WAHC_LPN
, (SELECT OPERATION_PLAN_NAME
, OPERATION_PLAN_ID
FROM WMS_OP_PLANS_VL
WHERE USER_DEFINED = 'N'
AND ACTIVITY_TYPE_ID = 2) SUB_PLAN /* SUBSEQUENT SEEDED OUTBOUND PLAN*/
, (SELECT MEANING
, LOOKUP_CODE
FROM MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'WMS_CONSOL_METHODS') ML10 /* CONSOLIDATION METHOD */
WHERE D.ZONE_SELECTION_CRITERIA = ML1.LOOKUP_CODE (+)
AND D.SUB_SELECTION_CRITERIA = ML2.LOOKUP_CODE (+)
AND D.LOC_SELECTION_CRITERIA = ML3.LOOKUP_CODE (+)
AND D.LPN_SELECTION_CRITERIA = ML4.LOOKUP_CODE (+)
AND D.DROP_LPN_OPTION = ML5.LOOKUP_CODE (+)
AND D.LOC_MTRL_GRP_RULE_ID = ML6.LOOKUP_CODE (+)
AND D.LPN_MTRL_GRP_RULE_ID = ML7.LOOKUP_CODE (+)
AND ML9.LOOKUP_TYPE = 'WMS_OPERATION_TYPE'
AND D.OPERATION_TYPE = ML9.LOOKUP_CODE
AND D.PRE_SPECIFIED_ZONE_ID = ZONE.ZONE_ID (+)
AND D.PRE_SPECIFIED_LOC_ID = MILK.INVENTORY_LOCATION_ID (+)
AND D.ORGANIZATION_ID = MILK.ORGANIZATION_ID (+)
AND D.LOC_SELECTION_API_ID = WAHC_LOC.HOOK_CALL_ID (+)
AND D.LPN_SELECTION_API_ID = WAHC_LPN.HOOK_CALL_ID (+)
AND D.OPERATION_PLAN_ID = WOPB.OPERATION_PLAN_ID
AND D.SUBSEQUENT_OP_PLAN_ID = SUB_PLAN.OPERATION_PLAN_ID (+)
AND D.CONSOLIDATION_METHOD_ID = ML10.LOOKUP_CODE (+)