APPS.BOM_VALIDATE_RTG_HEADER dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1278: FROM bom_operational_routings

1274: )
1275: IS
1276: SELECT NVL(common_routing_sequence_id, routing_sequence_id)
1277: common_routing, routing_sequence_id
1278: FROM bom_operational_routings
1279: WHERE assembly_item_id = P_assembly_item_id
1280: AND organization_id = P_org_id
1281: AND NVL(alternate_routing_designator,'XXXX') =
1282: NVL(P_alt_routing_code, 'XXXX');

Line 1296: FROM bom_operational_routings bor

1292: SELECT 1 dummy
1293: FROM sys.dual
1294: WHERE not exists (
1295: SELECT NULL
1296: FROM bom_operational_routings bor
1297: WHERE bor.routing_sequence_id = P_cmn_rtg_id
1298: AND NVL(bor.alternate_routing_designator,
1299: 'Primary Alternate') = NVL(P_alt_desg, 'Primary Alternate')
1300: AND bor.common_routing_sequence_id =

Line 1329: FROM bom_operational_routings

1325: IS
1326: SELECT 'Y'
1327: FROM sys.dual
1328: WHERE exists ( Select null
1329: FROM bom_operational_routings
1330: WHERE common_routing_sequence_id <>
1331: p_common_routing_sequence_id
1332: AND CTP_flag = 1
1333: AND organization_id = p_organization_id

Line 1365: FROM Bom_Operational_Routings

1361: IS
1362: SELECT 'Y'
1363: FROM sys.dual
1364: WHERE exists ( Select null
1365: FROM Bom_Operational_Routings
1366: WHERE organization_id = P_organization_id
1367: AND assembly_item_id = P_assembly_item_id
1368: AND mixed_model_map_flag = 1
1369: AND line_id = p_line_id

Line 1384: FROM Bom_Operational_Routings

1380: IS
1381: SELECT 'Y'
1382: FROM sys.dual
1383: WHERE exists ( Select null
1384: FROM Bom_Operational_Routings
1385: WHERE organization_id = p_organization_id
1386: AND Assembly_Item_Id = p_assembly_item_id
1387: AND priority = p_priority
1388: AND common_routing_sequence_id <>

Line 1631: FROM bom_operational_routings

1627: THEN
1628: BEGIN
1629: SELECT '1'
1630: INTO l_dummy
1631: FROM bom_operational_routings
1632: WHERE alternate_routing_designator IS NULL
1633: AND assembly_item_id =
1634: p_rtg_header_unexp_rec.assembly_item_id
1635: AND organization_id =

Line 1758: FROM bom_operational_routings

1754: -- routing
1755: BEGIN
1756: SELECT '1'
1757: INTO l_dummy
1758: FROM bom_operational_routings
1759: WHERE routing_sequence_id =
1760: p_rtg_header_unexp_rec.common_routing_sequence_id
1761: AND NVL(common_routing_sequence_id,
1762: routing_sequence_id) <> routing_sequence_id;

Line 2651: l_cfm_routing_flag BOM_OPERATIONAL_ROUTINGS.CFM_ROUTING_FLAG%TYPE;

2647: , x_return_status IN OUT NOCOPY VARCHAR2
2648: )
2649: IS
2650:
2651: l_cfm_routing_flag BOM_OPERATIONAL_ROUTINGS.CFM_ROUTING_FLAG%TYPE;
2652: l_ser_num_control_code MTL_SYSTEM_ITEMS_B.SERIAL_NUMBER_CONTROL_CODE%TYPE;
2653: l_ser_start_op_seq BOM_OPERATIONAL_ROUTINGS.SERIALIZATION_START_OP%TYPE;
2654: l_nw_opern_count NUMBER;
2655: l_retval INTEGER;

Line 2653: l_ser_start_op_seq BOM_OPERATIONAL_ROUTINGS.SERIALIZATION_START_OP%TYPE;

2649: IS
2650:
2651: l_cfm_routing_flag BOM_OPERATIONAL_ROUTINGS.CFM_ROUTING_FLAG%TYPE;
2652: l_ser_num_control_code MTL_SYSTEM_ITEMS_B.SERIAL_NUMBER_CONTROL_CODE%TYPE;
2653: l_ser_start_op_seq BOM_OPERATIONAL_ROUTINGS.SERIALIZATION_START_OP%TYPE;
2654: l_nw_opern_count NUMBER;
2655: l_retval INTEGER;
2656: l_start_op_seq_id NUMBER;
2657: l_errcode NUMBER;

Line 2680: FROM BOM_OPERATIONAL_ROUTINGS bor, MTL_SYSTEM_ITEMS_B msib

2676: msib.SERIAL_NUMBER_CONTROL_CODE
2677: INTO l_cfm_routing_flag,
2678: l_ser_start_op_seq,
2679: l_ser_num_control_code
2680: FROM BOM_OPERATIONAL_ROUTINGS bor, MTL_SYSTEM_ITEMS_B msib
2681: WHERE
2682: bor.ASSEMBLY_ITEM_ID = msib.INVENTORY_ITEM_ID
2683: AND bor.ORGANIZATION_ID = msib.ORGANIZATION_ID
2684: AND bor.ROUTING_SEQUENCE_ID = p_routing_sequence_id;