APPS.WSM_JOBCOPIES_PUB dependencies on BOM_BILL_OF_MATERIALS

Line 248: FROM bom_bill_of_materials

244: -- Get the common bill sequence id
245: BEGIN
246: SELECT common_bill_sequence_id
247: INTO l_cmn_bill_seq_id
248: FROM bom_bill_of_materials
249: WHERE organization_id = p_org_id
250: AND assembly_item_id = l_bill_item_id
251: AND nvl(alternate_bom_designator, '-1') =
252: nvl(l_alt_bom_designator, '-1');