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_APPROVAL_LIST_HEADERS

Line 3395: -- PO_APPROVAL_LIST_HEADERS where reqs are purged

3391: -- FND Attachments related tables
3392: --Locks:
3393: -- None
3394: --Function: Delete records in PO_APPROVAL_LIST_LINES and
3395: -- PO_APPROVAL_LIST_HEADERS where reqs are purged
3396: --Parameters:
3397: --IN:
3398: --p_purge_entity
3399: -- Currently only 'REQ' is supported

Line 3450: FROM po_approval_list_headers PALH,

3446: DELETE
3447: FROM po_approval_list_lines PALL
3448: WHERE PALL.approval_list_header_id
3449: IN ( SELECT PALH.approval_list_header_id
3450: FROM po_approval_list_headers PALH,
3451: po_purge_req_list PPRL
3452: WHERE PPRL.requisition_header_id =
3453: PALH.document_id
3454: AND PPRL.double_check_flag = 'Y'

Line 3473: --SQL What: Delete PO_APPROVAL_LIST_HEADERS for the REQS being purged

3469:
3470: l_progress := '020';
3471:
3472:
3473: --SQL What: Delete PO_APPROVAL_LIST_HEADERS for the REQS being purged
3474: --SQL Why: These records should get purged together with the reqs
3475: DELETE
3476: FROM po_approval_list_headers PALH
3477: WHERE PALH.document_type = 'REQUISITION'

Line 3476: FROM po_approval_list_headers PALH

3472:
3473: --SQL What: Delete PO_APPROVAL_LIST_HEADERS for the REQS being purged
3474: --SQL Why: These records should get purged together with the reqs
3475: DELETE
3476: FROM po_approval_list_headers PALH
3477: WHERE PALH.document_type = 'REQUISITION'
3478: AND PALH.document_id
3479: IN ( SELECT PPRL.requisition_header_id
3480: FROM po_purge_req_list PPRL