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.AP_FUNDS_CONTROL_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 637: po_distributions_all pod

633: FROM gl_period_statuses PER,
634: ap_invoices I,
635: ap_invoice_distributions_all D,
636: ap_invoice_lines L,
637: po_distributions_all pod
638: WHERE D.invoice_id = I.invoice_id
639: AND D.invoice_line_number = L.line_number
640: AND L.invoice_id = D.invoice_id
641: AND ( (D.line_type_lookup_code = 'ITEM' AND

Line 669: from po_distributions_all pod,

665: AND H.hold_lookup_code <> 'INSUFFICIENT FUNDS')))
666: AND D.po_distribution_id IS NOT NULL
667: AND D.po_distribution_id = pod.po_distribution_id
668: AND NOT EXISTS ( select 'Advance Exists'
669: from po_distributions_all pod,
670: po_headers_all poh,
671: ap_invoice_distributions_all ainvd,
672: ap_invoices_all ainv,
673: po_doc_style_headers pdsa

Line 765: from po_distributions_all pod,

761: AND H.hold_lookup_code <> 'CANT FUNDS CHECK'
762: AND H.hold_lookup_code <> 'INSUFFICIENT FUNDS')))
763: AND T.po_distribution_id is NOT NULL
764: AND NOT EXISTS ( select 'Advance Exists'
765: from po_distributions_all pod,
766: po_headers_all poh,
767: ap_invoice_distributions_all ainvd,
768: ap_invoices_all ainv,
769: po_doc_style_headers pdsa

Line 2311: po_distributions_all pod

2307: FROM ap_invoice_distributions_all aid,
2308: ap_invoices_all ai,
2309: ap_invoice_lines_all ail,
2310: gl_period_statuses per,
2311: po_distributions_all pod
2312: WHERE ai.invoice_id = p_invoice_id
2313: AND aid.invoice_id = ai.invoice_id
2314: AND ail.invoice_id = aid.invoice_id
2315: AND ail.line_number = aid.invoice_line_number

Line 2337: from po_distributions_all pod,

2333: AND nvl(per.adjustment_period_flag, 'N') = 'N'
2334: AND aid.po_distribution_id is not NULL
2335: AND aid.po_distribution_id = pod.po_distribution_id
2336: AND NOT EXISTS ( select 'Advance Exists'
2337: from po_distributions_all pod,
2338: po_headers_all poh,
2339: ap_invoice_distributions_all ainvd,
2340: ap_invoices_all ainv,
2341: po_doc_style_headers pdsa

Line 2421: from po_distributions_all pod,

2417: AND per.application_id = 200
2418: AND nvl(per.adjustment_period_flag, 'N') = 'N'
2419: AND t.po_distribution_id is NOT NULL
2420: AND NOT EXISTS ( select 'Advance Exists'
2421: from po_distributions_all pod,
2422: po_headers_all poh,
2423: ap_invoice_distributions_all ainvd,
2424: ap_invoices_all ainv,
2425: po_doc_style_headers pdsa