APPS.IEX_COLL_IND dependencies on AR_TRX_SUMMARY

Line 1437: FROM ar_trx_summary trx_summ,

1433: IF p_party_id IS NOT NULL THEN
1434: SELECT MAX(gl_currency_api.convert_amount_sql(trx_summ.currency, g_curr_rec.base_currency,
1435: sysdate, cm_opt.default_exchange_rate_type, trx_summ.op_bal_high_watermark))
1436: INTO l_high_credit_ytd
1437: FROM ar_trx_summary trx_summ,
1438: ar_cmgt_setup_options cm_opt,
1439: hz_cust_accounts ca
1440: WHERE NVL(trx_summ.org_id,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ', NULL,
1441: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99))

Line 1449: FROM ar_trx_summary trx_summ,

1445: ELSIF p_cust_account_id IS NOT NULL THEN
1446: SELECT MAX(gl_currency_api.convert_amount_sql(trx_summ.currency, g_curr_rec.base_currency,
1447: sysdate, cm_opt.default_exchange_rate_type, trx_summ.op_bal_high_watermark))
1448: INTO l_high_credit_ytd
1449: FROM ar_trx_summary trx_summ,
1450: ar_cmgt_setup_options cm_opt
1451: WHERE NVL(trx_summ.org_id,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ', NULL,
1452: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99))
1453: = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

Line 1459: FROM ar_trx_summary trx_summ,

1455: ELSIF p_customer_site_use_id IS NOT NULL THEN
1456: SELECT MAX(gl_currency_api.convert_amount_sql(trx_summ.currency, g_curr_rec.base_currency,
1457: sysdate, cm_opt.default_exchange_rate_type, trx_summ.op_bal_high_watermark))
1458: INTO l_high_credit_ytd
1459: FROM ar_trx_summary trx_summ,
1460: ar_cmgt_setup_options cm_opt
1461: WHERE NVL(trx_summ.org_id,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ', NULL,
1462: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99))
1463: = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)