eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_DISCRETE_WS_MOVE dependencies on DUAL

Line 26: select wip_transactions_s.nextval into x_moveTxnID from dual;

22: x_errMessage out nocopy varchar2) is
23: openPastPeriod boolean;
24: periodID number;
25: begin
26: select wip_transactions_s.nextval into x_moveTxnID from dual;
27: select mtl_material_transactions_s.nextval into x_cplTxnID from dual;
28: select mtl_material_transactions_s.nextval into x_batchID from dual;
29: select mtl_material_transactions_s.nextval into x_txnHeaderID from dual;
30:

Line 27: select mtl_material_transactions_s.nextval into x_cplTxnID from dual;

23: openPastPeriod boolean;
24: periodID number;
25: begin
26: select wip_transactions_s.nextval into x_moveTxnID from dual;
27: select mtl_material_transactions_s.nextval into x_cplTxnID from dual;
28: select mtl_material_transactions_s.nextval into x_batchID from dual;
29: select mtl_material_transactions_s.nextval into x_txnHeaderID from dual;
30:
31: openPastPeriod := false;

Line 28: select mtl_material_transactions_s.nextval into x_batchID from dual;

24: periodID number;
25: begin
26: select wip_transactions_s.nextval into x_moveTxnID from dual;
27: select mtl_material_transactions_s.nextval into x_cplTxnID from dual;
28: select mtl_material_transactions_s.nextval into x_batchID from dual;
29: select mtl_material_transactions_s.nextval into x_txnHeaderID from dual;
30:
31: openPastPeriod := false;
32: x_mtlMode := nvl(to_number(fnd_profile.value('TRANSACTION_PROCESS_MODE')),

Line 29: select mtl_material_transactions_s.nextval into x_txnHeaderID from dual;

25: begin
26: select wip_transactions_s.nextval into x_moveTxnID from dual;
27: select mtl_material_transactions_s.nextval into x_cplTxnID from dual;
28: select mtl_material_transactions_s.nextval into x_batchID from dual;
29: select mtl_material_transactions_s.nextval into x_txnHeaderID from dual;
30:
31: openPastPeriod := false;
32: x_mtlMode := nvl(to_number(fnd_profile.value('TRANSACTION_PROCESS_MODE')),
33: WIP_CONSTANTS.ONLINE);

Line 40: select mtl_material_transactions_s.nextval into x_compHeaderID from dual;

36: WIP_CONSTANTS.ONLINE);
37: end if;
38:
39: if ( x_mtlMode <> WIP_CONSTANTS.ONLINE ) then
40: select mtl_material_transactions_s.nextval into x_compHeaderID from dual;
41: else
42: x_compHeaderID := x_txnHeaderID;
43: end if;
44: