APPS.ENG_GLOBALS dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1703: INSERT INTO BOM_OPERATIONAL_ROUTINGS

1699:
1700: --
1701: -- Create New Routing using Routing Information in Revised Item table
1702: --
1703: INSERT INTO BOM_OPERATIONAL_ROUTINGS
1704: ( assembly_item_id
1705: , organization_id
1706: , alternate_routing_designator
1707: , pending_from_ecn

Line 2088: FROM BOM_OPERATIONAL_ROUTINGS

2084: IS
2085: SELECT 'Routing Exists'
2086: FROM DUAL
2087: WHERE NOT EXISTS ( SELECT routing_sequence_id
2088: FROM BOM_OPERATIONAL_ROUTINGS
2089: WHERE assembly_item_id = p_revised_item_id
2090: AND organization_id = p_organization_id
2091: AND NVL(alternate_routing_designator, FND_API.G_MISS_CHAR) =
2092: NVL(p_alternate_rtg_code,FND_API.G_MISS_CHAR)

Line 2107: SELECT BOM_OPERATIONAL_ROUTINGS_S.NEXTVAL routing_sequence_id

2103:
2104: -- Get Routing_Sequence_id
2105: CURSOR l_get_rtg_seq_csr
2106: IS
2107: SELECT BOM_OPERATIONAL_ROUTINGS_S.NEXTVAL routing_sequence_id
2108: FROM DUAL ;
2109:
2110:
2111: BEGIN

Line 2328: FROM BOM_OPERATIONAL_ROUTINGS

2324: l_routing_type NUMBER := 0;
2325:
2326: cursor c_CheckRtgType IS
2327: SELECT 1
2328: FROM BOM_OPERATIONAL_ROUTINGS
2329: WHERE assembly_item_id = p_revised_item_id
2330: AND organization_id = p_organization_id
2331: AND alternate_routing_designator is null
2332: AND ((routing_type = 1 and l_routing_type = 1)

Line 2403: FROM BOM_OPERATIONAL_ROUTINGS

2399: IS
2400: SELECT 'Routing Exists'
2401: FROM DUAL
2402: WHERE NOT EXISTS ( SELECT routing_sequence_id
2403: FROM BOM_OPERATIONAL_ROUTINGS
2404: WHERE assembly_item_id = p_revised_item_id
2405: AND organization_id = p_organization_id
2406: AND alternate_routing_designator = p_alternate_rtg_code
2407: );

Line 2421: SELECT BOM_OPERATIONAL_ROUTINGS_S.NEXTVAL routing_sequence_id

2417:
2418: -- Get Routing_Sequence_id
2419: CURSOR l_get_rtg_seq_csr
2420: IS
2421: SELECT BOM_OPERATIONAL_ROUTINGS_S.NEXTVAL routing_sequence_id
2422: FROM DUAL ;
2423:
2424:
2425: BEGIN