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.PAAPIMP_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 5346: ap_invoice_payments_all aip

5342: AND hist.posted_flag = 'Y')
5343: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
5344: FROM AP_INVOICES_ALL inv,
5345: AP_Invoice_Distributions_all aid,
5346: ap_invoice_payments_all aip
5347: WHERE inv.invoice_id = aip.invoice_id
5348: AND aid.invoice_id = inv.invoice_id
5349: AND aip.invoice_payment_id = dist.invoice_payment_id
5350: AND aid.invoice_distribution_id = dist.invoice_distribution_id

Line 5613: ap_invoice_payments_all aip

5609: AND hist.posted_flag = 'Y')
5610: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5611: FROM AP_INVOICES_ALL inv,
5612: AP_Invoice_Distributions_all aid,
5613: ap_invoice_payments_all aip
5614: WHERE inv.invoice_id = aip.invoice_id
5615: AND aid.invoice_id = inv.invoice_id
5616: AND aip.invoice_payment_id = dist.invoice_payment_id
5617: AND aid.invoice_distribution_id = dist.invoice_distribution_id

Line 5655: ap_invoice_payments_all aip

5651: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5652: FROM AP_INVOICES_ALL inv,
5653: PO_Distributions_all PO,
5654: AP_Invoice_Distributions_all aid,
5655: ap_invoice_payments_all aip
5656: WHERE inv.invoice_id = aip.invoice_id
5657: AND aid.invoice_id = inv.invoice_id
5658: AND aip.invoice_payment_id = dist.invoice_payment_id
5659: AND aid.invoice_distribution_id = dist.invoice_distribution_id

Line 5714: ap_invoice_payments_all aip

5710: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5711: FROM AP_INVOICES_ALL inv,
5712: PO_Distributions_all PO,
5713: AP_Invoice_Distributions_all aid,
5714: ap_invoice_payments_all aip
5715: WHERE inv.invoice_id = aip.invoice_id
5716: AND aid.invoice_id = inv.invoice_id
5717: AND aip.invoice_payment_id = dist.invoice_payment_id
5718: AND aid.invoice_distribution_id = dist.invoice_distribution_id

Line 5770: ap_invoice_payments_all aip

5766: AND hist.posted_flag = 'Y')
5767: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5768: FROM AP_INVOICES_ALL inv,
5769: AP_Invoice_Distributions_all aid,
5770: ap_invoice_payments_all aip
5771: WHERE inv.invoice_id = aip.invoice_id
5772: AND aid.invoice_id = inv.invoice_id
5773: AND aip.invoice_payment_id = dist.invoice_payment_id
5774: AND aid.invoice_distribution_id = dist.invoice_distribution_id

Line 5808: ap_invoice_payments_all aip

5804: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5805: FROM AP_INVOICES_ALL inv,
5806: PO_Distributions_all PO,
5807: AP_Invoice_Distributions_all aid,
5808: ap_invoice_payments_all aip
5809: WHERE inv.invoice_id = aip.invoice_id
5810: AND aid.invoice_id = inv.invoice_id
5811: AND aip.invoice_payment_id = dist.invoice_payment_id
5812: AND aid.invoice_distribution_id = dist.invoice_distribution_id

Line 5866: ap_invoice_payments_all aip

5862: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5863: FROM AP_INVOICES_ALL inv,
5864: PO_Distributions_all PO,
5865: AP_Invoice_Distributions_all aid,
5866: ap_invoice_payments_all aip
5867: WHERE inv.invoice_id = aip.invoice_id
5868: AND aid.invoice_id = inv.invoice_id
5869: AND aip.invoice_payment_id = dist.invoice_payment_id
5870: AND aid.invoice_distribution_id = dist.invoice_distribution_id

Line 10634: ap_invoice_payments_all aip

10630: AND exists (SELECT inv.invoice_id
10631: FROM AP_INVOICES inv,
10632: PO_VENDORS vend,
10633: AP_Invoice_Distributions_all aid,
10634: ap_invoice_payments_all aip
10635: WHERE inv.invoice_id = aid.invoice_id
10636: AND inv.vendor_id = vend.vendor_id
10637: AND aip.invoice_payment_id = dist.invoice_payment_id
10638: AND aid.invoice_distribution_id = dist.invoice_distribution_id

Line 10724: ap_invoice_payments_all aip

10720: AND exists (SELECT inv.invoice_id
10721: FROM AP_INVOICES_ALL inv,
10722: PO_VENDORS vend,
10723: AP_Invoice_Distributions_all aid,
10724: ap_invoice_payments_all aip
10725: WHERE inv.vendor_id = vend.vendor_id
10726: AND aid.invoice_id = inv.invoice_id
10727: AND inv.org_id = G_ORG_ID
10728: AND aip.invoice_payment_id = dist.invoice_payment_id

Line 10829: ap_invoice_payments_all aip

10825: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10826: FROM AP_INVOICES_ALL inv,
10827: PO_Distributions_all PO,
10828: AP_Invoice_Distributions_all aid,
10829: ap_invoice_payments_all aip
10830: WHERE inv.invoice_id = aip.invoice_id
10831: AND aid.invoice_id = inv.invoice_id
10832: AND inv.org_id = G_ORG_ID
10833: AND aip.invoice_payment_id = dist.invoice_payment_id

Line 10931: ap_invoice_payments_all aip

10927: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10928: FROM AP_INVOICES_ALL inv,
10929: PO_Distributions_all PO,
10930: AP_Invoice_Distributions_all aid,
10931: ap_invoice_payments_all aip
10932: WHERE inv.invoice_id = aip.invoice_id
10933: AND aid.invoice_id = inv.invoice_id
10934: AND inv.org_id = G_ORG_ID
10935: AND aip.invoice_payment_id = dist.invoice_payment_id