APPS.WSMPLBJI dependencies on BOM_ALTERNATE_DESIGNATORS

Line 4019: bom_alternate_designators bad

4015: l_default_subinventory,
4016: l_default_compl_loc_id
4017: --from bom_routing_alternates_v bor
4018: from bom_operational_routings bor,
4019: bom_alternate_designators bad
4020: where ((bor.alternate_routing_designator is null and
4021: bad.alternate_designator_code is null
4022: and bad.organization_id = -1)
4023: or (bor.alternate_routing_designator = bad.alternate_designator_code

Line 4147: bom_alternate_designators bad

4143:
4144: SELECT bom.common_bill_sequence_id
4145: INTO bom_seq_id
4146: FROM bom_bill_of_materials bom,
4147: bom_alternate_designators bad
4148: WHERE ((bom.alternate_bom_designator is null and
4149: bad.alternate_designator_code is null
4150: and bad.organization_id = -1)
4151: OR (bom.alternate_bom_designator = bad.alternate_designator_code

Line 5605: from bom_operational_routings bor, bom_alternate_designators bad

5601: bor.COMPLETION_LOCATOR_ID
5602: into p_common_routing_sequence_id,
5603: l_default_subinventory,
5604: l_default_compl_loc_id
5605: from bom_operational_routings bor, bom_alternate_designators bad
5606: where ((bor.alternate_routing_designator is null and bad.alternate_designator_code is null
5607: and bad.organization_id = -1)
5608: or (bor.alternate_routing_designator = bad.alternate_designator_code
5609: and bor.organization_id = bad.organization_id))

Line 5710: FROM bom_bill_of_materials bom, bom_alternate_designators bad

5706: ELSE
5707: begin
5708: SELECT bom.common_bill_sequence_id
5709: INTO p_common_bill_sequence_id
5710: FROM bom_bill_of_materials bom, bom_alternate_designators bad
5711: WHERE ((bom.alternate_bom_designator is null and bad.alternate_designator_code is null
5712: and bad.organization_id = -1)
5713: OR (bom.alternate_bom_designator = bad.alternate_designator_code
5714: and bom.organization_id = bad.organization_id))