DBA Data[Home] [Help]

APPS.WSMPLBJI dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 3242: select mtl_material_transactions_s.nextval

3238: -- ==============================================================================================
3239: -- getting the header_id to be populated for mmtt
3240: -- ==============================================================================================
3241:
3242: select mtl_material_transactions_s.nextval
3243: into txn_header_id
3244: from dual;
3245:
3246: -- ==============================================================================================

Line 7300: select mtl_material_transactions_s.nextval

7296: end if;
7297:
7298: l_stmt_num := 1120;
7299: /* commented out by BBK for DUAL usage reduction.
7300: select mtl_material_transactions_s.nextval
7301: into txn_tmp_header_id
7302: from dual;
7303: */
7304:

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

7368: 'N', /* WIP_COMMIT_FLAG */
7369: 'Y', /* PROCESS_FLAG */
7370: 'Y', /* POSTING_FLAG */
7371: -- txn_tmp_header_id /* Transaction Temp Id */
7372: mtl_material_transactions_s.nextval /* Transaction Temp Id */
7373: ) RETURNING transaction_temp_id into txn_tmp_header_id;
7374:
7375: if lbji_debug = 'Y' then
7376: fnd_file.put_line(fnd_file.log, 'Inserted '||SQL%ROWCOUNT||' rows into mmtt');