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_AP_PURGE_UTIL_PVT dependencies on PO_ASL_DOCUMENTS

Line 1863: --Modifies: PO_ASL_DOCUMENTS

1859: -----------------------------------------------------------------------
1860: --Start of Comments
1861: --Name: delete_asl_ref
1862: --Pre-reqs:
1863: --Modifies: PO_ASL_DOCUMENTS
1864: --Locks:
1865: -- None
1866: --Function: Delete referenced documents on ASL when the document is purged
1867: --Parameters:

Line 1918: FROM po_asl_documents PAD

1914: -- List
1915: --SQL Why: When document is purged,the ASL reference becomes useless.
1916: -- Hence it can be deleted
1917: DELETE
1918: FROM po_asl_documents PAD
1919: WHERE PAD.document_header_id IN
1920: ( SELECT PPL.po_header_id
1921: FROM po_purge_po_list PPL
1922: WHERE PPL.double_check_flag = 'Y'