APPS.PAAPIMP_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 4191: ap_invoice_payments_all aip

4187: AND hist.posted_flag = 'Y')
4188: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
4189: FROM AP_INVOICES_ALL inv,
4190: AP_Invoice_Distributions_all aid,
4191: ap_invoice_payments_all aip
4192: WHERE inv.invoice_id = aip.invoice_id
4193: AND aid.invoice_id = inv.invoice_id
4194: AND aip.invoice_payment_id = dist.invoice_payment_id
4195: AND aid.invoice_distribution_id = dist.invoice_distribution_id

Line 4457: ap_invoice_payments_all aip

4453: AND hist.posted_flag = 'Y')
4454: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
4455: FROM AP_INVOICES_ALL inv,
4456: AP_Invoice_Distributions_all aid,
4457: ap_invoice_payments_all aip
4458: WHERE inv.invoice_id = aip.invoice_id
4459: AND aid.invoice_id = inv.invoice_id
4460: AND aip.invoice_payment_id = dist.invoice_payment_id
4461: AND aid.invoice_distribution_id = dist.invoice_distribution_id

Line 4496: ap_invoice_payments_all aip

4492: AND exists(SELECT/*+ no_unnest */ inv.invoice_id
4493: FROM AP_INVOICES_ALL inv,
4494: PO_Distributions_all PO,
4495: AP_Invoice_Distributions_all aid,
4496: ap_invoice_payments_all aip
4497: WHERE inv.invoice_id = aip.invoice_id
4498: AND aid.invoice_id = inv.invoice_id
4499: AND aip.invoice_payment_id = dist.invoice_payment_id
4500: AND aid.invoice_distribution_id = dist.invoice_distribution_id

Line 4553: ap_invoice_payments_all aip

4549: AND hist.posted_flag = 'Y')
4550: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
4551: FROM AP_INVOICES_ALL inv,
4552: AP_Invoice_Distributions_all aid,
4553: ap_invoice_payments_all aip
4554: WHERE inv.invoice_id = aip.invoice_id
4555: AND aid.invoice_id = inv.invoice_id
4556: AND aip.invoice_payment_id = dist.invoice_payment_id
4557: AND aid.invoice_distribution_id = dist.invoice_distribution_id

Line 4588: ap_invoice_payments_all aip

4584: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
4585: FROM AP_INVOICES_ALL inv,
4586: PO_Distributions_all PO,
4587: AP_Invoice_Distributions_all aid,
4588: ap_invoice_payments_all aip
4589: WHERE inv.invoice_id = aip.invoice_id
4590: AND aid.invoice_id = inv.invoice_id
4591: AND aip.invoice_payment_id = dist.invoice_payment_id
4592: AND aid.invoice_distribution_id = dist.invoice_distribution_id

Line 8916: ap_invoice_payments_all aip

8912: AND exists (SELECT inv.invoice_id
8913: FROM AP_INVOICES inv,
8914: PO_VENDORS vend,
8915: AP_Invoice_Distributions_all aid,
8916: ap_invoice_payments_all aip
8917: WHERE inv.invoice_id = aid.invoice_id
8918: AND inv.vendor_id = vend.vendor_id
8919: AND aip.invoice_payment_id = dist.invoice_payment_id
8920: AND aid.invoice_distribution_id = dist.invoice_distribution_id

Line 9006: ap_invoice_payments_all aip

9002: AND exists (SELECT inv.invoice_id
9003: FROM AP_INVOICES_ALL inv,
9004: PO_VENDORS vend,
9005: AP_Invoice_Distributions_all aid,
9006: ap_invoice_payments_all aip
9007: WHERE inv.vendor_id = vend.vendor_id
9008: AND aid.invoice_id = inv.invoice_id
9009: AND inv.org_id = G_ORG_ID
9010: AND aip.invoice_payment_id = dist.invoice_payment_id

Line 9111: ap_invoice_payments_all aip

9107: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
9108: FROM AP_INVOICES_ALL inv,
9109: PO_Distributions_all PO,
9110: AP_Invoice_Distributions_all aid,
9111: ap_invoice_payments_all aip
9112: WHERE inv.invoice_id = aip.invoice_id
9113: AND aid.invoice_id = inv.invoice_id
9114: AND inv.org_id = G_ORG_ID
9115: AND aip.invoice_payment_id = dist.invoice_payment_id

Line 9213: ap_invoice_payments_all aip

9209: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
9210: FROM AP_INVOICES_ALL inv,
9211: PO_Distributions_all PO,
9212: AP_Invoice_Distributions_all aid,
9213: ap_invoice_payments_all aip
9214: WHERE inv.invoice_id = aip.invoice_id
9215: AND aid.invoice_id = inv.invoice_id
9216: AND inv.org_id = G_ORG_ID
9217: AND aip.invoice_payment_id = dist.invoice_payment_id