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 2584: FROM dual

2580: -- SQL Why :To find out if the document was ever signed
2581:
2582: /*SELECT 'Y'
2583: INTO l_signatures
2584: FROM dual
2585: WHERE EXISTS (SELECT 1
2586: FROM PO_ACTION_HISTORY
2587: WHERE object_id = p_document_id
2588: AND object_type_code IN ('PO','PA')

Line 2594: FROM dual

2590: -- PO AME Project : Verify signauture exists on the basis of record in po_acceptances table for SUPPLIER siganture
2591: -- to avoid confusion between e-signature and supplier signature when using AME.
2592: SELECT 'Y'
2593: INTO l_signatures
2594: FROM dual
2595: WHERE EXISTS (SELECT 1
2596: FROM PO_ACCEPTANCES
2597: WHERE po_header_id = p_document_id
2598: AND accepting_party ='S'

Line 3301: FROM sys.dual;

3297: BEGIN
3298:
3299: SELECT to_char(PO_WF_ITEMKEY_S.NEXTVAL)
3300: INTO l_seq_for_item_key
3301: FROM sys.dual;
3302:
3303: l_itemkey := 'PO_DOC_BIND_'||p_po_header_id||'_'||p_revision_num||'_'
3304: ||p_document_type || '_' ||l_seq_for_item_key;
3305:

Line 3660: FROM dual

3656: -- SQL Join: PO_HEADER_ID, REVISION_NUM, SIGNATURE_FLAG, ERECORD_ID
3657:
3658: SELECT 'Y'
3659: INTO x_erecord_exist
3660: FROM dual
3661: WHERE EXISTS (SELECT 1
3662: FROM PO_ACCEPTANCES
3663: WHERE po_header_id = p_po_header_id
3664: AND revision_num = p_revision_num