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.OZF_CUST_FACTS_PVT dependencies on HZ_CUST_ACCOUNTS

Line 825: hz_cust_accounts h

821: SELECT NVL( DECODE(p_col, 'YEAR_QUOTA', SUM(f.current_year_target),
822: 'PERIOD_QUOTA', SUM(f.current_period_target),
823: 'QTR_QUOTA', SUM(f.current_qtr_target) ) ,0)
824: FROM ozf_cust_daily_facts f ,
825: hz_cust_accounts h
826: WHERE f.report_date = p_report_date
827: AND f.cust_account_id = h.cust_account_id
828: AND f.bill_to_site_use_id = NVL(p_bill_to_site_use_id, f.bill_to_site_use_id)
829: AND f.ship_to_site_use_id = NVL(p_site_use_id, f.ship_to_site_use_id)

Line 2319: hz_cust_accounts x,

2315: sysdate LAST_UPDATE_DATE,
2316: -1 LAST_UPDATED_BY,
2317: -1 LAST_UPDATE_LOGIN
2318: FROM ozf_cust_daily_facts c,
2319: hz_cust_accounts x,
2320: ozf_dashb_daily_kpi kpi,
2321: (SELECT DISTINCT a.owner
2322: FROM ozf_funds_all_b a
2323: WHERE a.fund_type = 'QUOTA'

Line 2420: hz_cust_accounts x,

2416: sysdate LAST_UPDATE_DATE,
2417: -1 LAST_UPDATED_BY,
2418: -1 LAST_UPDATE_LOGIN
2419: FROM ozf_cust_daily_facts c,
2420: hz_cust_accounts x,
2421: ozf_dashb_daily_kpi kpi,
2422: (SELECT DISTINCT a.owner
2423: FROM ozf_funds_all_b a
2424: WHERE a.fund_type = 'QUOTA'

Line 2521: hz_cust_accounts x,

2517: sysdate LAST_UPDATE_DATE,
2518: -1 LAST_UPDATED_BY,
2519: -1 LAST_UPDATE_LOGIN
2520: FROM ozf_cust_daily_facts c,
2521: hz_cust_accounts x,
2522: ozf_dashb_daily_kpi kpi,
2523: (SELECT DISTINCT a.owner
2524: FROM ozf_funds_all_b a
2525: WHERE a.fund_type = 'QUOTA'