APPS.MSC_CL_PRE_PROCESS dependencies on MSC_BOMS

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

35298: || ' AND msb.process_flag = '|| G_VALID
35299: || ' and sr_instance_code = :v_instance_code '
35300: || ' UNION '
35301: || ' select mb.bill_sequence_id,mb.rowid,1 '
35302: || ' from msc_boms mb, MSC_ITEM_ID_LID lid '
35303: || ' where mb.assembly_item_id = lid.INVENTORY_ITEM_ID '
35304: || ' and mb.sr_instance_id= :v_instance_id '
35305: || ' and lid.SR_INVENTORY_ITEM_ID = :lv_assembly_item_id '
35306: || ' and lid.SR_INSTANCE_ID = :v_instance_id '

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

35484: (l_split_cur1/100),
35485: 2,
35486: v_refresh_id,
35487: v_instance_id
35488: -- note the join on MSC_ITEM_ID_LID because MSC_BOMS stores ASSEMBLY_ITEM_ID
35489: -- and MSC_ST_BOMS stores SR_INVENTORY_ITEM_ID in ASSEMBLY_ITEM_ID
35490: FROM MSC_BOMS msb ,MSC_ITEM_ID_LID lid
35491: WHERE msb. BILL_SEQUENCE_ID = l_bill_sequence_id_cur2
35492: And lid.SR_INSTANCE_ID = msb.SR_INSTANCE_ID

Line 35490: FROM MSC_BOMS msb ,MSC_ITEM_ID_LID lid

35486: v_refresh_id,
35487: v_instance_id
35488: -- note the join on MSC_ITEM_ID_LID because MSC_BOMS stores ASSEMBLY_ITEM_ID
35489: -- and MSC_ST_BOMS stores SR_INVENTORY_ITEM_ID in ASSEMBLY_ITEM_ID
35490: FROM MSC_BOMS msb ,MSC_ITEM_ID_LID lid
35491: WHERE msb. BILL_SEQUENCE_ID = l_bill_sequence_id_cur2
35492: And lid.SR_INSTANCE_ID = msb.SR_INSTANCE_ID
35493: AND lid.INVENTORY_ITEM_ID = msb.ASSEMBLY_ITEM_ID ;
35494: