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_PAYMENT_HISTORY_ALL

Line 905: FROM ap_payment_history_all hist

901: , DIST.request_id = G_REQUEST_ID
902: WHERE DIST.pa_addition_flag = 'O'
903: AND dist.pay_dist_lookup_code = 'DISCOUNT'
904: AND EXISTS (SELECT NULL
905: FROM ap_payment_history_all hist
906: WHERE hist.payment_history_id = dist.payment_history_id
907: AND hist.posted_flag = 'Y')
908: AND NOT EXISTS ( SELECT 'X'
909: FROM pa_expenditure_items_all ei

Line 950: FROM ap_payment_history_all hist

946: , DIST.request_id = G_REQUEST_ID
947: WHERE DIST.pa_addition_flag = 'O'
948: AND dist.pay_dist_lookup_code = 'CASH'
949: AND EXISTS (SELECT NULL
950: FROM ap_payment_history_all hist
951: WHERE hist.payment_history_id = dist.payment_history_id
952: AND hist.posted_flag = 'Y')
953: AND NOT EXISTS ( SELECT 'X'
954: FROM pa_expenditure_items_all ei

Line 4185: FROM ap_payment_history_all hist

4181: program_update_date=SYSDATE
4182: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
4183: AND dist.pay_dist_lookup_code = 'CASH'
4184: AND EXISTS (SELECT NULL
4185: FROM ap_payment_history_all hist
4186: WHERE hist.payment_history_id = dist.payment_history_id
4187: AND hist.posted_flag = 'Y')
4188: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
4189: FROM AP_INVOICES_ALL inv,

Line 4451: FROM ap_payment_history_all hist

4447: program_update_date=SYSDATE
4448: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
4449: AND dist.pay_dist_lookup_code = 'DISCOUNT'
4450: AND EXISTS (SELECT NULL
4451: FROM ap_payment_history_all hist
4452: WHERE hist.payment_history_id = dist.payment_history_id
4453: AND hist.posted_flag = 'Y')
4454: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
4455: FROM AP_INVOICES_ALL inv,

Line 4489: FROM ap_payment_history_all hist

4485: program_update_date=SYSDATE
4486: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
4487: AND dist.pay_dist_lookup_code = 'DISCOUNT'
4488: AND EXISTS (SELECT NULL
4489: FROM ap_payment_history_all hist
4490: WHERE hist.payment_history_id = dist.payment_history_id
4491: AND hist.posted_flag = 'Y')
4492: AND exists(SELECT/*+ no_unnest */ inv.invoice_id
4493: FROM AP_INVOICES_ALL inv,

Line 4547: FROM ap_payment_history_all hist

4543: program_update_date=SYSDATE
4544: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
4545: AND dist.pay_dist_lookup_code = 'DISCOUNT'
4546: AND EXISTS (SELECT NULL
4547: FROM ap_payment_history_all hist
4548: WHERE hist.payment_history_id = dist.payment_history_id
4549: AND hist.posted_flag = 'Y')
4550: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
4551: FROM AP_INVOICES_ALL inv,

Line 4581: FROM ap_payment_history_all hist

4577: program_update_date=SYSDATE
4578: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
4579: AND dist.pay_dist_lookup_code = 'DISCOUNT'
4580: AND EXISTS (SELECT NULL
4581: FROM ap_payment_history_all hist
4582: WHERE hist.payment_history_id = dist.payment_history_id
4583: AND hist.posted_flag = 'Y')
4584: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
4585: FROM AP_INVOICES_ALL inv,

Line 8735: FROM ap_payment_history_all hist

8731: program_application_id= G_PROG_APPL_ID,
8732: program_update_date=SYSDATE
8733: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
8734: AND EXISTS (SELECT NULL
8735: FROM ap_payment_history_all hist
8736: WHERE hist.payment_history_id = dist.payment_history_id
8737: AND hist.posted_flag = 'Y')
8738: AND EXISTS (SELECT invoice_id
8739: FROM AP_invoice_distributions aid

Line 8768: FROM ap_payment_history_all hist

8764: program_application_id= G_PROG_APPL_ID,
8765: program_update_date=SYSDATE
8766: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
8767: AND EXISTS (SELECT NULL
8768: FROM ap_payment_history_all hist
8769: WHERE hist.payment_history_id = dist.payment_history_id
8770: AND hist.posted_flag = 'Y')
8771: AND EXISTS (SELECT aid.invoice_id
8772: FROM AP_invoice_distributions aid

Line 8807: FROM ap_payment_history_all hist

8803: program_application_id= G_PROG_APPL_ID,
8804: program_update_date=SYSDATE
8805: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
8806: AND EXISTS (SELECT NULL
8807: FROM ap_payment_history_all hist
8808: WHERE hist.payment_history_id = dist.payment_history_id
8809: AND hist.posted_flag = 'Y')
8810: AND EXISTS (SELECT aid.invoice_id
8811: FROM AP_invoice_distributions aid

Line 8839: FROM ap_payment_history_all hist

8835: program_application_id= G_PROG_APPL_ID,
8836: program_update_date=SYSDATE
8837: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
8838: AND EXISTS (SELECT NULL
8839: FROM ap_payment_history_all hist
8840: WHERE hist.payment_history_id = dist.payment_history_id
8841: AND hist.posted_flag = 'Y')
8842: AND EXISTS (SELECT aid.invoice_id
8843: FROM AP_invoice_distributions aid

Line 8909: FROM ap_payment_history_all hist

8905: program_update_date=SYSDATE
8906: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
8907: AND dist.pay_dist_lookup_code = 'CASH'
8908: AND EXISTS (SELECT NULL
8909: FROM ap_payment_history_all hist
8910: WHERE hist.payment_history_id = dist.payment_history_id
8911: AND hist.posted_flag = 'Y')
8912: AND exists (SELECT inv.invoice_id
8913: FROM AP_INVOICES inv,

Line 8999: FROM ap_payment_history_all hist

8995: program_update_date=SYSDATE
8996: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
8997: AND dist.pay_dist_lookup_code = 'CASH'
8998: AND EXISTS (SELECT NULL
8999: FROM ap_payment_history_all hist
9000: WHERE hist.payment_history_id = dist.payment_history_id
9001: AND hist.posted_flag = 'Y')
9002: AND exists (SELECT inv.invoice_id
9003: FROM AP_INVOICES_ALL inv,

Line 9104: FROM ap_payment_history_all hist

9100: program_update_date=SYSDATE
9101: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
9102: AND dist.pay_dist_lookup_code = 'CASH'
9103: AND EXISTS (SELECT NULL
9104: FROM ap_payment_history_all hist
9105: WHERE hist.payment_history_id = dist.payment_history_id
9106: AND hist.posted_flag = 'Y')
9107: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
9108: FROM AP_INVOICES_ALL inv,

Line 9206: FROM ap_payment_history_all hist

9202: program_update_date=SYSDATE
9203: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
9204: AND dist.pay_dist_lookup_code = 'CASH'
9205: AND EXISTS (SELECT NULL
9206: FROM ap_payment_history_all hist
9207: WHERE hist.payment_history_id = dist.payment_history_id
9208: AND hist.posted_flag = 'Y')
9209: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
9210: FROM AP_INVOICES_ALL inv,