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_TRX_BAL_SUMMARY

Line 1071: l_amount AR_TRX_BAL_SUMMARY.LAST_PAYMENT_AMOUNT%TYPE;

1067: l_pay_date date;
1068:
1069: l_receipt NUMBER;
1070: l_PSDueDate date;
1071: l_amount AR_TRX_BAL_SUMMARY.LAST_PAYMENT_AMOUNT%TYPE;
1072: l_currency AR_TRX_BAL_SUMMARY.CURRENCY%TYPE;
1073: l_paynumber AR_TRX_BAL_SUMMARY.LAST_PAYMENT_NUMBER%TYPE;
1074: l_status varchar2(200);
1075: l_partyid number;

Line 1072: l_currency AR_TRX_BAL_SUMMARY.CURRENCY%TYPE;

1068:
1069: l_receipt NUMBER;
1070: l_PSDueDate date;
1071: l_amount AR_TRX_BAL_SUMMARY.LAST_PAYMENT_AMOUNT%TYPE;
1072: l_currency AR_TRX_BAL_SUMMARY.CURRENCY%TYPE;
1073: l_paynumber AR_TRX_BAL_SUMMARY.LAST_PAYMENT_NUMBER%TYPE;
1074: l_status varchar2(200);
1075: l_partyid number;
1076: --End - Andre Araujo - 03/13/06 - Bug#5024219 - Improving performance

Line 1073: l_paynumber AR_TRX_BAL_SUMMARY.LAST_PAYMENT_NUMBER%TYPE;

1069: l_receipt NUMBER;
1070: l_PSDueDate date;
1071: l_amount AR_TRX_BAL_SUMMARY.LAST_PAYMENT_AMOUNT%TYPE;
1072: l_currency AR_TRX_BAL_SUMMARY.CURRENCY%TYPE;
1073: l_paynumber AR_TRX_BAL_SUMMARY.LAST_PAYMENT_NUMBER%TYPE;
1074: l_status varchar2(200);
1075: l_partyid number;
1076: --End - Andre Araujo - 03/13/06 - Bug#5024219 - Improving performance
1077: --Begin-fix bug #5407151-JYPARK-08012006-hide last payment due on depending on profile IEX_SHOW_LAST_PMT_DUE

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 1099: -- Begin Fix bug #5417273-JYPARK-08/01/2006-Exclude if ar_trx_bal_summary.last_payment_date is null

1095: l_pk_group := l_pk_group || ' order by pay_date desc '; -- To do this pay_date was added to the end of l_pk_query
1096: -- End - Bug#5358461 - Andre Araujo - 07/07/06 - This query is not MOAC ready
1097:
1098:
1099: -- Begin Fix bug #5417273-JYPARK-08/01/2006-Exclude if ar_trx_bal_summary.last_payment_date is null
1100: l_pk_where := l_pk_where || ' AND trx_sum.last_payment_date IS NOT NULL ';
1101: -- End Fix bug #5417273-JYPARK-08/01/2006-Exclude if ar_trx_bal_summary.last_payment_date is null
1102:
1103: IF p_object_type = 'CUSTOMER' AND p_object_id IS NOT NULL THEN

Line 1101: -- End Fix bug #5417273-JYPARK-08/01/2006-Exclude if ar_trx_bal_summary.last_payment_date is null

1097:
1098:
1099: -- Begin Fix bug #5417273-JYPARK-08/01/2006-Exclude if ar_trx_bal_summary.last_payment_date is null
1100: l_pk_where := l_pk_where || ' AND trx_sum.last_payment_date IS NOT NULL ';
1101: -- End Fix bug #5417273-JYPARK-08/01/2006-Exclude if ar_trx_bal_summary.last_payment_date is null
1102:
1103: IF p_object_type = 'CUSTOMER' AND p_object_id IS NOT NULL THEN
1104: l_pk_where := l_pk_where || 'and ca.party_id = :1 ';
1105: ELSIF p_object_type = 'ACCOUNT' AND p_object_id IS NOT NULL THEN

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 1272: -- FROM ar_trx_bal_summary trx_sum,

1268: -- trx_sum.last_payment_amount,
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

Line 1299: FROM ar_trx_bal_summary trx_sum,

1295: trx_sum.last_payment_amount,
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

Line 1336: -- FROM ar_trx_bal_summary trx_sum,

1332: -- trx_sum.last_payment_amount,
1333: -- trx_sum.currency,
1334: -- trx_sum.last_payment_number,
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

Line 1362: FROM ar_trx_bal_summary trx_sum,

1358: trx_sum.last_payment_amount,
1359: trx_sum.currency,
1360: trx_sum.last_payment_number,
1361: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1362: FROM ar_trx_bal_summary trx_sum,
1363: ar_cash_receipts cr
1364: WHERE trx_sum.cust_account_id = p_object_id
1365: AND cr.receipt_number = trx_sum.last_payment_number
1366: ORDER BY 1 DESC, 2 DESC;

Line 1450: FROM ar_trx_bal_summary trx_sum,

1446: trx_sum.last_payment_amount,
1447: trx_sum.currency,
1448: trx_sum.last_payment_number,
1449: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1450: FROM ar_trx_bal_summary trx_sum,
1451: ar_cash_receipts cr
1452: WHERE trx_sum.site_use_id = p_object_id
1453: AND cr.receipt_number = trx_sum.last_payment_number
1454: ORDER BY 1 DESC, 2 DESC;