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.IEX_CUST_OVERVIEW_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 58: -- FROM ar_payment_schedules ps,

54: -- Begin fix bug #4930425-jypark-01/11/2006-remove full table scan
55: -- CURSOR c_summ_info IS
56: -- SELECT COUNT(DECODE(ps.class, 'INV', ps.payment_schedule_id, 'DM', ps.payment_schedule_id, 'CB', ps.payment_schedule_id, NULL)) cnt_inv,
57: -- COUNT(DECODE(ps.class, 'INV', DECODE(del.status, 'DELINQUENT', del.delinquency_id, 'PREDELINQUENT', del.delinquency_id, NULL), NULL)) cnt_del
58: -- FROM ar_payment_schedules ps,
59: -- hz_cust_accounts ca,
60: -- iex_delinquencies del
61: -- WHERE ca.party_id = p_party_id
62: -- AND ps.customer_id = ca.cust_account_id

Line 68: FROM ar_payment_schedules ps,

64: -- AND del.payment_schedule_id(+) = ps.payment_schedule_id;
65:
66: CURSOR c_collectible_trx IS
67: SELECT COUNT(ps.payment_schedule_id) cnt_inv
68: FROM ar_payment_schedules ps,
69: hz_cust_accounts ca
70: WHERE ca.party_id = p_party_id
71: AND ps.customer_id = ca.cust_account_id
72: AND ps.status = 'OP'

Line 77: FROM ar_payment_schedules ps,

73: AND ps.class IN ('INV', 'DM', 'CB');
74:
75: CURSOR c_delinquent_inv IS
76: SELECT COUNT(del.delinquency_id) cnt_del
77: FROM ar_payment_schedules ps,
78: hz_cust_accounts ca,
79: iex_delinquencies del
80: WHERE ca.party_id = p_party_id
81: AND ps.customer_id = ca.cust_account_id

Line 644: FROM ar_payment_schedules ps,

640: -1, (PS.AMOUNT_DUE_ORIGINAL + NVL(PS.AMOUNT_ADJUSTED,0)) * NVL(PS.EXCHANGE_RATE, 1 ),
641: 0) )
642: )
643: ), 0) dso */
644: FROM ar_payment_schedules ps,
645: hz_cust_accounts ca,
646: -- Begin fix bug #5261855-jypark-06/16/2006-change to based table for performance
647: -- iex_delinquencies del,
648: iex_delinquencies_all del,

Line 673: FROM ar_payment_schedules ps,

669: SELECT
670: SUM(NVL(ps.acctd_amount_due_remaining,0)) net_balance,
671: SUM(DECODE(del.status, 'DELINQUENT', NVL(acctd_amount_due_remaining,0),
672: 'PREDELINQUENT', NVL(acctd_amount_due_remaining,0),0)) overdue_amt
673: FROM ar_payment_schedules ps,
674: hz_cust_accounts ca,
675: iex_delinquencies_all del,
676: ar_system_parameters sp
677: WHERE ca.party_id = l_party_id

Line 698: from ar_payment_schedules ps,

694: select nvl(sum(cm.total_amount * -1),0)
695: into l_amount_in_dispute
696: from ra_cm_requests cm
697: where cm.customer_trx_id in (select distinct ps.customer_trx_id
698: from ar_payment_schedules ps,
699: hz_cust_accounts ca
700: where ca.party_id = l_party_id
701: and ps.customer_id = ca.cust_account_id
702: and ps.status = 'OP')

Line 735: FROM ar_payment_schedules ps, iex_delinquencies del

731: else
732: --end moac change
733: OPEN c_overdue FOR
734: SELECT sum(acctd_amount_due_remaining) amount
735: FROM ar_payment_schedules ps, iex_delinquencies del
736: WHERE ps.customer_id = p_object_id
737: -- fix bug #3561828 AND ps.due_date < sysdate
738: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
739: -- AND TRUNC(ps.due_date) < TRUNC(sysdate)

Line 756: from ar_payment_schedules ps,

752: select nvl(sum(cm.total_amount * -1),0)
753: into l_amount_in_dispute
754: from ra_cm_requests cm
755: where cm.customer_trx_id in (select distinct ps.customer_trx_id
756: from ar_payment_schedules ps,
757: ar_system_parameters parm
758: where ps.customer_id = p_object_id
759: and ps.org_id = parm.org_id
760: and ps.status = 'OP')

Line 771: FROM ar_payment_schedules ps,

767: --End bug 7612000 gnramasa 4th Dec 08
768:
769: OPEN c_balance FOR
770: SELECT SUM(NVL(acctd_amount_due_remaining,0))
771: FROM ar_payment_schedules ps,
772: -- Begin fix bug #5077320-jypark-adding parameter table to show amount for selected operating unit
773: ar_system_parameters parm
774: WHERE customer_id = p_object_id
775: AND ps.org_id = parm.org_id

Line 820: ar_payment_schedules ps

816: 0) )
817: )
818: ), 0) /* DSO */
819: /* FROM ar_system_parameters sp,
820: ar_payment_schedules ps
821: WHERE ps.customer_id = l_cust_account_id
822: AND NVL(ps.receipt_confirmed_flag,'Y') = 'Y'
823: AND ps.org_id=sp.org_id; --added for moac change
824:

Line 857: FROM ar_payment_schedules ps, iex_delinquencies del

853: else
854: --end moac change
855: OPEN c_overdue FOR
856: SELECT ps.acctd_amount_due_remaining
857: FROM ar_payment_schedules ps, iex_delinquencies del
858: WHERE del.delinquency_id = p_object_id
859: AND ps.payment_schedule_id = del.payment_schedule_id
860: AND ps.status = 'OP'
861: AND del.status IN ('DELINQUENT', 'PREDELINQUENT');

Line 878: FROM ar_payment_schedules ps, iex_delinquencies del

874: from ra_cm_requests cm
875: where cm.customer_trx_id in
876: (
877: SELECT distinct ps.customer_trx_id
878: FROM ar_payment_schedules ps, iex_delinquencies del
879: WHERE del.delinquency_id = p_object_id
880: AND ps.payment_schedule_id = del.payment_schedule_id
881: AND ps.status = 'OP'
882: AND del.status IN ('DELINQUENT', 'PREDELINQUENT'))

Line 927: ar_payment_schedules ps

923: 0) )
924: )
925: ), 0) /* DSO */
926: FROM ar_system_parameters sp,
927: ar_payment_schedules ps
928: WHERE NVL(ps.receipt_confirmed_flag,'Y') = 'Y'
929: AND ps.payment_schedule_id = l_payment_schedule_id
930: AND ps.org_id=sp.org_id; --added for moac change
931: FETCH c_dso INTO x_object_info_rec.dso;

Line 953: FROM ar_payment_schedules ps, iex_delinquencies del

949: --end moac change
950:
951: OPEN c_overdue FOR
952: SELECT sum(acctd_amount_due_remaining) amount
953: FROM ar_payment_schedules ps, iex_delinquencies del
954: WHERE ps.customer_site_use_id = p_object_id
955: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
956: -- AND ps.due_date < sysdate
957: --END-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due

Line 973: FROM ar_payment_schedules ps,

969: select nvl(sum(cm.total_amount * -1),0)
970: into l_amount_in_dispute
971: from ra_cm_requests cm
972: where cm.customer_trx_id in (select distinct ps.customer_trx_id
973: FROM ar_payment_schedules ps,
974: ar_system_parameters parm
975: WHERE ps.customer_site_use_id = p_object_id
976: AND ps.org_id = parm.org_id
977: AND ps.status = 'OP')

Line 986: FROM ar_payment_schedules ps,

982: --End bug 7612000 gnramasa 4th Dec 08
983:
984: OPEN c_balance FOR
985: SELECT SUM(NVL(acctd_amount_due_remaining,0))
986: FROM ar_payment_schedules ps,
987: -- Begin fix bug #5077320-jypark-adding parameter table to show amount for selected operating unit
988: ar_system_parameters parm
989: WHERE customer_site_use_id = p_object_id
990: AND ps.org_id = parm.org_id

Line 1000: -- FROM ar_payment_schedules

996: -- 'DM', acctd_amount_due_remaining,
997: -- 'DEP', acctd_amount_due_remaining,
998: -- 'CM', acctd_amount_due_remaining,
999: -- 'PMT', acctd_amount_due_remaining))
1000: -- FROM ar_payment_schedules
1001: -- End fix bug #5077320-jypark-adding parameter table to show amount for selected operating unit
1002:
1003: FETCH c_balance INTO x_object_info_rec.current_balance;
1004: CLOSE c_balance;

Line 1044: ar_payment_schedules ps

1040: 0) )
1041: )
1042: ), 0) /* DSO */
1043: /* FROM ar_system_parameters sp,
1044: ar_payment_schedules ps
1045: WHERE ps.customer_site_use_id = l_customer_site_use_id
1046: AND NVL(ps.receipt_confirmed_flag,'Y') = 'Y'
1047: AND ps.org_id=sp.org_id; --added for moac change
1048:

Line 1228: FROM ar_payment_schedules apsa,

1224: ara.amount_applied amount,
1225: apsa.invoice_currency_Code currency_code ,
1226: acr.receipt_number,
1227: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', acr.status)
1228: FROM ar_payment_schedules apsa,
1229: ar_cash_receipts acr,
1230: ar_receivable_applications ara,
1231: ar_cash_receipt_history acrh,
1232: iex_delinquencies del

Line 1283: l_data_from := l_data_from || ' AR_RECEIVABLE_APPLICATIONS RA, AR_PAYMENT_SCHEDULES PS ';

1279: l_data_query := l_data_query || ' TRX_SUM.LAST_PAYMENT_AMOUNT, TRX_SUM.CURRENCY, TRX_SUM.LAST_PAYMENT_NUMBER, ';
1280: l_data_query := l_data_query || ' ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING(''CHECK_STATUS'', CR.STATUS) ';
1281: l_data_from := 'FROM ';
1282: l_data_from := l_data_from || ' AR_TRX_BAL_SUMMARY TRX_SUM, HZ_CUST_ACCOUNTS CA, AR_CASH_RECEIPTS CR, ';
1283: l_data_from := l_data_from || ' AR_RECEIVABLE_APPLICATIONS RA, AR_PAYMENT_SCHEDULES PS ';
1284: l_data_where := 'WHERE TRX_SUM.CUST_ACCOUNT_ID = :1 ';
1285: l_data_where := l_data_where || ' and TRX_SUM.SITE_USE_ID = :2 ';
1286: l_data_where := l_data_where || ' and TRX_SUM.ORG_ID = :3 ';
1287: l_data_where := l_data_where || ' and TRX_SUM.CURRENCY = :4 ';

Line 1356: -- ar_payment_schedules ps

1352: -- IF x_last_pmt_info_rec.cash_receipt_id IS NOT NULL THEN
1353: -- OPEN c_last_pmt2 FOR
1354: -- SELECT decode(ps.payment_schedule_id, -1, null, ps.due_date)
1355: -- FROM ar_receivable_applications ra,
1356: -- ar_payment_schedules ps
1357: -- WHERE ra.cash_receipt_id = l_receipt
1358: -- AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
1359: --
1360: -- FETCH c_last_pmt2 INTO x_last_pmt_info_rec.due_date;

Line 1390: -- ar_payment_schedules ps

1386: -- ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1387: -- FROM ar_trx_bal_summary trx_sum,
1388: -- hz_cust_accounts ca, ar_cash_receipts cr,
1389: -- ar_receivable_applications ra,
1390: -- ar_payment_schedules ps
1391: -- WHERE trx_sum.cust_account_id = ca.cust_account_id
1392: -- AND ca.party_id = p_object_id
1393: -- AND cr.receipt_number = trx_sum.last_payment_number
1394: -- AND ra.cash_receipt_id(+) = cr.cash_receipt_id

Line 1434: ar_payment_schedules ps

1430:
1431: OPEN c_last_pmt2 FOR
1432: SELECT decode(ps.payment_schedule_id, -1, null, ps.due_date)
1433: FROM ar_receivable_applications ra,
1434: ar_payment_schedules ps
1435: WHERE ra.cash_receipt_id = x_last_pmt_info_rec.cash_receipt_id
1436: AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
1437:
1438: FETCH c_last_pmt2 INTO x_last_pmt_info_rec.due_date;

Line 1454: -- ar_payment_schedules ps

1450: -- ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1451: -- FROM ar_trx_bal_summary trx_sum,
1452: -- ar_cash_receipts cr,
1453: -- ar_receivable_applications ra,
1454: -- ar_payment_schedules ps
1455: -- WHERE trx_sum.cust_account_id = p_object_id
1456: -- AND cr.receipt_number = trx_sum.last_payment_number
1457: -- AND ra.cash_receipt_id(+) = cr.cash_receipt_id
1458: -- AND ps.payment_schedule_id(+) = ra.applied_payment_schedule_id

Line 1497: ar_payment_schedules ps

1493:
1494: OPEN c_last_pmt2 FOR
1495: SELECT decode(ps.payment_schedule_id, -1, null, ps.due_date)
1496: FROM ar_receivable_applications ra,
1497: ar_payment_schedules ps
1498: WHERE ra.cash_receipt_id = x_last_pmt_info_rec.cash_receipt_id
1499: AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
1500:
1501: FETCH c_last_pmt2 INTO x_last_pmt_info_rec.due_date;

Line 1515: FROM ar_payment_schedules apsa,

1511: ara.amount_applied amount,
1512: apsa.invoice_currency_Code currency_code ,
1513: acr.receipt_number,
1514: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', acr.status)
1515: FROM ar_payment_schedules apsa,
1516: ar_cash_receipts acr,
1517: ar_receivable_applications ara,
1518: ar_cash_receipt_history acrh,
1519: iex_delinquencies del

Line 1584: ar_payment_schedules ps

1580:
1581: OPEN c_last_pmt2 FOR
1582: SELECT decode(ps.payment_schedule_id, -1, null, ps.due_date)
1583: FROM ar_receivable_applications ra,
1584: ar_payment_schedules ps
1585: WHERE ra.cash_receipt_id = x_last_pmt_info_rec.cash_receipt_id
1586: AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
1587:
1588: FETCH c_last_pmt2 INTO x_last_pmt_info_rec.due_date;

Line 1957: FROM ar_payment_schedules ps,

1953: -1, (PS.AMOUNT_DUE_ORIGINAL + NVL(PS.AMOUNT_ADJUSTED,0)) * NVL(PS.EXCHANGE_RATE, 1 ),
1954: 0) )
1955: )
1956: ), 0) dso
1957: FROM ar_payment_schedules ps,
1958: hz_cust_accounts ca,
1959: iex_delinquencies del,
1960: ar_system_parameters sp
1961: WHERE ca.party_id = p_party_id

Line 1970: FROM ar_payment_schedules ps,

1966: */
1967: CURSOR c_summ_info1 IS
1968: SELECT COUNT(DECODE(ps.class, 'INV', ps.payment_schedule_id, 'DM', ps.payment_schedule_id, 'CB', ps.payment_schedule_id, NULL)) cnt_inv,
1969: COUNT(DECODE(ps.class, 'INV', DECODE(del.status, 'DELINQUENT', del.delinquency_id, 'PREDELINQUENT', del.delinquency_id, NULL), NULL)) cnt_del
1970: FROM ar_payment_schedules ps,
1971: hz_cust_accounts ca,
1972: iex_delinquencies del
1973: WHERE ca.party_id = p_party_id
1974: AND ps.customer_id = ca.cust_account_id

Line 2016: FROM ar_payment_schedules ps,

2012: -1, (PS.AMOUNT_DUE_ORIGINAL + NVL(PS.AMOUNT_ADJUSTED,0)) * NVL(PS.EXCHANGE_RATE, 1 ),
2013: 0) )
2014: )
2015: ), 0) dso
2016: FROM ar_payment_schedules ps,
2017: hz_cust_accounts ca,
2018: iex_delinquencies del,
2019: ar_system_parameters sp
2020: WHERE ca.party_id = p_party_id

Line 2033: FROM ar_payment_schedules ps,

2029: CURSOR c_summ_info3 IS
2030: SELECT SUM(NVL(ps.acctd_amount_due_remaining,0)) net_balance,
2031: SUM(DECODE(del.status, 'DELINQUENT', NVL(acctd_amount_due_remaining,0),
2032: 'PREDELINQUENT', NVL(acctd_amount_due_remaining,0),0)) overdue_amt
2033: FROM ar_payment_schedules ps,
2034: hz_cust_accounts ca,
2035: iex_delinquencies del,
2036: ar_system_parameters sp
2037: WHERE ca.party_id = p_party_id

Line 2159: from ar_payment_schedules ps,

2155: select nvl(sum(cm.total_amount * -1),0)
2156: into l_amount_in_dispute
2157: from ra_cm_requests cm
2158: where cm.customer_trx_id in (select distinct customer_trx_id
2159: from ar_payment_schedules ps,
2160: hz_cust_accounts ca
2161: where ca.party_id = p_party_id
2162: and ps.customer_id = ca.cust_account_id
2163: and ps.status = 'OP')