APPS.BOM_COPY_BILL dependencies on BOM_OPERATIONAL_ROUTINGS

Line 4978: FROM bom_operational_routings

4974: sql_stmt_num := 25;
4975:
4976: SELECT common_routing_sequence_id
4977: INTO to_rtg_seq_id
4978: FROM bom_operational_routings
4979: WHERE organization_id = to_org_id
4980: AND assembly_item_id = to_item_id
4981: AND (NVL (alternate_routing_designator, 'NONE') =
4982: NVL (to_alternate, 'NONE')

Line 4987: FROM bom_operational_routings bor2

4983: OR (to_alternate IS NOT NULL
4984: AND alternate_routing_designator IS NULL
4985: AND NOT EXISTS (
4986: SELECT NULL
4987: FROM bom_operational_routings bor2
4988: WHERE bor2.organization_id = to_org_id
4989: AND bor2.assembly_item_id = to_item_id
4990: AND bor2.alternate_routing_designator =
4991: to_alternate)

Line 10703: FROM bom_operational_routings

10699: IF ( p_cpy_past_eff_comps = 'Y' ) THEN
10700:
10701: SELECT common_routing_sequence_id
10702: INTO to_rtg_seq_id
10703: FROM bom_operational_routings
10704: WHERE organization_id = to_org_id
10705: AND assembly_item_id = to_item_id
10706: AND (NVL (alternate_routing_designator, 'NONE') =
10707: NVL (to_alternate, 'NONE')

Line 10712: FROM bom_operational_routings bor2

10708: OR (to_alternate IS NOT NULL
10709: AND alternate_routing_designator IS NULL
10710: AND NOT EXISTS (
10711: SELECT NULL
10712: FROM bom_operational_routings bor2
10713: WHERE bor2.organization_id = to_org_id
10714: AND bor2.assembly_item_id = to_item_id
10715: AND bor2.alternate_routing_designator =
10716: to_alternate)