DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_SR_INVENTORY_ITEM_ID_S

Line 19488: SET sr_inventory_item_id = msc_st_sr_inventory_item_id_s.NEXTVAL

19484:
19485: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
19486:
19487: UPDATE msc_st_system_items
19488: SET sr_inventory_item_id = msc_st_sr_inventory_item_id_s.NEXTVAL
19489: WHERE rowid = lb_rowid(j);
19490:
19491: v_sql_stmt := 10;
19492:

Line 28133: SET department_id = msc_st_sr_inventory_item_id_s.NEXTVAL

28129:
28130: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
28131:
28132: UPDATE msc_st_department_resources
28133: SET department_id = msc_st_sr_inventory_item_id_s.NEXTVAL
28134: WHERE rowid = lb_rowid(j);
28135:
28136:
28137: v_sql_stmt := 14;

Line 28297: SET resource_id = msc_st_sr_inventory_item_id_s.NEXTVAL

28293:
28294: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
28295:
28296: UPDATE msc_st_department_resources
28297: SET resource_id = msc_st_sr_inventory_item_id_s.NEXTVAL
28298: WHERE rowid = lb_rowid(j);
28299:
28300:
28301: v_sql_stmt := 20;

Line 28382: SET department_id = msc_st_sr_inventory_item_id_s.NEXTVAL

28378:
28379: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
28380:
28381: UPDATE msc_st_department_resources
28382: SET department_id = msc_st_sr_inventory_item_id_s.NEXTVAL
28383: WHERE rowid = lb_rowid(j);
28384:
28385:
28386: v_sql_stmt := 23;