APPS.BOM_COPY_BILL dependencies on BOM_OPERATIONAL_ROUTINGS

Line 4916: FROM bom_operational_routings

4912: sql_stmt_num := 25;
4913:
4914: SELECT common_routing_sequence_id
4915: INTO to_rtg_seq_id
4916: FROM bom_operational_routings
4917: WHERE organization_id = to_org_id
4918: AND assembly_item_id = to_item_id
4919: AND (NVL (alternate_routing_designator, 'NONE') =
4920: NVL (to_alternate, 'NONE')

Line 4925: FROM bom_operational_routings bor2

4921: OR (to_alternate IS NOT NULL
4922: AND alternate_routing_designator IS NULL
4923: AND NOT EXISTS (
4924: SELECT NULL
4925: FROM bom_operational_routings bor2
4926: WHERE bor2.organization_id = to_org_id
4927: AND bor2.assembly_item_id = to_item_id
4928: AND bor2.alternate_routing_designator =
4929: to_alternate)

Line 10550: FROM bom_operational_routings

10546: IF ( p_cpy_past_eff_comps = 'Y' ) THEN
10547:
10548: SELECT common_routing_sequence_id
10549: INTO to_rtg_seq_id
10550: FROM bom_operational_routings
10551: WHERE organization_id = to_org_id
10552: AND assembly_item_id = to_item_id
10553: AND (NVL (alternate_routing_designator, 'NONE') =
10554: NVL (to_alternate, 'NONE')

Line 10559: FROM bom_operational_routings bor2

10555: OR (to_alternate IS NOT NULL
10556: AND alternate_routing_designator IS NULL
10557: AND NOT EXISTS (
10558: SELECT NULL
10559: FROM bom_operational_routings bor2
10560: WHERE bor2.organization_id = to_org_id
10561: AND bor2.assembly_item_id = to_item_id
10562: AND bor2.alternate_routing_designator =
10563: to_alternate)