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 1379: FROM BOM_OPERATIONAL_ROUTINGS

1375: IS
1376: SELECT 'CTP not unique'
1377: FROM SYS.DUAL
1378: WHERE EXISTS (SELECT NULL
1379: FROM BOM_OPERATIONAL_ROUTINGS
1380: WHERE ctp_flag = 1 -- Yes
1381: AND NVL(cfm_routing_flag, 2) = NVL(p_cfm_routing_flag, 2)
1382: AND organization_id = p_organization_id
1383: AND assembly_item_id = p_revised_item_id

Line 1423: FROM BOM_OPERATIONAL_ROUTINGS

1419: IS
1420: SELECT 'Priority not unique'
1421: FROM SYS.DUAL
1422: WHERE EXISTS (SELECT NULL
1423: FROM BOM_OPERATIONAL_ROUTINGS
1424: WHERE priority = p_priority
1425: AND NVL(cfm_routing_flag, 2) = NVL(p_cfm_routing_flag, 2)
1426: AND organization_id = p_organization_id
1427: AND assembly_item_id = p_revised_item_id) ;

Line 1811: , BOM_OPERATIONAL_ROUTINGS bor

1807: IS
1808:
1809: SELECT 'Rev Item is only Eco for altenate routing'
1810: FROM ENG_REVISED_ITEMS eri
1811: , BOM_OPERATIONAL_ROUTINGS bor
1812: WHERE bor.alternate_routing_designator IS NOT NULL
1813: AND eri.routing_sequence_id = bor.routing_sequence_id(+)
1814: AND eri.routing_sequence_id IS NOT NULL
1815: AND eri.bill_sequence_id IS NULL

Line 1976: FROM BOM_OPERATIONAL_ROUTINGS

1972: , p_organization_id NUMBER)
1973: IS
1974:
1975: SELECT 1
1976: FROM BOM_OPERATIONAL_ROUTINGS
1977: WHERE assembly_item_id = p_revied_item_id
1978: AND organization_id = p_organization_id
1979: AND NVL(alternate_routing_designator, 'NONE') = 'NONE';
1980:

Line 2341: FROM BOM_OPERATIONAL_ROUTINGS

2337: SELECT completion_subinventory
2338: , completion_locator_id
2339: , ctp_flag
2340: , priority
2341: FROM BOM_OPERATIONAL_ROUTINGS
2342: WHERE assembly_item_id = p_revised_item_id
2343: AND organization_id = p_org_id
2344: AND alternate_routing_designator = p_alternate_routing_code
2345: ;

Line 2399: FROM BOM_OPERATIONAL_ROUTINGS

2395:
2396: CURSOR c_GetRtgAltDesignator
2397: IS
2398: SELECT alternate_routing_designator
2399: FROM BOM_OPERATIONAL_ROUTINGS
2400: WHERE routing_sequence_id = NVL( p_rev_item_unexp_rec.routing_sequence_id
2401: , FND_API.G_MISS_NUM );
2402:
2403: