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 STANDARD

Line 206: WHERE PH.type_lookup_code IN ('STANDARD', 'PLANNED',

202: SELECT PH.po_header_id,
203: p_purge_name,
204: 'Y'
205: FROM po_headers PH
206: WHERE PH.type_lookup_code IN ('STANDARD', 'PLANNED',
207: 'BLANKET', 'CONTRACT')
208: AND PH.last_update_date <= p_last_activity_date
209: AND (PH.closed_code = 'FINALLY CLOSED'
210: OR PH.cancel_flag = 'Y')

Line 293: WHERE PH.type_lookup_code IN ('STANDARD', 'PLANNED',

289: SELECT PH.po_header_id,
290: p_purge_name,
291: 'Y'
292: FROM po_headers PH
293: WHERE PH.type_lookup_code IN ('STANDARD', 'PLANNED',
294: 'BLANKET', 'CONTRACT')
295: AND PH.last_update_date <= p_last_activity_date
296: AND (PH.closed_code = 'FINALLY CLOSED'
297: OR PH.cancel_flag = 'Y')

Line 2496: SELECT DECODE (PH.type_lookup_code, 'STANDARD', 'PO_STANDARD',

2492: -- SQL What: Construct l_header_tbl with doc type and id information
2493: -- for records in the purge list
2494: -- SQL Why: Prepare input parameter for okc purge api.
2495: CURSOR c_po_list IS
2496: SELECT DECODE (PH.type_lookup_code, 'STANDARD', 'PO_STANDARD',
2497: 'BLANKET' , 'PA_BLANKET',
2498: 'CONTRACT', 'PA_CONTRACT') DOC_TYPE,
2499: PH.po_header_id DOC_ID
2500: FROM po_headers PH,

Line 2505: AND PH.type_lookup_code IN ('STANDARD', 'BLANKET', 'CONTRACT')

2501: po_purge_po_list PPL
2502: WHERE PH.po_header_id = PPL.po_header_id
2503: AND PPL.double_check_flag = 'Y'
2504: AND PPL.po_header_id BETWEEN p_range_low AND p_range_high
2505: AND PH.type_lookup_code IN ('STANDARD', 'BLANKET', 'CONTRACT')
2506: AND PH.conterms_exist_flag = 'Y';
2507:
2508: l_po_list_rec c_po_list%ROWTYPE;
2509: l_rec_count NUMBER := 0;