APPS.WSM_JOBCOPIES_PUB dependencies on BOM_BILL_OF_MATERIALS

Line 261: FROM bom_bill_of_materials

257: -- Get the common bill sequence id
258: BEGIN
259: SELECT common_bill_sequence_id
260: INTO l_cmn_bill_seq_id
261: FROM bom_bill_of_materials
262: WHERE organization_id = p_org_id
263: AND assembly_item_id = l_bill_item_id
264: AND nvl(alternate_bom_designator, '-1') =
265: nvl(l_alt_bom_designator, '-1');