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_ACCT_SITES

Line 569: HZ_CUST_ACCT_SITES_ALL acct_site,

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
573: AND WIN.resource_type in ('RS_EMPLOYEE', 'RS_GROUP')

Line 612: HZ_CUST_ACCT_SITES acct_site

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')
616: --AND WIN.full_access_flag = 'Y' Bug5043777. Remove the Full_Access_Flag.

Line 1305: HZ_CUST_ACCT_SITES acct_site

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')
1309: -- AND WIN.full_access_flag = 'Y' Bug5043777. Remove the Full_Access_Flag. Fix By LKKUMAR.