APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_BOMS_S

Line 35489: -- and MSC_ST_BOMS stores SR_INVENTORY_ITEM_ID in ASSEMBLY_ITEM_ID

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
35493: AND lid.INVENTORY_ITEM_ID = msb.ASSEMBLY_ITEM_ID ;

Line 35846: SET st_transaction_id = msc_st_boms_s.NEXTVAL,

35842:
35843: v_sql_stmt := 05;
35844: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
35845: UPDATE msc_st_boms
35846: SET st_transaction_id = msc_st_boms_s.NEXTVAL,
35847: refresh_id = v_refresh_id,
35848: last_update_date = v_current_date,
35849: last_updated_by = v_current_user,
35850: creation_date = v_current_date,