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.PORCPTWF dependencies on AP_HOLDS

Line 195: OR EXISTS (SELECT 1 FROM ap_holds aph

191: FROM POR_RCV_ALL_ITEMS_V1 rcv
192: WHERE ((expected_receipt_date is not NULL
193: AND trunc(rcv.expected_receipt_date + 1) <=
194: trunc(SYSDATE))
195: OR EXISTS (SELECT 1 FROM ap_holds aph
196: WHERE aph.line_location_id = rcv.po_line_location_id
197: AND aph.hold_lookup_code in ('QTY REC', 'AMT REC')
198: AND aph.release_lookup_code IS NULL
199: AND rcv.quantity_invoiced > quantity_delivered

Line 226: OR EXISTS (SELECT 1 FROM ap_holds aph

222: FROM POR_RCV_ALL_ITEMS_V1 rcv
223: WHERE ((expected_receipt_date is not NULL
224: AND trunc(rcv.expected_receipt_date + 1) <=
225: trunc(SYSDATE))
226: OR EXISTS (SELECT 1 FROM ap_holds aph
227: WHERE aph.line_location_id = rcv.po_line_location_id
228: AND aph.hold_lookup_code in ('QTY REC', 'AMT REC')
229: AND aph.release_lookup_code IS NULL
230: AND rcv.quantity_invoiced > quantity_delivered

Line 378: -- is matched for the line. Joined with AP_HOLDS

374:
375: if x_allow_inv_dest_receipts = 'N' then
376: --
377: -- Modified the query to retrive the lines if an invoice
378: -- is matched for the line. Joined with AP_HOLDS
379: OPEN Porcpt_c for
380: SELECT rcv.po_header_ID, rcv.requestor_ID,
381: rcv.expected_receipt_date, rcv.revision_num,
382: rcv.po_distribution_id, po_num_rel_num

Line 388: OR EXISTS (SELECT 1 FROM ap_holds aph

384: WHERE ( (rcv.expected_receipt_date is not NULL
385: AND trunc(rcv.expected_receipt_date + 1) <=
386: trunc(SYSDATE)
387: )
388: OR EXISTS (SELECT 1 FROM ap_holds aph
389: WHERE aph.line_location_id = rcv.po_line_location_id
390: AND aph.hold_lookup_code in ('QTY REC', 'AMT REC')
391: AND aph.release_lookup_code IS NULL
392: AND rcv.quantity_invoiced > quantity_delivered

Line 413: OR EXISTS (SELECT 1 FROM ap_holds aph

409: WHERE ( (rcv.expected_receipt_date is not NULL
410: AND trunc(rcv.expected_receipt_date + 1) <=
411: trunc(SYSDATE)
412: )
413: OR EXISTS (SELECT 1 FROM ap_holds aph
414: WHERE aph.line_location_id = rcv.po_line_location_id
415: AND aph.hold_lookup_code in ('QTY REC', 'AMT REC')
416: AND aph.release_lookup_code IS NULL
417: AND rcv.quantity_invoiced > quantity_delivered

Line 1840: OR EXISTS (SELECT 1 FROM ap_holds aph

1836: FROM POR_RCV_ALL_ITEMS_V1 rcv
1837: WHERE ((expected_receipt_date is not NULL
1838: AND trunc(to_date(to_char(expected_receipt_date+1), 'DD/MM/YYYY'))<=
1839: trunc(to_date(x_ntf_trigerred_date, 'DD/MM/YYYY')))
1840: OR EXISTS (SELECT 1 FROM ap_holds aph
1841: WHERE aph.line_location_id = rcv.po_line_location_id
1842: AND aph.hold_lookup_code in ('QTY REC', 'AMT REC')
1843: AND aph.release_lookup_code IS NULL
1844: AND rcv.quantity_invoiced > quantity_delivered

Line 1869: OR EXISTS (SELECT 1 FROM ap_holds aph

1865: FROM POR_RCV_ALL_ITEMS_V1 rcv
1866: WHERE ((expected_receipt_date is not NULL
1867: AND trunc(to_date(to_char(expected_receipt_date+1), 'DD/MM/YYYY'))<=
1868: trunc(to_date(x_ntf_trigerred_date, 'DD/MM/YYYY')))
1869: OR EXISTS (SELECT 1 FROM ap_holds aph
1870: WHERE aph.line_location_id = rcv.po_line_location_id
1871: AND aph.hold_lookup_code in ('QTY REC', 'AMT REC')
1872: AND aph.release_lookup_code IS NULL
1873: AND rcv.quantity_invoiced > quantity_delivered

Line 1987: OR EXISTS (SELECT 1 FROM ap_holds aph

1983: FROM POR_RCV_ALL_ITEMS_V1 rcv
1984: WHERE ((expected_receipt_date is not NULL
1985: AND trunc(to_date(to_char(expected_receipt_date+1), 'DD/MM/YYYY'))<=
1986: trunc(to_date(x_ntf_trigerred_date, 'DD/MM/YYYY')))
1987: OR EXISTS (SELECT 1 FROM ap_holds aph
1988: WHERE aph.line_location_id = rcv.po_line_location_id
1989: AND aph.hold_lookup_code in ('QTY REC', 'AMT REC')
1990: AND aph.release_lookup_code IS NULL
1991: AND rcv.quantity_invoiced > quantity_delivered

Line 2014: OR EXISTS (SELECT 1 FROM ap_holds aph

2010: FROM POR_RCV_ALL_ITEMS_V1 rcv
2011: WHERE ((expected_receipt_date is not NULL
2012: AND trunc(to_date(to_char(expected_receipt_date+1), 'DD/MM/YYYY'))<=
2013: trunc(to_date(x_ntf_trigerred_date, 'DD/MM/YYYY')))
2014: OR EXISTS (SELECT 1 FROM ap_holds aph
2015: WHERE aph.line_location_id = rcv.po_line_location_id
2016: AND aph.hold_lookup_code in ('QTY REC', 'AMT REC')
2017: AND aph.release_lookup_code IS NULL
2018: AND rcv.quantity_invoiced > quantity_delivered

Line 3614: OR EXISTS (SELECT 1 FROM ap_holds aph

3610: WHERE rcv.po_header_ID = x_po_header_ID
3611: AND rcv.requestor_ID = x_requester_ID
3612: AND ((rcv.expected_receipt_date is not null
3613: AND trunc(rcv.expected_receipt_date + 1) <= trunc(SYSDATE))
3614: OR EXISTS (SELECT 1 FROM ap_holds aph
3615: WHERE aph.line_location_id = rcv.po_line_location_id
3616: AND aph.hold_lookup_code in ('QTY REC', 'AMT REC')
3617: AND aph.release_lookup_code IS NULL
3618: AND rcv.quantity_invoiced > quantity_delivered

Line 3639: OR EXISTS (SELECT 1 FROM ap_holds aph

3635: WHERE rcv.po_header_ID = x_po_header_ID
3636: AND rcv.requestor_ID = x_requester_ID
3637: AND ((rcv.expected_receipt_date is not null
3638: AND trunc(rcv.expected_receipt_date + 1) <= trunc(SYSDATE))
3639: OR EXISTS (SELECT 1 FROM ap_holds aph
3640: WHERE aph.line_location_id = rcv.po_line_location_id
3641: AND aph.hold_lookup_code in ('QTY REC', 'AMT REC')
3642: AND aph.release_lookup_code IS NULL
3643: AND rcv.quantity_invoiced > quantity_delivered