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 229: from dual;

225: l_common_currency_code VARCHAR2(30);
226:
227: CURSOR transaction_id_csr is
228: select ozf_Sales_Transactions_all_s.nextval
229: from dual;
230: l_sales_transaction_id number;
231:
232: CURSOR sales_transation_csr(p_line_id NUMBER,p_source_code VARCHAR2) IS
233: SELECT 1 FROM DUAL WHERE EXISTS

Line 233: SELECT 1 FROM DUAL WHERE EXISTS

229: from dual;
230: l_sales_transaction_id number;
231:
232: CURSOR sales_transation_csr(p_line_id NUMBER,p_source_code VARCHAR2) IS
233: SELECT 1 FROM DUAL WHERE EXISTS
234: ( SELECT 1
235: FROM ozf_sales_transactions_all trx
236: WHERE trx.line_id = p_line_id
237: AND source_code = nvl(p_source_code,'OM')); --fix for bug 6808124