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 613: HZ_CUST_SITE_USES_ALL hzp,

609: FROM JTF_TAE_1600_CUST_WINNERS WIN,
610: AR_COLLECTORS ACC,
611: JTF_RS_ROLE_RELATIONS jtrr,
612: JTF_RS_ROLES_B jtr,
613: HZ_CUST_SITE_USES_ALL hzp,
614: HZ_CUST_ACCT_SITES_ALL acct_site,
615: HZ_CUST_ACCOUNTS cust_acct
616: WHERE WIN.SOURCE_ID = -1600
617: AND WIN.worker_id = c_worker_id

Line 656: HZ_CUST_SITE_USES hzp,

652: acct_site.cust_account_id,
653: hzp.SITE_USE_ID
654: FROM JTF_TAE_1600_CUST_WINNERS WIN, AR_COLLECTORS ACC,
655: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr,
656: HZ_CUST_SITE_USES hzp,
657: HZ_CUST_ACCT_SITES acct_site
658: WHERE WIN.SOURCE_ID = -1600
659: AND WIN.worker_id = c_worker_id
660: AND WIN.resource_type in ('RS_EMPLOYEE', 'RS_GROUP')

Line 1366: HZ_CUST_SITE_USES hzp,

1362: SELECT win.trans_object_id, hzp.SITE_USE_ID,
1363: acct_site.cust_account_id
1364: FROM JTF_TAE_1600_CUST_WINNERS WIN, AR_COLLECTORS ACC,
1365: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr,
1366: HZ_CUST_SITE_USES hzp,
1367: HZ_CUST_ACCT_SITES acct_site
1368: WHERE WIN.SOURCE_ID = -1600
1369: AND WIN.worker_id = c_worker_id
1370: AND WIN.resource_type in ('RS_EMPLOYEE', 'RS_GROUP')