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.AP_ACCOUNTING_PAY_PKG dependencies on AP_PAYMENT_HISTORY_ALL

Line 451: AP_Payment_History_All APH

447:
448: SELECT SUM(APHD.Amount)
449: INTO l_pay_sum
450: FROM AP_Payment_Hist_Dists APHD,
451: AP_Payment_History_All APH
452: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
453: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
454: AND APH.Related_Event_ID = P_Related_Event_ID
455: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 491: AP_Payment_History_All APH

487:
488: SELECT SUM(APHD.Invoice_Dist_Amount)
489: INTO l_inv_dist_sum
490: FROM AP_Payment_Hist_Dists APHD,
491: AP_Payment_History_All APH
492: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
493: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
494: AND APH.Related_Event_ID = P_Related_Event_ID
495: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 531: AP_Payment_History_All APH

527:
528: SELECT SUM(APHD.Bank_Curr_Amount)
529: INTO l_bank_curr_sum
530: FROM AP_Payment_Hist_Dists APHD,
531: AP_Payment_History_All APH
532: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
533: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
534: AND APH.Related_Event_ID = P_Related_Event_ID
535: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 642: AP_Payment_History_All APH

638:
639: SELECT SUM(APHD.Amount)
640: INTO l_discount_sum
641: FROM AP_Payment_Hist_Dists APHD,
642: AP_Payment_History_All APH
643: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
644: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
645: AND APH.Related_Event_ID = P_Related_Event_ID
646: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 681: AP_Payment_History_All APH

677:
678: SELECT SUM(APHD.Invoice_Dist_Amount)
679: INTO l_discount_sum
680: FROM AP_Payment_Hist_Dists APHD,
681: AP_Payment_History_All APH
682: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
683: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
684: AND APH.Related_Event_ID = P_Related_Event_ID
685: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 721: AP_Payment_History_All APH

717:
718: SELECT SUM(APHD.Bank_Curr_Amount)
719: INTO l_discount_sum
720: FROM AP_Payment_Hist_Dists APHD,
721: AP_Payment_History_All APH
722: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
723: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
724: AND APH.Related_Event_ID = P_Related_Event_ID
725: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 770: AP_Payment_History_All APH

766: INTO l_pay_sum,
767: l_inv_dist_sum,
768: l_bank_curr_sum
769: FROM AP_Payment_Hist_Dists APHD,
770: AP_Payment_History_All APH
771: WHERE APHD.Invoice_Distribution_ID in ( /*bug8882706*/
772: select p_invoice_distribution_id from dual
773: union
774: -- awt distributions which are applied on the p_invoice_distribution_id

Line 793: FROM AP_PAYMENT_HISTORY_ALL APH_REL

789: 'PAYMENT CLEARING ADJUSTED')
790:
791: AND NOT EXISTS
792: (SELECT 'Event Reversed'
793: FROM AP_PAYMENT_HISTORY_ALL APH_REL
794: WHERE APH_REL.check_id = APH.check_id --bug9282163
795: AND NVL(APH_REL.RELATED_EVENT_ID, APH_REL.ACCOUNTING_EVENT_ID) =
796: NVL(APH.RELATED_EVENT_ID, APH.ACCOUNTING_EVENT_ID)
797: AND APH_REL.REV_PMT_HIST_ID IS NOT NULL)

Line 801: FROM AP_PAYMENT_HISTORY_ALL APH_REL

797: AND APH_REL.REV_PMT_HIST_ID IS NOT NULL)
798: /*Bug 13908641*/
799: AND NOT EXISTS
800: (SELECT 'Event Reversed'
801: FROM AP_PAYMENT_HISTORY_ALL APH_REL
802: WHERE APH_REL.check_id = APH.check_id --bug9282163
803: AND APH_REL.REV_PMT_HIST_ID = APH.PAYMENT_HISTORY_ID
804: AND APH_REL.REV_PMT_HIST_ID IS NOT NULL);
805: --bug8975671, reversed entries and their reversals shouldn't be considered

Line 815: AP_Payment_History_All APH

811: INTO l_pay_sum,
812: l_inv_dist_sum,
813: l_bank_curr_sum
814: FROM AP_Payment_Hist_Dists APHD,
815: AP_Payment_History_All APH
816: WHERE APHD.Invoice_Distribution_ID in ( /*bug8882706*/
817: select p_invoice_distribution_id from dual
818: union
819: -- awt distributions which are applied on p_invoice_distribution_id

Line 837: FROM AP_PAYMENT_HISTORY_ALL APH_REL

833: AND APH.Transaction_Type IN ('PAYMENT MATURITY', 'PAYMENT MATURITY REVERSED',
834: 'PAYMENT MATURITY ADJUSTED')
835: AND NOT EXISTS
836: (SELECT 'Event Reversed'
837: FROM AP_PAYMENT_HISTORY_ALL APH_REL
838: WHERE APH_REL.check_id = APH.check_id --bug9282163
839: AND NVL(APH_REL.RELATED_EVENT_ID, APH_REL.ACCOUNTING_EVENT_ID) =
840: NVL(APH.RELATED_EVENT_ID, APH.ACCOUNTING_EVENT_ID)
841: AND APH_REL.REV_PMT_HIST_ID IS NOT NULL)

Line 845: FROM AP_PAYMENT_HISTORY_ALL APH_REL

841: AND APH_REL.REV_PMT_HIST_ID IS NOT NULL)
842: /*Bug 13908641*/
843: AND NOT EXISTS
844: (SELECT 'Event Reversed'
845: FROM AP_PAYMENT_HISTORY_ALL APH_REL
846: WHERE APH_REL.check_id = APH.check_id --bug9282163
847: AND APH_REL.REV_PMT_HIST_ID = APH.PAYMENT_HISTORY_ID
848: AND APH_REL.REV_PMT_HIST_ID IS NOT NULL);
849: --bug8975671, reversed entries and their reversals shouldn't be considered

Line 859: AP_Payment_History_All APH

855: INTO l_pay_sum,
856: l_inv_dist_sum,
857: l_bank_curr_sum
858: FROM AP_Payment_Hist_Dists APHD,
859: AP_Payment_History_All APH
860: WHERE APHD.Invoice_Distribution_ID in ( /*bug 8882706*/
861: select p_invoice_distribution_id from dual
862: union
863: -- awt distributions which are applied on p_invoice_distribution_id

Line 882: FROM AP_PAYMENT_HISTORY_ALL APH_REL

878: 'REFUND RECORDED', 'REFUND ADJUSTED', 'REFUND CANCELLED',
879: 'MANUAL REFUND ADJUSTED')
880: AND NOT EXISTS
881: (SELECT 'Event Reversed'
882: FROM AP_PAYMENT_HISTORY_ALL APH_REL
883: WHERE APH_REL.check_id = APH.check_id --bug9282163
884: AND NVL(APH_REL.RELATED_EVENT_ID, APH_REL.ACCOUNTING_EVENT_ID) =
885: NVL(APH.RELATED_EVENT_ID, APH.ACCOUNTING_EVENT_ID)
886: AND APH_REL.REV_PMT_HIST_ID IS NOT NULL)

Line 890: FROM AP_PAYMENT_HISTORY_ALL APH_REL

886: AND APH_REL.REV_PMT_HIST_ID IS NOT NULL)
887: /*Bug 13908641*/
888: AND NOT EXISTS
889: (SELECT 'Event Reversed'
890: FROM AP_PAYMENT_HISTORY_ALL APH_REL
891: WHERE APH_REL.check_id = APH.check_id --bug9282163
892: AND APH_REL.REV_PMT_HIST_ID = APH.PAYMENT_HISTORY_ID
893: AND APH_REL.REV_PMT_HIST_ID IS NOT NULL);
894: --bug8975671, reversed entries and their reversals shouldn't be considered

Line 949: , AP_Payment_History_All APH

945: INTO l_pay_sum
946: , l_inv_dist_sum
947: , l_bank_curr_sum
948: FROM AP_Payment_Hist_Dists APHD
949: , AP_Payment_History_All APH
950: WHERE APHD.Invoice_Distribution_ID IN
951: (SELECT p_invoice_distribution_id
952: FROM dual
953: UNION

Line 972: FROM AP_PAYMENT_HISTORY_ALL APH_REL

968: AND APH.Transaction_Type IN( 'PAYMENT CLEARING',
969: 'PAYMENT UNCLEARING', 'PAYMENT CLEARING ADJUSTED' )
970: AND NOT EXISTS
971: (SELECT 'Event Reversed'
972: FROM AP_PAYMENT_HISTORY_ALL APH_REL
973: WHERE APH_REL.check_id = APH.check_id
974: AND NVL( APH_REL.RELATED_EVENT_ID, APH_REL.ACCOUNTING_EVENT_ID )
975: = NVL( APH.RELATED_EVENT_ID, APH.ACCOUNTING_EVENT_ID )
976: AND APH_REL.REV_PMT_HIST_ID IS NOT NULL

Line 987: , AP_Payment_History_All APH

983: INTO l_pay_sum
984: , l_inv_dist_sum
985: , l_bank_curr_sum
986: FROM AP_Payment_Hist_Dists APHD
987: , AP_Payment_History_All APH
988: WHERE APHD.Invoice_Distribution_ID IN
989: (SELECT p_invoice_distribution_id
990: FROM dual
991: UNION

Line 1010: FROM AP_PAYMENT_HISTORY_ALL APH_REL

1006: AND APH.Transaction_Type IN( 'PAYMENT MATURITY',
1007: 'PAYMENT MATURITY REVERSED', 'PAYMENT MATURITY ADJUSTED' )
1008: AND NOT EXISTS
1009: (SELECT 'Event Reversed'
1010: FROM AP_PAYMENT_HISTORY_ALL APH_REL
1011: WHERE APH_REL.check_id = APH.check_id
1012: AND NVL( APH_REL.RELATED_EVENT_ID, APH_REL.ACCOUNTING_EVENT_ID )
1013: = NVL( APH.RELATED_EVENT_ID, APH.ACCOUNTING_EVENT_ID )
1014: AND APH_REL.REV_PMT_HIST_ID IS NOT NULL

Line 1025: , AP_Payment_History_All APH

1021: INTO l_pay_sum
1022: , l_inv_dist_sum
1023: , l_bank_curr_sum
1024: FROM AP_Payment_Hist_Dists APHD
1025: , AP_Payment_History_All APH
1026: WHERE APHD.Invoice_Distribution_ID IN
1027: (SELECT p_invoice_distribution_id
1028: FROM dual
1029: UNION

Line 1050: FROM AP_PAYMENT_HISTORY_ALL APH_REL

1046: 'UPGRADED MANUAL PMT ADJUSTED', 'REFUND RECORDED', 'REFUND ADJUSTED',
1047: 'REFUND CANCELLED', 'MANUAL REFUND ADJUSTED' )
1048: AND NOT EXISTS
1049: (SELECT 'Event Reversed'
1050: FROM AP_PAYMENT_HISTORY_ALL APH_REL
1051: WHERE APH_REL.check_id = APH.check_id
1052: AND NVL( APH_REL.RELATED_EVENT_ID, APH_REL.ACCOUNTING_EVENT_ID )
1053: = NVL( APH.RELATED_EVENT_ID, APH.ACCOUNTING_EVENT_ID )
1054: AND APH_REL.REV_PMT_HIST_ID IS NOT NULL

Line 1265: AP_Payment_History_All APH

1261: APHD.Amount)
1262: INTO l_paid_acctd_amt
1263: FROM AP_Payment_Hist_Dists APHD,
1264: AP_Invoice_Distributions_All AID,
1265: AP_Payment_History_All APH
1266: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
1267: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID
1268: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT') --bug 9265516, removed 'AWT'
1269: AND APH.Posted_Flag IN ('Y', 'S') --bug 7614480, added status 'S'

Line 1273: FROM AP_PAYMENT_HISTORY_ALL APH_REV

1269: AND APH.Posted_Flag IN ('Y', 'S') --bug 7614480, added status 'S'
1270: AND APH.Payment_History_ID = APHD.Payment_History_ID
1271: AND APH.Transaction_Type IN ('PAYMENT CLEARING')
1272: AND NOT EXISTS(SELECT 'reversed event'
1273: FROM AP_PAYMENT_HISTORY_ALL APH_REV
1274: WHERE APH_REV.check_id = APH.check_id --bug9282163
1275: AND nvl(aph_rev.related_event_id, aph_rev.accounting_event_id)
1276: = nvl(aph.related_event_id, aph.accounting_event_id)
1277: AND aph_rev.rev_pmt_hist_id IS NOT NULL); --bug 7614480, added not exists

Line 1296: AP_Payment_History_All APH

1292: APHD.Amount)
1293: INTO l_paid_acctd_amt
1294: FROM AP_Payment_Hist_Dists APHD,
1295: AP_Invoice_Distributions_All AID,
1296: AP_Payment_History_All APH
1297: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
1298: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID
1299: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT') --bug 9265516, removed 'AWT'
1300: AND APH.Posted_Flag IN ('Y', 'S') --bug 7614480, added status 'S'

Line 1304: FROM AP_PAYMENT_HISTORY_ALL APH_REV

1300: AND APH.Posted_Flag IN ('Y', 'S') --bug 7614480, added status 'S'
1301: AND APH.Payment_History_ID = APHD.Payment_History_ID
1302: AND APH.Transaction_Type IN ('PAYMENT MATURITY')
1303: AND NOT EXISTS(SELECT 'reversed event'
1304: FROM AP_PAYMENT_HISTORY_ALL APH_REV
1305: WHERE APH_REV.check_id = APH.check_id --bug9282163
1306: AND nvl(aph_rev.related_event_id, aph_rev.accounting_event_id)
1307: = nvl(aph.related_event_id, aph.accounting_event_id)
1308: AND aph_rev.rev_pmt_hist_id IS NOT NULL); --bug 7614480, added not exists

Line 1327: AP_Payment_History_All APH,

1323: APHD.Amount)
1324: INTO l_paid_acctd_amt
1325: FROM AP_Payment_Hist_Dists APHD,
1326: AP_Invoice_Distributions_All AID,
1327: AP_Payment_History_All APH,
1328: AP_INVOICE_PAYMENTS_ALL AIP
1329: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
1330: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID
1331: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT') --bug 9265516, removed 'AWT'

Line 1817: FROM ap_payment_history_all aph

1813: INTO l_unacctg_events_exist
1814: FROM DUAL
1815: WHERE EXISTS(
1816: SELECT 'unreversed, unaccounted payment not selected for accounting'
1817: FROM ap_payment_history_all aph
1818: , ap_invoice_payments_all aip
1819: , xla_event_types_b xet
1820: , xla_event_types_b xet_rel
1821: , xla_events xe

Line 1834: FROM ap_payment_history_all aph_rev

1830: AND xe.application_id = 200
1831: AND aph.posted_flag = 'N'
1832: AND NOT EXISTS(
1833: SELECT 'reversed event'
1834: FROM ap_payment_history_all aph_rev
1835: WHERE nvl(aph_rev.related_event_id, aph_rev.accounting_event_id)
1836: = nvl(aph.related_event_id, aph.accounting_event_id)
1837: AND aph_rev.check_id = aph.check_id /* bug12909730 */
1838: AND aph_rev.rev_pmt_hist_id IS NOT NULL)

Line 1891: FROM ap_payment_history_all aph

1887: FROM
1888: (
1889: -- payment
1890: SELECT MAX(aph.accounting_event_id) accounting_event_id
1891: FROM ap_payment_history_all aph
1892: , ap_invoice_payments_all aip
1893: , xla_event_types_b xet
1894: , xla_event_types_b xet_rel
1895: , xla_events xe

Line 1910: FROM ap_payment_history_all aph_rev

1906: AND xe.application_id = 200
1907: AND aph.posted_flag = 'S'
1908: AND NOT EXISTS(
1909: SELECT 'reversed event'
1910: FROM ap_payment_history_all aph_rev
1911: WHERE nvl(aph_rev.related_event_id, aph_rev.accounting_event_id)
1912: = nvl(aph.related_event_id, aph.accounting_event_id)
1913: AND aph_rev.check_id = aph.check_id /* bug12909730 */
1914: AND aph_rev.rev_pmt_hist_id IS NOT NULL)

Line 2032: from ap_payment_history_all aph,

2028:
2029: -- check for non-reversed, upgrade payment clearing accounting w.r.t invoice_id
2030: select count(1)
2031: into l_upg_pay_actg_for_inv
2032: from ap_payment_history_all aph,
2033: ap_system_parameters_all asp,
2034: xla_ae_headers xah
2035: where aph.check_id in
2036: (select aip.check_id

Line 2045: from ap_payment_history_all aph_rel

2041: and aph.transaction_type IN ('PAYMENT CLEARING',
2042: 'PAYMENT UNCLEARING',
2043: 'PAYMENT CLEARING ADJUSTED')
2044: and not exists (select 'event reversed'
2045: from ap_payment_history_all aph_rel
2046: where aph_rel.check_id = aph.check_id
2047: and nvl(aph_rel.related_event_id, aph_rel.accounting_event_id) =
2048: nvl(aph.related_event_id, aph.accounting_event_id)
2049: and aph_rel.rev_pmt_hist_id is not null)

Line 2064: from ap_payment_history_all aph,

2060:
2061: -- check for non-reversed, upgrade payment maturity accounting w.r.t invoice_id
2062: select count(1)
2063: into l_upg_pay_actg_for_inv
2064: from ap_payment_history_all aph,
2065: ap_system_parameters_all asp,
2066: xla_ae_headers xah
2067: where aph.check_id in
2068: (select aip.check_id

Line 2077: from ap_payment_history_all aph_rel

2073: and aph.transaction_type IN ('PAYMENT MATURITY',
2074: 'PAYMENT MATURITY REVERSED',
2075: 'PAYMENT MATURITY ADJUSTED')
2076: and not exists (select 'event reversed'
2077: from ap_payment_history_all aph_rel
2078: where aph_rel.check_id = aph.check_id
2079: and nvl(aph_rel.related_event_id, aph_rel.accounting_event_id) =
2080: nvl(aph.related_event_id, aph.accounting_event_id)
2081: and aph_rel.rev_pmt_hist_id is not null)

Line 2096: from ap_payment_history_all aph,

2092:
2093: -- check for non-reversed, upgrade payment accounting w.r.t invoice_id
2094: select count(1)
2095: into l_upg_pay_actg_for_inv
2096: from ap_payment_history_all aph,
2097: ap_system_parameters_all asp,
2098: xla_ae_headers xah
2099: where aph.check_id in
2100: (select aip.check_id

Line 2110: from ap_payment_history_all aph_rel

2106: 'MANUAL PAYMENT ADJUSTED', 'UPGRADED MANUAL PMT ADJUSTED',
2107: 'REFUND RECORDED', 'REFUND ADJUSTED', 'REFUND CANCELLED',
2108: 'MANUAL REFUND ADJUSTED')
2109: and not exists (select 'event reversed'
2110: from ap_payment_history_all aph_rel
2111: where aph_rel.check_id = aph.check_id
2112: and nvl(aph_rel.related_event_id, aph_rel.accounting_event_id) =
2113: nvl(aph.related_event_id, aph.accounting_event_id)
2114: and aph_rel.rev_pmt_hist_id is not null)

Line 2162: from ap_payment_history_all aph,

2158: ELSIF P_Rounding_Method=G_COMPARE_PAY THEN
2159: -- check for upgrade payment accounting w.r.t invoice_payment_id
2160: select count(1)
2161: into l_upg_pay_all_actg_for_inv
2162: from ap_payment_history_all aph,
2163: ap_system_parameters_all asp,
2164: xla_ae_headers xah
2165: where aph.check_id in
2166: (select aip.check_id