DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_SUB_INVENTORIES

Line 34308: FROM msc_sub_inventories msi

34304: v_sql_stmt := 2.2;
34305: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
34306: UPDATE msc_st_supplies mss
34307: SET mss.condition_type = (SELECT nvl(msi.condition_type,'G' )
34308: FROM msc_sub_inventories msi
34309: WHERE msi.organization_id = mss.organization_id
34310: AND msi.plan_id = -1
34311: AND msi.sub_inventory_code = mss.subinventory_code
34312: AND msi.sr_instance_id = v_instance_id