DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_SR_INVENTORY_ITEM_ID_S

Line 22977: SET sr_inventory_item_id = msc_st_sr_inventory_item_id_s.NEXTVAL

22973:
22974: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
22975:
22976: UPDATE msc_st_system_items
22977: SET sr_inventory_item_id = msc_st_sr_inventory_item_id_s.NEXTVAL
22978: WHERE rowid = lb_rowid(j);
22979:
22980: v_sql_stmt := 10;
22981:

Line 31687: SET department_id = msc_st_sr_inventory_item_id_s.NEXTVAL

31683:
31684: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
31685:
31686: UPDATE msc_st_department_resources
31687: SET department_id = msc_st_sr_inventory_item_id_s.NEXTVAL
31688: WHERE rowid = lb_rowid(j);
31689:
31690:
31691: v_sql_stmt := 14;

Line 31851: SET resource_id = msc_st_sr_inventory_item_id_s.NEXTVAL

31847:
31848: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
31849:
31850: UPDATE msc_st_department_resources
31851: SET resource_id = msc_st_sr_inventory_item_id_s.NEXTVAL
31852: WHERE rowid = lb_rowid(j);
31853:
31854:
31855: v_sql_stmt := 20;

Line 31936: SET department_id = msc_st_sr_inventory_item_id_s.NEXTVAL

31932:
31933: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
31934:
31935: UPDATE msc_st_department_resources
31936: SET department_id = msc_st_sr_inventory_item_id_s.NEXTVAL
31937: WHERE rowid = lb_rowid(j);
31938:
31939:
31940: v_sql_stmt := 23;