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_SIGNATURE_PVT dependencies on DUAL

Line 2207: FROM dual

2203: -- SQL Why :To find out if the document was ever signed
2204:
2205: SELECT 'Y'
2206: INTO l_signatures
2207: FROM dual
2208: WHERE EXISTS (SELECT 1
2209: FROM PO_ACTION_HISTORY
2210: WHERE object_id = p_document_id
2211: AND object_type_code IN ('PO','PA')

Line 2558: FROM sys.dual;

2554: BEGIN
2555:
2556: SELECT to_char(PO_WF_ITEMKEY_S.NEXTVAL)
2557: INTO l_seq_for_item_key
2558: FROM sys.dual;
2559:
2560: l_itemkey := 'PO_DOC_BIND_'||p_po_header_id||'_'||p_revision_num||'_'
2561: ||p_document_type || '_' ||l_seq_for_item_key;
2562:

Line 2917: FROM dual

2913: -- SQL Join: PO_HEADER_ID, REVISION_NUM, SIGNATURE_FLAG, ERECORD_ID
2914:
2915: SELECT 'Y'
2916: INTO x_erecord_exist
2917: FROM dual
2918: WHERE EXISTS (SELECT 1
2919: FROM PO_ACCEPTANCES
2920: WHERE po_header_id = p_po_header_id
2921: AND revision_num = p_revision_num