APPS.BOM_DEFAULT_RTG_HEADER dependencies on BOM_OPERATIONAL_ROUTINGS

Line 37: SELECT bom_operational_routings_s.nextval

33: IS
34: l_routing_sequence_id NUMBER := NULL;
35: BEGIN
36:
37: SELECT bom_operational_routings_s.nextval
38: INTO l_routing_sequence_id
39: FROM sys.dual;
40:
41: RETURN l_routing_sequence_id;

Line 238: BOM_OPERATIONAL_ROUTINGS

234: SELECT
235: COMPLETION_SUBINVENTORY,
236: COMPLETION_LOCATOR_ID
237: FROM
238: BOM_OPERATIONAL_ROUTINGS
239: WHERE
240: ROUTING_SEQUENCE_ID = P_CommRtgSeqId
241: AND ORGANIZATION_ID = P_OrgId
242: AND NVL(ALTERNATE_ROUTING_DESIGNATOR, 'primary alternate') =

Line 538: BOM_OPERATIONAL_ROUTINGS

534: SELECT
535: COMPLETION_SUBINVENTORY,
536: COMPLETION_LOCATOR_ID
537: FROM
538: BOM_OPERATIONAL_ROUTINGS
539: WHERE
540: ROUTING_SEQUENCE_ID = P_CommRtgSeqId
541: AND ORGANIZATION_ID = P_OrgId
542: AND NVL(ALTERNATE_ROUTING_DESIGNATOR, 'primary alternate') =