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

Line 1500: FROM dual

1496: -- for the shipments of this line, 0 otherwise.
1497: -- SQL Why: To prevent price changes if there are pending transactions.
1498: SELECT count(*)
1499: INTO l_pending_rcv_transactions
1500: FROM dual
1501: WHERE EXISTS
1502: ( SELECT 1
1503: FROM rcv_transactions_interface RTI, po_line_locations_all PLL
1504: WHERE PLL.po_line_id = p_po_line_id

Line 1720: FROM dual

1716: -- for the shipments of this line, 0 otherwise.
1717: -- SQL Why: To prevent price changes if there are pending transactions.
1718: SELECT count(*)
1719: INTO l_pending_rcv_transactions
1720: FROM dual
1721: WHERE EXISTS
1722: ( SELECT 1
1723: FROM rcv_transactions_interface RTI
1724: WHERE RTI.po_line_location_id = p_line_location_id

Line 1851: FROM sys.dual;

1847: -- SQL What: Get the id from the given nline report sequence
1848: -- SQL Why: Used for the new combined online report below.
1849: SELECT po_online_report_text_s.nextval
1850: INTO x_new_report_id
1851: FROM sys.dual;
1852:
1853: IF (PO_LOG.d_stmt) THEN
1854: PO_LOG.stmt(d_module,d_progress,'After got the new id for combined online report');
1855: END IF;