DBA Data[Home] [Help]

APPS.INVPAGI3 dependencies on DUAL

Line 174: from dual;

170:
171: /*
172: select MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
173: into tran_id
174: from dual;
175: */
176: dumm_status := INVPUOPI.mtl_log_interface_err(
177: cr.organization_id,
178: user_id,

Line 223: from dual;

219: for cr in ff loop
220:
221: select MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
222: into tran_id
223: from dual;
224:
225: update mtl_item_revisions_interface
226: set transaction_id = tran_id
227: where inventory_item_id = cr.inventory_item_id

Line 239: from dual;

235: /* Assigning Revision Ids to all CREATE records during default phase - R12C */
236: FOR cr IN c_null_rev_id LOOP
237: select MTL_ITEM_REVISIONS_B_S.nextval
238: into rev_id
239: from dual;
240:
241: update mtl_item_revisions_interface
242: set revision_id = rev_id
243: where rowid = cr.rowid;