APPS.WSMPLBJI dependencies on BOM_ALTERNATE_DESIGNATORS

Line 4025: bom_alternate_designators bad

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)
4029: or (bor.alternate_routing_designator = bad.alternate_designator_code

Line 4153: bom_alternate_designators bad

4149:
4150: SELECT bom.common_bill_sequence_id
4151: INTO bom_seq_id
4152: FROM bom_bill_of_materials bom,
4153: bom_alternate_designators bad
4154: WHERE ((bom.alternate_bom_designator is null and
4155: bad.alternate_designator_code is null
4156: and bad.organization_id = -1)
4157: OR (bom.alternate_bom_designator = bad.alternate_designator_code

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))

Line 5716: FROM bom_bill_of_materials bom, bom_alternate_designators bad

5712: ELSE
5713: begin
5714: SELECT bom.common_bill_sequence_id
5715: INTO p_common_bill_sequence_id
5716: FROM bom_bill_of_materials bom, bom_alternate_designators bad
5717: WHERE ((bom.alternate_bom_designator is null and bad.alternate_designator_code is null
5718: and bad.organization_id = -1)
5719: OR (bom.alternate_bom_designator = bad.alternate_designator_code
5720: and bom.organization_id = bad.organization_id))