APPS.MSC_CL_PRE_PROCESS dependencies on MSC_BOMS

Line 40086: || ' from msc_boms mb, MSC_ITEM_ID_LID lid '

40082: || ' AND msb.process_flag = '|| G_VALID
40083: || ' and sr_instance_code = :v_instance_code '
40084: || ' UNION '
40085: || ' select mb.bill_sequence_id,mb.rowid,1 '
40086: || ' from msc_boms mb, MSC_ITEM_ID_LID lid '
40087: || ' where mb.assembly_item_id = lid.INVENTORY_ITEM_ID '
40088: || ' and mb.sr_instance_id= :v_instance_id '
40089: || ' and lid.SR_INVENTORY_ITEM_ID = :lv_assembly_item_id '
40090: || ' and lid.SR_INSTANCE_ID = :v_instance_id '

Line 40272: -- note the join on MSC_ITEM_ID_LID because MSC_BOMS stores ASSEMBLY_ITEM_ID

40268: (l_split_cur1/100),
40269: 2,
40270: v_refresh_id,
40271: v_instance_id
40272: -- note the join on MSC_ITEM_ID_LID because MSC_BOMS stores ASSEMBLY_ITEM_ID
40273: -- and MSC_ST_BOMS stores SR_INVENTORY_ITEM_ID in ASSEMBLY_ITEM_ID
40274: FROM MSC_BOMS msb ,MSC_ITEM_ID_LID lid
40275: WHERE msb. BILL_SEQUENCE_ID = l_bill_sequence_id_cur2
40276: And lid.SR_INSTANCE_ID = msb.SR_INSTANCE_ID

Line 40274: FROM MSC_BOMS msb ,MSC_ITEM_ID_LID lid

40270: v_refresh_id,
40271: v_instance_id
40272: -- note the join on MSC_ITEM_ID_LID because MSC_BOMS stores ASSEMBLY_ITEM_ID
40273: -- and MSC_ST_BOMS stores SR_INVENTORY_ITEM_ID in ASSEMBLY_ITEM_ID
40274: FROM MSC_BOMS msb ,MSC_ITEM_ID_LID lid
40275: WHERE msb. BILL_SEQUENCE_ID = l_bill_sequence_id_cur2
40276: And lid.SR_INSTANCE_ID = msb.SR_INSTANCE_ID
40277: AND lid.INVENTORY_ITEM_ID = msb.ASSEMBLY_ITEM_ID ;
40278: