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_CLOSEOUT_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 687: po_distributions_all pod,

683: SELECT Count(1)
684: INTO l_count
685: FROM ap_invoice_distributions_all aid,
686: ap_invoices_all aia,
687: po_distributions_all pod,
688: po_line_locations_all poll
689: WHERE aid.po_distribution_id = pod.po_distribution_id
690: AND aia.invoice_id = aid.invoice_id
691: AND pod.po_header_id = poll.po_header_id

Line 702: po_distributions_all pod,

698: SELECT Count(1)
699: INTO l_count
700: FROM ap_invoice_distributions_all aid,
701: ap_invoices_all aia,
702: po_distributions_all pod,
703: po_line_locations_all poll
704: WHERE aid.po_distribution_id = pod.po_distribution_id
705: AND aia.invoice_id = aid.invoice_id
706: AND pod.po_header_id = poll.po_header_id

Line 2056: po_distributions_all pod,

2052: AND pha.type_lookup_code = 'STANDARD'
2053: AND NOT EXISTS (SELECT 1
2054: FROM ap_invoice_distributions_all aid,
2055: ap_invoices_all aia,
2056: po_distributions_all pod,
2057: po_line_locations_all poll
2058: WHERE aid.po_distribution_id = pod.po_distribution_id
2059: AND aia.invoice_id = aid.invoice_id
2060: AND pod.po_header_id = poll.po_header_id

Line 2094: po_distributions_all pod,

2090: AND pha.type_lookup_code = 'STANDARD'
2091: AND EXISTS (SELECT 1
2092: FROM ap_invoice_distributions_all aid,
2093: ap_invoices_all aia,
2094: po_distributions_all pod,
2095: po_line_locations_all poll
2096: WHERE aid.po_distribution_id = pod.po_distribution_id
2097: AND aia.invoice_id = aid.invoice_id
2098: AND pod.po_header_id = poll.po_header_id