DBA Data[Home] [Help]

APPS.PO_FED_FIELD_FUNCTIONS dependencies on PO_DISTRIBUTIONS_ALL

Line 3729: po_distributions_all pod,

3725: SELECT Count(1)
3726: INTO l_count
3727: FROM ap_invoice_distributions_all aid,
3728: ap_invoices_all aia,
3729: po_distributions_all pod,
3730: po_line_locations_all poll,
3731: po_headers_all poh
3732: WHERE poh.po_header_id = l_po_header_id
3733: and nvl(poh.authorization_status, 'INCOMPLETE') = 'APPROVED'

Line 3750: from ap_invoice_distributions_all invdist , po_distributions_all podist

3746: (select pay.check_number, pay.check_date
3747: from ap_checks_all pay, ap_invoice_payments_all invpay
3748: where pay.check_id = invpay.check_id
3749: and exists ( select 1
3750: from ap_invoice_distributions_all invdist , po_distributions_all podist
3751: where podist.po_distribution_id = invdist.po_distribution_id
3752: and invdist.invoice_id = invpay.invoice_id
3753: and podist.po_header_id = l_po_header_id
3754: )