DBA Data[Home] [Help]

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