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 594: FROM ar_payment_schedules ps,

590: -1, (PS.AMOUNT_DUE_ORIGINAL + NVL(PS.AMOUNT_ADJUSTED,0)) * NVL(PS.EXCHANGE_RATE, 1 ),
591: 0) )
592: )
593: ), 0) dso
594: FROM ar_payment_schedules ps,
595: hz_cust_accounts ca,
596: -- Begin fix bug #5261855-jypark-06/16/2006-change to based table for performance
597: -- iex_delinquencies del,
598: iex_delinquencies_all del,

Line 620: from ar_payment_schedules ps,

616: select nvl(sum(cm.total_amount * -1),0)
617: into l_amount_in_dispute
618: from ra_cm_requests cm
619: where cm.customer_trx_id in (select distinct ps.customer_trx_id
620: from ar_payment_schedules ps,
621: hz_cust_accounts ca
622: where ca.party_id = l_party_id
623: and ps.customer_id = ca.cust_account_id
624: and ps.status = 'OP')

Line 655: FROM ar_payment_schedules ps, iex_delinquencies del

651: else
652: --end moac change
653: OPEN c_overdue FOR
654: SELECT sum(acctd_amount_due_remaining) amount
655: FROM ar_payment_schedules ps, iex_delinquencies del
656: WHERE ps.customer_id = p_object_id
657: -- fix bug #3561828 AND ps.due_date < sysdate
658: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
659: -- AND TRUNC(ps.due_date) < TRUNC(sysdate)

Line 676: from ar_payment_schedules ps,

672: select nvl(sum(cm.total_amount * -1),0)
673: into l_amount_in_dispute
674: from ra_cm_requests cm
675: where cm.customer_trx_id in (select distinct ps.customer_trx_id
676: from ar_payment_schedules ps,
677: ar_system_parameters parm
678: where ps.customer_id = p_object_id
679: and ps.org_id = parm.org_id
680: and ps.status = 'OP')

Line 689: FROM ar_payment_schedules ps,

685: --End bug 7612000 gnramasa 4th Dec 08
686:
687: OPEN c_balance FOR
688: SELECT SUM(NVL(acctd_amount_due_remaining,0))
689: FROM ar_payment_schedules ps,
690: -- Begin fix bug #5077320-jypark-adding parameter table to show amount for selected operating unit
691: ar_system_parameters parm
692: WHERE customer_id = p_object_id
693: AND ps.org_id = parm.org_id

Line 736: ar_payment_schedules ps

732: 0) )
733: )
734: ), 0) /* DSO */
735: FROM ar_system_parameters sp,
736: ar_payment_schedules ps
737: WHERE ps.customer_id = l_cust_account_id
738: AND NVL(ps.receipt_confirmed_flag,'Y') = 'Y'
739: AND ps.org_id=sp.org_id; --added for moac change
740:

Line 763: FROM ar_payment_schedules ps, iex_delinquencies del

759: else
760: --end moac change
761: OPEN c_overdue FOR
762: SELECT ps.acctd_amount_due_remaining
763: FROM ar_payment_schedules ps, iex_delinquencies del
764: WHERE del.delinquency_id = p_object_id
765: AND ps.payment_schedule_id = del.payment_schedule_id
766: AND ps.status = 'OP'
767: AND del.status IN ('DELINQUENT', 'PREDELINQUENT');

Line 784: FROM ar_payment_schedules ps, iex_delinquencies del

780: from ra_cm_requests cm
781: where cm.customer_trx_id in
782: (
783: SELECT distinct ps.customer_trx_id
784: FROM ar_payment_schedules ps, iex_delinquencies del
785: WHERE del.delinquency_id = p_object_id
786: AND ps.payment_schedule_id = del.payment_schedule_id
787: AND ps.status = 'OP'
788: AND del.status IN ('DELINQUENT', 'PREDELINQUENT'))

Line 831: ar_payment_schedules ps

827: 0) )
828: )
829: ), 0) /* DSO */
830: FROM ar_system_parameters sp,
831: ar_payment_schedules ps
832: WHERE NVL(ps.receipt_confirmed_flag,'Y') = 'Y'
833: AND ps.payment_schedule_id = l_payment_schedule_id
834: AND ps.org_id=sp.org_id; --added for moac change
835: FETCH c_dso INTO x_object_info_rec.dso;

Line 855: FROM ar_payment_schedules ps, iex_delinquencies del

851: --end moac change
852:
853: OPEN c_overdue FOR
854: SELECT sum(acctd_amount_due_remaining) amount
855: FROM ar_payment_schedules ps, iex_delinquencies del
856: WHERE ps.customer_site_use_id = p_object_id
857: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
858: -- AND ps.due_date < sysdate
859: --END-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due

Line 875: FROM ar_payment_schedules ps,

871: select nvl(sum(cm.total_amount * -1),0)
872: into l_amount_in_dispute
873: from ra_cm_requests cm
874: where cm.customer_trx_id in (select distinct ps.customer_trx_id
875: FROM ar_payment_schedules ps,
876: ar_system_parameters parm
877: WHERE ps.customer_site_use_id = p_object_id
878: AND ps.org_id = parm.org_id
879: AND ps.status = 'OP')

Line 888: FROM ar_payment_schedules ps,

884: --End bug 7612000 gnramasa 4th Dec 08
885:
886: OPEN c_balance FOR
887: SELECT SUM(NVL(acctd_amount_due_remaining,0))
888: FROM ar_payment_schedules ps,
889: -- Begin fix bug #5077320-jypark-adding parameter table to show amount for selected operating unit
890: ar_system_parameters parm
891: WHERE customer_site_use_id = p_object_id
892: AND ps.org_id = parm.org_id

Line 902: -- FROM ar_payment_schedules

898: -- 'DM', acctd_amount_due_remaining,
899: -- 'DEP', acctd_amount_due_remaining,
900: -- 'CM', acctd_amount_due_remaining,
901: -- 'PMT', acctd_amount_due_remaining))
902: -- FROM ar_payment_schedules
903: -- End fix bug #5077320-jypark-adding parameter table to show amount for selected operating unit
904:
905: FETCH c_balance INTO x_object_info_rec.current_balance;
906: CLOSE c_balance;

Line 944: ar_payment_schedules ps

940: 0) )
941: )
942: ), 0) /* DSO */
943: FROM ar_system_parameters sp,
944: ar_payment_schedules ps
945: WHERE ps.customer_site_use_id = l_customer_site_use_id
946: AND NVL(ps.receipt_confirmed_flag,'Y') = 'Y'
947: AND ps.org_id=sp.org_id; --added for moac change
948:

Line 1118: FROM ar_payment_schedules apsa,

1114: ara.amount_applied amount,
1115: apsa.invoice_currency_Code currency_code ,
1116: acr.receipt_number,
1117: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', acr.status)
1118: FROM ar_payment_schedules apsa,
1119: ar_cash_receipts acr,
1120: ar_receivable_applications ara,
1121: ar_cash_receipt_history acrh,
1122: iex_delinquencies del

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

1169: l_data_query := l_data_query || ' TRX_SUM.LAST_PAYMENT_AMOUNT, TRX_SUM.CURRENCY, TRX_SUM.LAST_PAYMENT_NUMBER, ';
1170: l_data_query := l_data_query || ' ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING(''CHECK_STATUS'', CR.STATUS) ';
1171: l_data_from := 'FROM ';
1172: l_data_from := l_data_from || ' AR_TRX_BAL_SUMMARY TRX_SUM, HZ_CUST_ACCOUNTS CA, AR_CASH_RECEIPTS CR, ';
1173: l_data_from := l_data_from || ' AR_RECEIVABLE_APPLICATIONS RA, AR_PAYMENT_SCHEDULES PS ';
1174: l_data_where := 'WHERE TRX_SUM.CUST_ACCOUNT_ID = :1 ';
1175: l_data_where := l_data_where || ' and TRX_SUM.SITE_USE_ID = :2 ';
1176: l_data_where := l_data_where || ' and TRX_SUM.ORG_ID = :3 ';
1177: l_data_where := l_data_where || ' and TRX_SUM.CURRENCY = :4 ';

Line 1241: -- ar_payment_schedules ps

1237: -- IF x_last_pmt_info_rec.cash_receipt_id IS NOT NULL THEN
1238: -- OPEN c_last_pmt2 FOR
1239: -- SELECT decode(ps.payment_schedule_id, -1, null, ps.due_date)
1240: -- FROM ar_receivable_applications ra,
1241: -- ar_payment_schedules ps
1242: -- WHERE ra.cash_receipt_id = l_receipt
1243: -- AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
1244: --
1245: -- FETCH c_last_pmt2 INTO x_last_pmt_info_rec.due_date;

Line 1275: -- ar_payment_schedules ps

1271: -- ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1272: -- FROM ar_trx_bal_summary trx_sum,
1273: -- hz_cust_accounts ca, ar_cash_receipts cr,
1274: -- ar_receivable_applications ra,
1275: -- ar_payment_schedules ps
1276: -- WHERE trx_sum.cust_account_id = ca.cust_account_id
1277: -- AND ca.party_id = p_object_id
1278: -- AND cr.receipt_number = trx_sum.last_payment_number
1279: -- AND ra.cash_receipt_id(+) = cr.cash_receipt_id

Line 1319: ar_payment_schedules ps

1315:
1316: OPEN c_last_pmt2 FOR
1317: SELECT decode(ps.payment_schedule_id, -1, null, ps.due_date)
1318: FROM ar_receivable_applications ra,
1319: ar_payment_schedules ps
1320: WHERE ra.cash_receipt_id = x_last_pmt_info_rec.cash_receipt_id
1321: AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
1322:
1323: FETCH c_last_pmt2 INTO x_last_pmt_info_rec.due_date;

Line 1339: -- ar_payment_schedules ps

1335: -- ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1336: -- FROM ar_trx_bal_summary trx_sum,
1337: -- ar_cash_receipts cr,
1338: -- ar_receivable_applications ra,
1339: -- ar_payment_schedules ps
1340: -- WHERE trx_sum.cust_account_id = p_object_id
1341: -- AND cr.receipt_number = trx_sum.last_payment_number
1342: -- AND ra.cash_receipt_id(+) = cr.cash_receipt_id
1343: -- AND ps.payment_schedule_id(+) = ra.applied_payment_schedule_id

Line 1382: ar_payment_schedules ps

1378:
1379: OPEN c_last_pmt2 FOR
1380: SELECT decode(ps.payment_schedule_id, -1, null, ps.due_date)
1381: FROM ar_receivable_applications ra,
1382: ar_payment_schedules ps
1383: WHERE ra.cash_receipt_id = x_last_pmt_info_rec.cash_receipt_id
1384: AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
1385:
1386: FETCH c_last_pmt2 INTO x_last_pmt_info_rec.due_date;

Line 1400: FROM ar_payment_schedules apsa,

1396: ara.amount_applied amount,
1397: apsa.invoice_currency_Code currency_code ,
1398: acr.receipt_number,
1399: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', acr.status)
1400: FROM ar_payment_schedules apsa,
1401: ar_cash_receipts acr,
1402: ar_receivable_applications ara,
1403: ar_cash_receipt_history acrh,
1404: iex_delinquencies del

Line 1469: ar_payment_schedules ps

1465:
1466: OPEN c_last_pmt2 FOR
1467: SELECT decode(ps.payment_schedule_id, -1, null, ps.due_date)
1468: FROM ar_receivable_applications ra,
1469: ar_payment_schedules ps
1470: WHERE ra.cash_receipt_id = x_last_pmt_info_rec.cash_receipt_id
1471: AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
1472:
1473: FETCH c_last_pmt2 INTO x_last_pmt_info_rec.due_date;

Line 1842: FROM ar_payment_schedules ps,

1838: -1, (PS.AMOUNT_DUE_ORIGINAL + NVL(PS.AMOUNT_ADJUSTED,0)) * NVL(PS.EXCHANGE_RATE, 1 ),
1839: 0) )
1840: )
1841: ), 0) dso
1842: FROM ar_payment_schedules ps,
1843: hz_cust_accounts ca,
1844: iex_delinquencies del,
1845: ar_system_parameters sp
1846: WHERE ca.party_id = p_party_id

Line 1855: FROM ar_payment_schedules ps,

1851: */
1852: CURSOR c_summ_info1 IS
1853: SELECT COUNT(DECODE(ps.class, 'INV', ps.payment_schedule_id, 'DM', ps.payment_schedule_id, 'CB', ps.payment_schedule_id, NULL)) cnt_inv,
1854: COUNT(DECODE(ps.class, 'INV', DECODE(del.status, 'DELINQUENT', del.delinquency_id, 'PREDELINQUENT', del.delinquency_id, NULL), NULL)) cnt_del
1855: FROM ar_payment_schedules ps,
1856: hz_cust_accounts ca,
1857: iex_delinquencies del
1858: WHERE ca.party_id = p_party_id
1859: AND ps.customer_id = ca.cust_account_id

Line 1901: FROM ar_payment_schedules ps,

1897: -1, (PS.AMOUNT_DUE_ORIGINAL + NVL(PS.AMOUNT_ADJUSTED,0)) * NVL(PS.EXCHANGE_RATE, 1 ),
1898: 0) )
1899: )
1900: ), 0) dso
1901: FROM ar_payment_schedules ps,
1902: hz_cust_accounts ca,
1903: iex_delinquencies del,
1904: ar_system_parameters sp
1905: WHERE ca.party_id = p_party_id

Line 2018: from ar_payment_schedules ps,

2014: select nvl(sum(cm.total_amount * -1),0)
2015: into l_amount_in_dispute
2016: from ra_cm_requests cm
2017: where cm.customer_trx_id in (select distinct customer_trx_id
2018: from ar_payment_schedules ps,
2019: hz_cust_accounts ca
2020: where ca.party_id = p_party_id
2021: and ps.customer_id = ca.cust_account_id
2022: and ps.status = 'OP')