DBA Data[Home] [Help]

APPS.AP_FUNDS_CONTROL_PKG dependencies on PO_HEADERS_ALL

Line 670: po_headers_all poh,

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

Line 766: po_headers_all poh,

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

Line 2338: po_headers_all poh,

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

Line 2422: po_headers_all poh,

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