DBA Data[Home] [Help]

APPS.INVPAGI3 dependencies on DUAL

Line 132: from dual;

128:
129: /*
130: select MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
131: into tran_id
132: from dual;
133: */
134: dumm_status := INVPUOPI.mtl_log_interface_err(
135: cr.organization_id,
136: user_id,

Line 181: from dual;

177: for cr in ff loop
178:
179: select MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
180: into tran_id
181: from dual;
182:
183: update mtl_item_revisions_interface
184: set transaction_id = tran_id
185: where inventory_item_id = cr.inventory_item_id

Line 196: from dual;

192: /* Assigning Revision Ids to all CREATE records during default phase - R12C */
193: FOR cr IN c_null_rev_id LOOP
194: select MTL_ITEM_REVISIONS_B_S.nextval
195: into rev_id
196: from dual;
197:
198: update mtl_item_revisions_interface
199: set revision_id = rev_id
200: where rowid = cr.rowid;