APPS.MSC_CL_PRE_PROCESS dependencies on MSC_SUB_INVENTORIES

Line 29975: FROM msc_sub_inventories msi

29971: v_sql_stmt := 2.2;
29972: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
29973: UPDATE msc_st_supplies mss
29974: SET mss.condition_type = (SELECT nvl(msi.condition_type,'G' )
29975: FROM msc_sub_inventories msi
29976: WHERE msi.organization_id = mss.organization_id
29977: AND msi.plan_id = -1
29978: AND msi.sub_inventory_code = mss.subinventory_code
29979: AND msi.sr_instance_id = v_instance_id