APPS.WSMPUTIL dependencies on BOM_BILL_OF_MATERIALS

Line 2399: FROM bom_bill_of_materials bom

2395: if p_bom_reference_id is not null then
2396: BEGIN
2397: SELECT bom.common_bill_sequence_id
2398: INTO x_bom_seq_id
2399: FROM bom_bill_of_materials bom
2400: WHERE NVL(bom.alternate_bom_designator, '&*') = NVL(p_alt_bom_designator, '&*')
2401: AND BOM.assembly_item_id = p_bom_reference_id
2402: AND bom.organization_id = p_organization_id;
2403: EXCEPTION

Line 4188: FROM bom_bill_of_materials bom

4184:
4185: begin
4186: SELECT bom.common_bill_sequence_id
4187: INTO p_bom_seq_id
4188: FROM bom_bill_of_materials bom
4189: WHERE bom.alternate_bom_designator is null
4190: AND bom.assembly_item_id = p_kanban_assembly_id
4191: AND bom.organization_id = p_organization_id;
4192: exception

Line 5932: FROM bom_bill_of_materials bbom

5928: return null;
5929: else
5930: SELECT bbom.bill_sequence_id
5931: INTO l_bom_seq_id
5932: FROM bom_bill_of_materials bbom
5933: WHERE bbom.common_bill_sequence_id = l_common_bom_seq_id
5934: AND bbom.organization_id = l_org_id
5935: AND bbom.assembly_item_id = l_bom_item_id
5936: AND nvl(bbom.alternate_bom_designator, '-@#$%') = nvl(l_alt_bom, '-@#$%');