DBA Data[Home] [Help]

APPS.AP_FUNDS_CONTROL_PKG dependencies on PO_HEADERS_ALL

Line 822: po_headers_all poh,

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
826: where pod.po_distribution_id = D.po_distribution_id

Line 920: po_headers_all poh,

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
924: where pod.po_distribution_id = T.po_distribution_id

Line 2743: po_headers_all poh,

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
2747: where pod.po_distribution_id = aid.po_distribution_id

Line 2827: po_headers_all poh,

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
2831: where pod.po_distribution_id = t.po_distribution_id