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_PROCESS_ACCOUNT_WINNERS dependencies on HZ_CUST_SITE_USES

Line 568: HZ_CUST_SITE_USES_ALL hzp,

564: FROM JTF_TAE_1600_CUST_WINNERS WIN,
565: AR_COLLECTORS ACC,
566: JTF_RS_ROLE_RELATIONS jtrr,
567: JTF_RS_ROLES_B jtr,
568: HZ_CUST_SITE_USES_ALL hzp,
569: HZ_CUST_ACCT_SITES_ALL acct_site,
570: HZ_CUST_ACCOUNTS cust_acct
571: WHERE WIN.SOURCE_ID = -1600
572: AND WIN.worker_id = c_worker_id

Line 611: HZ_CUST_SITE_USES hzp,

607: acct_site.cust_account_id,
608: hzp.SITE_USE_ID
609: FROM JTF_TAE_1600_CUST_WINNERS WIN, AR_COLLECTORS ACC,
610: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr,
611: HZ_CUST_SITE_USES hzp,
612: HZ_CUST_ACCT_SITES acct_site
613: WHERE WIN.SOURCE_ID = -1600
614: AND WIN.worker_id = c_worker_id
615: AND WIN.resource_type in ('RS_EMPLOYEE', 'RS_GROUP')

Line 1304: HZ_CUST_SITE_USES hzp,

1300: SELECT win.trans_object_id, hzp.SITE_USE_ID,
1301: acct_site.cust_account_id
1302: FROM JTF_TAE_1600_CUST_WINNERS WIN, AR_COLLECTORS ACC,
1303: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr,
1304: HZ_CUST_SITE_USES hzp,
1305: HZ_CUST_ACCT_SITES acct_site
1306: WHERE WIN.SOURCE_ID = -1600
1307: AND WIN.worker_id = c_worker_id
1308: AND WIN.resource_type in ('RS_EMPLOYEE', 'RS_GROUP')