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 923: FROM ap_payment_history_all hist

919: , DIST.request_id = G_REQUEST_ID
920: WHERE DIST.pa_addition_flag = 'O'
921: AND dist.pay_dist_lookup_code = 'DISCOUNT'
922: AND EXISTS (SELECT /*+ push_subq no_unnest */ NULL /* added hint for BUG 13002753 */
923: FROM ap_payment_history_all hist
924: WHERE hist.payment_history_id = dist.payment_history_id
925: AND hist.posted_flag = 'Y')
926: AND NOT EXISTS ( SELECT /*+ push_subq no_unnest */ 'X' /* added hint for BUG 13002753 */
927: FROM pa_expenditure_items_all ei

Line 968: FROM ap_payment_history_all hist

964: , DIST.request_id = G_REQUEST_ID
965: WHERE DIST.pa_addition_flag = 'O'
966: AND dist.pay_dist_lookup_code = 'CASH'
967: AND EXISTS (SELECT NULL
968: FROM ap_payment_history_all hist
969: WHERE hist.payment_history_id = dist.payment_history_id
970: AND hist.posted_flag = 'Y')
971: AND NOT EXISTS ( SELECT 'X'
972: FROM pa_expenditure_items_all ei

Line 5340: FROM ap_payment_history_all hist

5336: program_update_date=SYSDATE
5337: WHERE dist.pa_addition_flag = 'N' /*Removed NVL statement for bug#14073110 */
5338: AND dist.pay_dist_lookup_code = 'CASH'
5339: AND EXISTS (SELECT NULL
5340: FROM ap_payment_history_all hist
5341: WHERE hist.payment_history_id = dist.payment_history_id
5342: AND hist.posted_flag = 'Y')
5343: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
5344: FROM AP_INVOICES_ALL inv,

Line 5607: FROM ap_payment_history_all hist

5603: program_update_date=SYSDATE
5604: WHERE dist.pa_addition_flag = 'N' /*Removed NVL statement for bug#14073110 */
5605: AND dist.pay_dist_lookup_code = 'DISCOUNT'
5606: AND EXISTS (SELECT NULL
5607: FROM ap_payment_history_all hist
5608: WHERE hist.payment_history_id = dist.payment_history_id
5609: AND hist.posted_flag = 'Y')
5610: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5611: FROM AP_INVOICES_ALL inv,

Line 5645: FROM ap_payment_history_all hist

5641: program_update_date=SYSDATE
5642: WHERE dist.pa_addition_flag = 'N' /*Removed NVL statement for bug#14073110 */
5643: AND dist.pay_dist_lookup_code = 'DISCOUNT'
5644: AND EXISTS (SELECT NULL
5645: FROM ap_payment_history_all hist
5646: WHERE hist.payment_history_id = dist.payment_history_id
5647: and hist.accounting_event_id = dist.accounting_event_id /*Bug# 9266578 */
5648: -- commented as part of Bug 10626450 and hist.transaction_type = 'PAYMENT CLEARING' /*Bug# 9266578 */
5649: and hist.transaction_type in ( 'PAYMENT CREATED','PAYMENT CANCELLED') /* 'PAYMENT CREATED' Added as part of Bug 10626450 ,'PAYMENT CANCELLED' as part of 11703565 */

Line 5690: -- ap_payment_history_all.transaction_type not in ( 'PAYMENT CREATED','PAYMENT CANCELLED') transactions

5686: G_DISC_DISTRIBUTIONS_MARKED := SQL%ROWCOUNT;
5687: write_log(LOG, 'Number of Discount rows marked to O: ' || to_char(SQL%ROWCOUNT));
5688:
5689: -- Bug 11775600 added the following update statement to mark pa_addition_flag to G for
5690: -- ap_payment_history_all.transaction_type not in ( 'PAYMENT CREATED','PAYMENT CANCELLED') transactions
5691:
5692: UPDATE ap_payment_hist_dists dist
5693: SET dist.pa_addition_flag = 'G',
5694: request_id = G_REQUEST_ID,

Line 5704: FROM ap_payment_history_all hist

5700: program_update_date=SYSDATE
5701: WHERE dist.pa_addition_flag = 'N' /*Removed NVL statement for bug#14073110 */
5702: AND dist.pay_dist_lookup_code = 'DISCOUNT'
5703: AND EXISTS (SELECT NULL
5704: FROM ap_payment_history_all hist
5705: WHERE hist.payment_history_id = dist.payment_history_id
5706: and hist.accounting_event_id = dist.accounting_event_id /*Bug# 9266578 */
5707: -- commented as part of Bug 10626450 and hist.transaction_type = 'PAYMENT CLEARING' /*Bug# 9266578 */
5708: and hist.transaction_type not in ( 'PAYMENT CREATED','PAYMENT CANCELLED') /* 'PAYMENT CREATED' Added as part of Bug 10626450 ,'PAYMENT CANCELLED' as part of 11703565 */

Line 5764: FROM ap_payment_history_all hist

5760: program_update_date=SYSDATE
5761: WHERE dist.pa_addition_flag = 'N' /*Removed NVL statement for bug#14073110 */
5762: AND dist.pay_dist_lookup_code = 'DISCOUNT'
5763: AND EXISTS (SELECT NULL
5764: FROM ap_payment_history_all hist
5765: WHERE hist.payment_history_id = dist.payment_history_id
5766: AND hist.posted_flag = 'Y')
5767: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5768: FROM AP_INVOICES_ALL inv,

Line 5798: FROM ap_payment_history_all hist

5794: program_update_date=SYSDATE
5795: WHERE dist.pa_addition_flag = 'N' /*Removed NVL statement for bug#14073110 */
5796: AND dist.pay_dist_lookup_code = 'DISCOUNT'
5797: AND EXISTS (SELECT NULL
5798: FROM ap_payment_history_all hist
5799: WHERE hist.payment_history_id = dist.payment_history_id
5800: and hist.accounting_event_id = dist.accounting_event_id /*Bug# 9266578 */
5801: -- commented as part of Bug 10626450 and hist.transaction_type = 'PAYMENT CLEARING' /*Bug# 9266578 */
5802: and hist.transaction_type in ( 'PAYMENT CREATED','PAYMENT CANCELLED') /* 'PAYMENT CREATED' Added as part of Bug 10626450 ,'PAYMENT CANCELLED' as part of 11703565 */

Line 5842: -- ap_payment_history_all.transaction_type not in ( 'PAYMENT CREATED','PAYMENT CANCELLED') transactions

5838: G_DISC_DISTRIBUTIONS_MARKED := SQL%ROWCOUNT;
5839: write_log(LOG, 'Number of Discount rows marked to O: ' || to_char(SQL%ROWCOUNT));
5840:
5841: -- Bug 11775600 added the following update statement to mark pa_addition_flag to G for
5842: -- ap_payment_history_all.transaction_type not in ( 'PAYMENT CREATED','PAYMENT CANCELLED') transactions
5843:
5844: UPDATE ap_payment_hist_dists dist
5845: SET dist.pa_addition_flag = 'G',
5846: request_id = G_REQUEST_ID,

Line 5856: FROM ap_payment_history_all hist

5852: program_update_date=SYSDATE
5853: WHERE dist.pa_addition_flag = 'N' /*Removed NVL statement for bug#14073110 */
5854: AND dist.pay_dist_lookup_code = 'DISCOUNT'
5855: AND EXISTS (SELECT NULL
5856: FROM ap_payment_history_all hist
5857: WHERE hist.payment_history_id = dist.payment_history_id
5858: and hist.accounting_event_id = dist.accounting_event_id /*Bug# 9266578 */
5859: -- commented as part of Bug 10626450 and hist.transaction_type = 'PAYMENT CLEARING' /*Bug# 9266578 */
5860: and hist.transaction_type not in ( 'PAYMENT CREATED','PAYMENT CANCELLED') /* 'PAYMENT CREATED' Added as part of Bug 10626450 ,'PAYMENT CANCELLED' as part of 11703565 */

Line 10449: FROM ap_payment_history_all hist

10445: program_application_id= G_PROG_APPL_ID,
10446: program_update_date=SYSDATE
10447: WHERE dist.pa_addition_flag = 'N' /*Removed NVL statement for bug#14073110 */
10448: AND EXISTS (SELECT NULL
10449: FROM ap_payment_history_all hist
10450: WHERE hist.payment_history_id = dist.payment_history_id
10451: AND hist.posted_flag = 'Y')
10452: AND EXISTS (SELECT invoice_id
10453: FROM AP_invoice_distributions aid

Line 10483: FROM ap_payment_history_all hist

10479: program_application_id= G_PROG_APPL_ID,
10480: program_update_date=SYSDATE
10481: WHERE dist.pa_addition_flag = 'N' /*Removed NVL statement for bug#14073110 */
10482: AND EXISTS (SELECT NULL
10483: FROM ap_payment_history_all hist
10484: WHERE hist.payment_history_id = dist.payment_history_id
10485: AND hist.posted_flag = 'Y')
10486: AND EXISTS (SELECT aid.invoice_id
10487: FROM AP_invoice_distributions aid

Line 10523: FROM ap_payment_history_all hist

10519: program_application_id= G_PROG_APPL_ID,
10520: program_update_date=SYSDATE
10521: WHERE dist.pa_addition_flag = 'N' /*Removed NVL statement for bug#14073110 */
10522: AND EXISTS (SELECT NULL
10523: FROM ap_payment_history_all hist
10524: WHERE hist.payment_history_id = dist.payment_history_id
10525: AND hist.posted_flag = 'Y')
10526: AND EXISTS (SELECT aid.invoice_id
10527: FROM AP_invoice_distributions aid

Line 10556: FROM ap_payment_history_all hist

10552: program_application_id= G_PROG_APPL_ID,
10553: program_update_date=SYSDATE
10554: WHERE dist.pa_addition_flag = 'N' /*Removed NVL statement for bug#14073110 */
10555: AND EXISTS (SELECT NULL
10556: FROM ap_payment_history_all hist
10557: WHERE hist.payment_history_id = dist.payment_history_id
10558: AND hist.posted_flag = 'Y')
10559: AND EXISTS (SELECT aid.invoice_id
10560: FROM AP_invoice_distributions aid

Line 10627: FROM ap_payment_history_all hist

10623: program_update_date=SYSDATE
10624: WHERE dist.pa_addition_flag = 'N' /*Removed NVL statement for bug#14073110 */
10625: AND dist.pay_dist_lookup_code = 'CASH'
10626: AND EXISTS (SELECT NULL
10627: FROM ap_payment_history_all hist
10628: WHERE hist.payment_history_id = dist.payment_history_id
10629: AND hist.posted_flag = 'Y')
10630: AND exists (SELECT inv.invoice_id
10631: FROM AP_INVOICES inv,

Line 10717: FROM ap_payment_history_all hist

10713: program_update_date=SYSDATE
10714: WHERE dist.pa_addition_flag = 'N' /*Removed NVL statement for bug#14073110 */
10715: AND dist.pay_dist_lookup_code = 'CASH'
10716: AND EXISTS (SELECT NULL
10717: FROM ap_payment_history_all hist
10718: WHERE hist.payment_history_id = dist.payment_history_id
10719: AND hist.posted_flag = 'Y')
10720: AND exists (SELECT inv.invoice_id
10721: FROM AP_INVOICES_ALL inv,

Line 10822: FROM ap_payment_history_all hist

10818: program_update_date=SYSDATE
10819: WHERE dist.pa_addition_flag = 'N' /*Removed NVL statement for bug#14073110 */
10820: AND dist.pay_dist_lookup_code = 'CASH'
10821: AND EXISTS (SELECT NULL
10822: FROM ap_payment_history_all hist
10823: WHERE hist.payment_history_id = dist.payment_history_id
10824: AND hist.posted_flag = 'Y')
10825: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10826: FROM AP_INVOICES_ALL inv,

Line 10924: FROM ap_payment_history_all hist

10920: program_update_date=SYSDATE
10921: WHERE dist.pa_addition_flag = 'N' /*Removed NVL statement for bug#14073110 */
10922: AND dist.pay_dist_lookup_code = 'CASH'
10923: AND EXISTS (SELECT NULL
10924: FROM ap_payment_history_all hist
10925: WHERE hist.payment_history_id = dist.payment_history_id
10926: AND hist.posted_flag = 'Y')
10927: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10928: FROM AP_INVOICES_ALL inv,