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.OZF_SALES_TRANSACTIONS_PVT dependencies on DUAL

Line 247: from dual;

243: l_common_currency_code VARCHAR2(30);
244:
245: CURSOR transaction_id_csr is
246: select ozf_Sales_Transactions_all_s.nextval
247: from dual;
248: l_sales_transaction_id number;
249:
250: CURSOR sales_transation_csr(p_line_id NUMBER,p_source_code VARCHAR2) IS
251: SELECT 1 FROM DUAL WHERE EXISTS

Line 251: SELECT 1 FROM DUAL WHERE EXISTS

247: from dual;
248: l_sales_transaction_id number;
249:
250: CURSOR sales_transation_csr(p_line_id NUMBER,p_source_code VARCHAR2) IS
251: SELECT 1 FROM DUAL WHERE EXISTS
252: ( SELECT 1
253: FROM ozf_sales_transactions_all trx
254: WHERE trx.line_id = p_line_id
255: AND source_code = nvl(p_source_code,'OM')); --fix for bug 6808124