APPS.WSMPLBJI dependencies on BOM_OPERATIONAL_ROUTINGS

Line 2026: FROM BOM_OPERATIONAL_ROUTINGS BOR

2022: end if;
2023:
2024: l_stat_num := 90.5;
2025: SELECT common_routing_sequence_id INTO l_routing_seq_id
2026: FROM BOM_OPERATIONAL_ROUTINGS BOR
2027: WHERE BOR.assembly_item_id= decode(p_job_type,1,p_assembly_item_id,p_rtg_reference_id)
2028: AND nvl(BOR.alternate_routing_designator, '***') = nvl(p_alt_rtg_designator, '***')
2029: and bor.organization_id = p_organization_id;
2030:

Line 4024: from bom_operational_routings bor,

4020: into routing_seq_id,
4021: l_default_subinventory,
4022: l_default_compl_loc_id
4023: --from bom_routing_alternates_v bor
4024: from bom_operational_routings bor,
4025: bom_alternate_designators bad
4026: where ((bor.alternate_routing_designator is null and
4027: bad.alternate_designator_code is null
4028: and bad.organization_id = -1)

Line 5611: from bom_operational_routings bor, bom_alternate_designators bad

5607: bor.COMPLETION_LOCATOR_ID
5608: into p_common_routing_sequence_id,
5609: l_default_subinventory,
5610: l_default_compl_loc_id
5611: from bom_operational_routings bor, bom_alternate_designators bad
5612: where ((bor.alternate_routing_designator is null and bad.alternate_designator_code is null
5613: and bad.organization_id = -1)
5614: or (bor.alternate_routing_designator = bad.alternate_designator_code
5615: and bor.organization_id = bad.organization_id))