APPS.WSMPUTIL dependencies on BOM_STANDARD_OPERATIONS

Line 780: --MES replacing WSM_OPERATION_DETAILS with BOM_STANDARD_OPERATIONS

776: IF x_standard_operation_id <> -999 then
777: -- EA NSO-WLT
778:
779: l_stmt_num := 20;
780: --MES replacing WSM_OPERATION_DETAILS with BOM_STANDARD_OPERATIONS
781: /*
782: -- BA NSO-WLT
783: SELECT WOD.SECONDARY_INVENTORY_NAME,
784: WOD.INVENTORY_LOCATION_ID

Line 800: FROM BOM_STANDARD_OPERATIONS BSO,

796: SELECT BSO.DEFAULT_SUBINVENTORY,
797: BSO.DEFAULT_LOCATOR_ID
798: INTO x_subinventory_code,
799: x_locator_id
800: FROM BOM_STANDARD_OPERATIONS BSO,
801: BOM_OPERATION_SEQUENCES BOS
802: WHERE BOS.operation_sequence_id = l_operation_seq_id
803: AND BOS.routing_sequence_id = p_routing_sequence_id
804: AND nvl(BSO.standard_operation_id, -999) = nvl(BOS.standard_operation_id, -999)

Line 1137: --MES replacing WSM_OPERATION_DETAILS with BOM_STANDARD_OPERATIONS

1133: WHERE operation_sequence_id = p_end_id;
1134:
1135: IF x_standard_operation_id <> -999 then
1136: -- EA NSO-WLT
1137: --MES replacing WSM_OPERATION_DETAILS with BOM_STANDARD_OPERATIONS
1138: /*
1139: SELECT secondary_inventory_name, inventory_location_id
1140: INTO x_completion_subinventory,x_inventory_location_id
1141: FROM wsm_operation_details

Line 1147: FROM BOM_STANDARD_OPERATIONS

1143: AND organization_id = p_org_id;
1144: */
1145: SELECT DEFAULT_SUBINVENTORY, DEFAULT_LOCATOR_ID
1146: INTO x_completion_subinventory,x_inventory_location_id
1147: FROM BOM_STANDARD_OPERATIONS
1148: WHERE standard_operation_id = x_standard_operation_id
1149: AND organization_id = p_org_id;
1150:
1151: IF x_completion_subinventory IS NULL THEN

Line 2024: from bom_standard_operations

2020: Begin
2021:
2022: select nvl(standard_operation_id, -999)
2023: into l_std_op_id
2024: from bom_standard_operations
2025: where organization_id = p_organization_id -- BBK
2026: and operation_type = 1 -- Standard Operation Type BBK
2027: and line_id is NULL -- Not for a WIP Line BBK
2028: and operation_code = p_operation_code;