APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_BOMS_S

Line 40273: -- and MSC_ST_BOMS stores SR_INVENTORY_ITEM_ID in ASSEMBLY_ITEM_ID

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

Line 40630: SET st_transaction_id = msc_st_boms_s.NEXTVAL,

40626:
40627: v_sql_stmt := 05;
40628: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
40629: UPDATE msc_st_boms
40630: SET st_transaction_id = msc_st_boms_s.NEXTVAL,
40631: refresh_id = v_refresh_id,
40632: last_update_date = v_current_date,
40633: last_updated_by = v_current_user,
40634: creation_date = v_current_date,