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 788: po_distributions_all pod

784: FROM gl_period_statuses PER,
785: ap_invoices I,
786: ap_invoice_distributions_all D,
787: ap_invoice_lines L,
788: po_distributions_all pod
789: WHERE D.invoice_id = I.invoice_id
790: AND D.invoice_line_number = L.line_number
791: AND L.invoice_id = D.invoice_id
792: AND ( (D.line_type_lookup_code = 'ITEM' AND

Line 821: from po_distributions_all pod,

817: AND H.hold_lookup_code <> 'Encumbrance Acctg Fail'))) --Bug 9136390
818: AND D.po_distribution_id IS NOT NULL
819: AND D.po_distribution_id = pod.po_distribution_id
820: AND NOT EXISTS ( select 'Advance Exists'
821: from po_distributions_all pod,
822: po_headers_all poh,
823: ap_invoice_distributions_all ainvd,
824: ap_invoices_all ainv,
825: po_doc_style_headers pdsa

Line 919: from po_distributions_all pod,

915: AND H.hold_lookup_code <> 'INSUFFICIENT FUNDS'
916: AND H.hold_lookup_code <> 'Encumbrance Acctg Fail'))) --Bug 9136390
917: AND T.po_distribution_id is NOT NULL
918: AND NOT EXISTS ( select 'Advance Exists'
919: from po_distributions_all pod,
920: po_headers_all poh,
921: ap_invoice_distributions_all ainvd,
922: ap_invoices_all ainv,
923: po_doc_style_headers pdsa

Line 2716: po_distributions_all pod

2712: FROM ap_invoice_distributions_all aid,
2713: ap_invoices_all ai,
2714: ap_invoice_lines_all ail,
2715: gl_period_statuses per,
2716: po_distributions_all pod
2717: WHERE ai.invoice_id = p_invoice_id
2718: AND aid.invoice_id = ai.invoice_id
2719: AND ail.invoice_id = aid.invoice_id
2720: AND ail.line_number = aid.invoice_line_number

Line 2742: from po_distributions_all pod,

2738: AND nvl(per.adjustment_period_flag, 'N') = 'N'
2739: AND aid.po_distribution_id is not NULL
2740: AND aid.po_distribution_id = pod.po_distribution_id
2741: AND NOT EXISTS ( select 'Advance Exists'
2742: from po_distributions_all pod,
2743: po_headers_all poh,
2744: ap_invoice_distributions_all ainvd,
2745: ap_invoices_all ainv,
2746: po_doc_style_headers pdsa

Line 2826: from po_distributions_all pod,

2822: AND per.application_id = 200
2823: AND nvl(per.adjustment_period_flag, 'N') = 'N'
2824: AND t.po_distribution_id is NOT NULL
2825: AND NOT EXISTS ( select 'Advance Exists'
2826: from po_distributions_all pod,
2827: po_headers_all poh,
2828: ap_invoice_distributions_all ainvd,
2829: ap_invoices_all ainv,
2830: po_doc_style_headers pdsa