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.HZ_CREDIT_USAGES_PKG dependencies on HZ_CUSTOMER_PROFILES

Line 304: FROM hz_customer_profiles cp

300: , cpa.trx_credit_limit * ((100 + NVL(cp.tolerance,0))/100)
301: trx_limit
302: , cp.credit_checking
303: , cu.credit_usage_rule_set_id
304: FROM hz_customer_profiles cp
305: , hz_cust_profile_amts cpa
306: , hz_credit_usages cu
307: , hz_credit_usage_rules cur
308: WHERE cp.cust_account_id = p_entity_id

Line 333: FROM hz_customer_profiles cp

329: , cpa.trx_credit_limit * ((100 + NVL(cp.tolerance,0))/100)
330: trx_limit
331: , cp.credit_checking
332: , cu.credit_usage_rule_set_id
333: FROM hz_customer_profiles cp
334: , hz_cust_profile_amts cpa
335: , hz_credit_usages cu
336: , hz_credit_usage_rules cur
337: WHERE cp.cust_account_id = p_entity_id

Line 369: FROM hz_customer_profiles cp

365: , cpa.trx_credit_limit * ((100 + NVL(cp.tolerance,0))/100)
366: trx_limit
367: , cp.credit_checking
368: , cu.credit_usage_rule_set_id
369: FROM hz_customer_profiles cp
370: , hz_cust_profile_amts cpa
371: , hz_credit_usages cu
372: , hz_credit_usage_rules cur
373: WHERE cp.site_use_id = p_entity_id

Line 396: FROM hz_customer_profiles cp

392: , cpa.trx_credit_limit * ((100 + NVL(cp.tolerance,0))/100)
393: trx_limit
394: , cp.credit_checking
395: , cu.credit_usage_rule_set_id
396: FROM hz_customer_profiles cp
397: , hz_cust_profile_amts cpa
398: , hz_credit_usages cu
399: , hz_credit_usage_rules cur
400: WHERE cp.site_use_id = p_entity_id

Line 429: FROM hz_customer_profiles cp

425: , cpa.trx_credit_limit * ((100 + NVL(cp.tolerance,0))/100)
426: trx_limit
427: , cp.credit_checking
428: , cu.credit_usage_rule_set_id
429: FROM hz_customer_profiles cp
430: , hz_cust_profile_amts cpa
431: , hz_credit_usages cu
432: , hz_credit_usage_rules cur
433: WHERE cp.cust_account_id = -1

Line 459: FROM hz_customer_profiles cp

455: , cpa.trx_credit_limit * ((100 + NVL(cp.tolerance,0))/100)
456: trx_limit
457: , cp.credit_checking
458: , cu.credit_usage_rule_set_id
459: FROM hz_customer_profiles cp
460: , hz_cust_profile_amts cpa
461: , hz_credit_usages cu
462: , hz_credit_usage_rules cur
463: WHERE cp.cust_account_id = -1