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 HZ_CUST_ACCOUNTS

Line 59: -- hz_cust_accounts ca,

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
63: -- AND ps.status = 'OP'

Line 69: hz_cust_accounts ca

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'
73: AND ps.class IN ('INV', 'DM', 'CB');

Line 78: hz_cust_accounts ca,

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
82: AND ps.status = 'OP'

Line 124: FROM hz_cust_accounts

120:
121: -- Customer Since added by jypark 09/26/2002
122: CURSOR c_customer_since IS
123: SELECT MIN(account_established_date)
124: FROM hz_cust_accounts
125: WHERE account_established_date IS NOT NULL
126: AND party_id = p_party_id;
127:
128: l_sql_select VARCHAR2(1000);

Line 460: -- FROM IEX_BPD_CNSLD_INV_REMAINING_V cnsld, hz_cust_accounts ca

456: --
457: -- -- Collectable OKL Invocies
458: -- CURSOR c_okl_inv IS
459: -- SELECT count(CNSLD.CONSOLIDATED_INVOICE_ID)
460: -- FROM IEX_BPD_CNSLD_INV_REMAINING_V cnsld, hz_cust_accounts ca
461: -- WHERE ca.party_id = p_party_id
462: -- AND cnsld.customer_id = ca.cust_account_id
463: -- AND cnsld.amount > 0;
464: --

Line 595: hz_cust_accounts ca,

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,
599: -- End fix bug #5261855-jypark-06/16/2006-change to based table for performance

Line 621: hz_cust_accounts ca

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')
625: and cm.status='PENDING_APPROVAL';

Line 1088: l_pk_from := 'from AR_TRX_BAL_SUMMARY TRX_SUM, hz_cust_accounts ca ';

1084: --Begin - Andre Araujo - 03/13/06 - Bug#5024219 - Improving performance
1085: --First we will find the PK for the record with the info we want
1086: BEGIN
1087: l_pk_query := 'select ca.party_id, TRX_SUM.CUST_ACCOUNT_ID, TRX_SUM.SITE_USE_ID, TRX_SUM.ORG_ID, TRX_SUM.CURRENCY, max(TRX_SUM.LAST_PAYMENT_DATE) pay_date ';
1088: l_pk_from := 'from AR_TRX_BAL_SUMMARY TRX_SUM, hz_cust_accounts ca ';
1089: l_pk_where := 'where ca.CUST_ACCOUNT_ID = TRX_SUM.CUST_ACCOUNT_ID ';
1090: l_pk_group := 'group by ca.party_id, TRX_SUM.CUST_ACCOUNT_ID, TRX_SUM.SITE_USE_ID, TRX_SUM.ORG_ID, TRX_SUM.CURRENCY ';
1091:
1092: -- Begin - Bug#5358461 - Andre Araujo - 07/07/06 - This query is not MOAC ready

Line 1172: l_data_from := l_data_from || ' AR_TRX_BAL_SUMMARY TRX_SUM, HZ_CUST_ACCOUNTS CA, AR_CASH_RECEIPTS CR, ';

1168: l_data_query := l_data_query || ' DECODE(PS.PAYMENT_SCHEDULE_ID, -1, NULL, PS.DUE_DATE), ';
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 ';

Line 1201: l_data_from := l_data_from || ' AR_TRX_BAL_SUMMARY TRX_SUM, HZ_CUST_ACCOUNTS CA ';

1197: l_data_query := l_data_query || ' null, ';
1198: l_data_query := l_data_query || ' TRX_SUM.LAST_PAYMENT_AMOUNT, TRX_SUM.CURRENCY, TRX_SUM.LAST_PAYMENT_NUMBER, ';
1199: l_data_query := l_data_query || ' null ';
1200: l_data_from := 'FROM ';
1201: l_data_from := l_data_from || ' AR_TRX_BAL_SUMMARY TRX_SUM, HZ_CUST_ACCOUNTS CA ';
1202: l_data_where := 'WHERE TRX_SUM.CUST_ACCOUNT_ID = :1 ';
1203: l_data_where := l_data_where || ' and TRX_SUM.SITE_USE_ID = :2 ';
1204: l_data_where := l_data_where || ' and TRX_SUM.ORG_ID = :3 ';
1205: l_data_where := l_data_where || ' and TRX_SUM.CURRENCY = :4 ';

Line 1273: -- hz_cust_accounts ca, ar_cash_receipts cr,

1269: -- trx_sum.currency,
1270: -- trx_sum.last_payment_number,
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

Line 1300: hz_cust_accounts ca, ar_cash_receipts cr

1296: trx_sum.currency,
1297: trx_sum.last_payment_number,
1298: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1299: FROM ar_trx_bal_summary trx_sum,
1300: hz_cust_accounts ca, ar_cash_receipts cr
1301: WHERE trx_sum.cust_account_id = ca.cust_account_id
1302: AND ca.party_id = p_object_id
1303: AND cr.receipt_number = trx_sum.last_payment_number
1304: ORDER BY 1 DESC, 2 DESC;

Line 1843: hz_cust_accounts ca,

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
1847: AND ps.customer_id = ca.cust_account_id

Line 1856: hz_cust_accounts ca,

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
1860: AND ps.status = 'OP'

Line 1902: hz_cust_accounts ca,

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
1906: AND ps.customer_id = ca.cust_account_id

Line 1948: FROM hz_cust_accounts

1944:
1945: -- Customer Since added by jypark 09/26/2002
1946: CURSOR c_customer_since IS
1947: SELECT MIN(account_established_date)
1948: FROM hz_cust_accounts
1949: WHERE account_established_date IS NOT NULL
1950: AND party_id = p_party_id;
1951:
1952: l_sql_select VARCHAR2(1000);

Line 2019: hz_cust_accounts ca

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')
2023: and cm.status='PENDING_APPROVAL';