APPS.ENG_VALIDATE_REVISED_ITEM dependencies on BOM_OPERATIONAL_ROUTINGS

Line 849: FROM BOM_OPERATIONAL_ROUTINGS

845: l_rtg_exists NUMBER := 0;
846:
847: CURSOR l_checkprimary IS
848: SELECT routing_sequence_id
849: FROM BOM_OPERATIONAL_ROUTINGS
850: WHERE assembly_item_id = p_revised_item_id
851: AND organization_id = p_organization_id
852: AND alternate_routing_designator IS NULL
853: AND ( (routing_type = 1 and p_assembly_type = 1)

Line 935: from BOM_OPERATIONAL_ROUTINGS

931: l_count1 NUMBER := 0;
932: l_count2 NUMBER := 0;
933: cursor pending_on_eco is
934: select 1
935: from BOM_OPERATIONAL_ROUTINGS
936: where routing_sequence_id = p_routing_sequence_id
937: and pending_from_ecn is not null
938: and pending_from_ecn = p_change_notice;
939: cursor reference_common is

Line 941: from BOM_OPERATIONAL_ROUTINGS

937: and pending_from_ecn is not null
938: and pending_from_ecn = p_change_notice;
939: cursor reference_common is
940: select 1
941: from BOM_OPERATIONAL_ROUTINGS
942: where common_routing_sequence_id = p_routing_sequence_id
943: and common_routing_sequence_id <> routing_sequence_id;
944: BEGIN
945:

Line 1004: from BOM_OPERATIONAL_ROUTINGS

1000: )RETURN BOOLEAN
1001: IS
1002: l_dummy NUMBER;
1003: cursor common_exists is select 'Referencing'
1004: from BOM_OPERATIONAL_ROUTINGS
1005: where routing_sequence_id = p_routing_sequence_id
1006: and routing_sequence_id <> common_routing_sequence_id;
1007: BEGIN
1008: open common_exists;

Line 1314: FROM BOM_OPERATIONAL_ROUTINGS

1310: IS
1311: SELECT 'CTP not unique'
1312: FROM SYS.DUAL
1313: WHERE EXISTS (SELECT NULL
1314: FROM BOM_OPERATIONAL_ROUTINGS
1315: WHERE ctp_flag = 1 -- Yes
1316: AND NVL(cfm_routing_flag, 2) = NVL(p_cfm_routing_flag, 2)
1317: AND organization_id = p_organization_id
1318: AND assembly_item_id = p_revised_item_id

Line 1358: FROM BOM_OPERATIONAL_ROUTINGS

1354: IS
1355: SELECT 'Priority not unique'
1356: FROM SYS.DUAL
1357: WHERE EXISTS (SELECT NULL
1358: FROM BOM_OPERATIONAL_ROUTINGS
1359: WHERE priority = p_priority
1360: AND NVL(cfm_routing_flag, 2) = NVL(p_cfm_routing_flag, 2)
1361: AND organization_id = p_organization_id
1362: AND assembly_item_id = p_revised_item_id) ;

Line 1739: , BOM_OPERATIONAL_ROUTINGS bor

1735: IS
1736:
1737: SELECT 'Rev Item is only Eco for altenate routing'
1738: FROM ENG_REVISED_ITEMS eri
1739: , BOM_OPERATIONAL_ROUTINGS bor
1740: WHERE bor.alternate_routing_designator IS NOT NULL
1741: AND eri.routing_sequence_id = bor.routing_sequence_id(+)
1742: AND eri.routing_sequence_id IS NOT NULL
1743: AND eri.bill_sequence_id IS NULL

Line 1904: FROM BOM_OPERATIONAL_ROUTINGS

1900: , p_organization_id NUMBER)
1901: IS
1902:
1903: SELECT 1
1904: FROM BOM_OPERATIONAL_ROUTINGS
1905: WHERE assembly_item_id = p_revied_item_id
1906: AND organization_id = p_organization_id
1907: AND NVL(alternate_routing_designator, 'NONE') = 'NONE';
1908:

Line 2269: FROM BOM_OPERATIONAL_ROUTINGS

2265: SELECT completion_subinventory
2266: , completion_locator_id
2267: , ctp_flag
2268: , priority
2269: FROM BOM_OPERATIONAL_ROUTINGS
2270: WHERE assembly_item_id = p_revised_item_id
2271: AND organization_id = p_org_id
2272: AND alternate_routing_designator = p_alternate_routing_code
2273: ;

Line 2327: FROM BOM_OPERATIONAL_ROUTINGS

2323:
2324: CURSOR c_GetRtgAltDesignator
2325: IS
2326: SELECT alternate_routing_designator
2327: FROM BOM_OPERATIONAL_ROUTINGS
2328: WHERE routing_sequence_id = NVL( p_rev_item_unexp_rec.routing_sequence_id
2329: , FND_API.G_MISS_NUM );
2330:
2331: