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 4185: FROM bom_bill_of_materials bom

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

Line 5929: FROM bom_bill_of_materials bbom

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