DBA Data[Home] [Help]

APPS.WSMPLBJI dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 3248: select mtl_material_transactions_s.nextval

3244: -- ==============================================================================================
3245: -- getting the header_id to be populated for mmtt
3246: -- ==============================================================================================
3247:
3248: select mtl_material_transactions_s.nextval
3249: into txn_header_id
3250: from dual;
3251:
3252: -- ==============================================================================================

Line 7306: select mtl_material_transactions_s.nextval

7302: end if;
7303:
7304: l_stmt_num := 1120;
7305: /* commented out by BBK for DUAL usage reduction.
7306: select mtl_material_transactions_s.nextval
7307: into txn_tmp_header_id
7308: from dual;
7309: */
7310:

Line 7378: mtl_material_transactions_s.nextval /* Transaction Temp Id */

7374: 'N', /* WIP_COMMIT_FLAG */
7375: 'Y', /* PROCESS_FLAG */
7376: 'Y', /* POSTING_FLAG */
7377: -- txn_tmp_header_id /* Transaction Temp Id */
7378: mtl_material_transactions_s.nextval /* Transaction Temp Id */
7379: ) RETURNING transaction_temp_id into txn_tmp_header_id;
7380:
7381: if lbji_debug = 'Y' then
7382: fnd_file.put_line(fnd_file.log, 'Inserted '||SQL%ROWCOUNT||' rows into mmtt');