APPS.BOM_OP_SEQ_UTIL dependencies on BOM_OPERATIONAL_ROUTINGS

Line 484: FROM bom_operational_routings

480: IS
481: SELECT 'Routing Exists'
482: FROM DUAL
483: WHERE NOT EXISTS ( SELECT routing_sequence_id
484: FROM bom_operational_routings
485: WHERE assembly_item_id = p_revised_item_id
486: AND organization_id = p_organization_id
487: AND NVL(alternate_routing_designator, FND_API.G_MISS_CHAR) =
488: NVL(p_alternate_rtg_code,FND_API.G_MISS_CHAR)

Line 503: SELECT bom_operational_routings_s.NEXTVAL routing_sequence_id

499:
500: -- Get Routing_Sequence_id
501: CURSOR l_get_rtg_seq_csr
502: IS
503: SELECT bom_operational_routings_s.NEXTVAL routing_sequence_id
504: FROM DUAL ;
505:
506: BEGIN
507: --

Line 850: INSERT INTO bom_operational_routings

846:
847: --
848: -- Create New Routing using Routing Information in Revised Item table
849: --
850: INSERT INTO bom_operational_routings
851: ( assembly_item_id
852: , organization_id
853: , alternate_routing_designator
854: , pending_from_ecn

Line 1823: , bom_operational_routings bor

1819: , bic.PROGRAM_UPDATE_DATE = SYSDATE
1820: WHERE bic.operation_seq_num = p_com_operation_rec.operation_sequence_number
1821: AND bic.bill_sequence_id = (SELECT bom.BILL_SEQUENCE_ID
1822: FROM BOM_BILL_OF_MATERIALS bom
1823: , bom_operational_routings bor
1824: WHERE NVL(bor.alternate_routing_designator, 'NONE')
1825: = nvl(bom.alternate_bom_designator,'NONE')
1826: AND bom.assembly_item_id = bor.assembly_item_id
1827: AND bom.organization_id = bor.organization_id

Line 2028: select routing_type into l_rtg_type from bom_operational_routings

2024: l_com_operation_rec.alternate_routing_code := NULL ;
2025: END IF ;
2026:
2027: -- bug 5199643
2028: select routing_type into l_rtg_type from bom_operational_routings
2029: where routing_sequence_id = l_com_op_unexp_rec.routing_sequence_id;
2030:
2031:
2032: l_dg_sequence_id :=