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 414: OR EXISTS (SELECT 1 FROM ap_holds aph

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

Line 1843: OR EXISTS (SELECT 1 FROM ap_holds aph

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

Line 1872: OR EXISTS (SELECT 1 FROM ap_holds aph

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

Line 1990: OR EXISTS (SELECT 1 FROM ap_holds aph

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

Line 2017: OR EXISTS (SELECT 1 FROM ap_holds aph

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

Line 3664: OR EXISTS (SELECT 1 FROM ap_holds aph

3660: WHERE poh.PO_HEADER_ID = x_po_header_id AND rcv.po_header_ID = x_po_header_ID
3661: AND rcv.requestor_ID = x_requester_ID
3662: AND ((rcv.expected_receipt_date is not null
3663: AND trunc(rcv.expected_receipt_date + 1) <= trunc(SYSDATE))
3664: OR EXISTS (SELECT 1 FROM ap_holds aph
3665: WHERE aph.line_location_id = rcv.po_line_location_id
3666: AND aph.hold_lookup_code in ('QTY REC', 'AMT REC')
3667: AND aph.release_lookup_code IS NULL
3668: AND rcv.quantity_invoiced > quantity_delivered

Line 3690: OR EXISTS (SELECT 1 FROM ap_holds aph

3686: WHERE poh.PO_HEADER_ID = x_po_header_id AND rcv.po_header_ID = x_po_header_ID
3687: AND rcv.requestor_ID = x_requester_ID
3688: AND ((rcv.expected_receipt_date is not null
3689: AND trunc(rcv.expected_receipt_date + 1) <= trunc(SYSDATE))
3690: OR EXISTS (SELECT 1 FROM ap_holds aph
3691: WHERE aph.line_location_id = rcv.po_line_location_id
3692: AND aph.hold_lookup_code in ('QTY REC', 'AMT REC')
3693: AND aph.release_lookup_code IS NULL
3694: AND rcv.quantity_invoiced > quantity_delivered