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 JTF_RS_ROLES_B

Line 174: JTF_RS_ROLES_B jtr

170: ACC.COLLECTOR_ID
171: FROM JTF_TAE_1600_CUST_WINNERS WIN,
172: AR_COLLECTORS ACC,
173: JTF_RS_ROLE_RELATIONS jtrr,
174: JTF_RS_ROLES_B jtr
175: WHERE WIN.SOURCE_ID = -1600
176: AND WIN.worker_id = c_worker_id
177: AND WIN.resource_type in ('RS_EMPLOYEE', 'RS_GROUP')
178: -- AND WIN.full_access_flag = 'Y' Bug5043777. Remove the Full_Access_Flag. Fix By LKKUMAR.

Line 368: JTF_RS_ROLES_B jtr

364: ACC.COLLECTOR_ID
365: FROM JTF_TAE_1600_CUST_WINNERS WIN,
366: AR_COLLECTORS ACC,
367: JTF_RS_ROLE_RELATIONS jtrr,
368: JTF_RS_ROLES_B jtr
369: WHERE WIN.SOURCE_ID = -1600
370: AND WIN.worker_id = c_worker_id
371: AND WIN.resource_type in ('RS_EMPLOYEE', 'RS_GROUP')
372: --AND WIN.full_access_flag = 'Y' Bug5043777. Remove the Full_Access_Flag

Line 567: JTF_RS_ROLES_B jtr,

563: hzp.SITE_USE_ID
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

Line 610: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr,

606: ACC.COLLECTOR_ID,
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

Line 842: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr

838: nvl(WIN.org_id,-777) org_id,
839: win.resource_type,
840: WIN.PERSON_ID
841: FROM JTF_TAE_1600_CUST_WINNERS WIN,
842: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr
843: WHERE WIN.SOURCE_ID = -1600
844: AND WIN.worker_id = c_worker_id
845: AND WIN.RESOURCE_TYPE IN ('RS_EMPLOYEE', 'RS_GROUP')
846: AND jtrr.role_resource_id = WIN.RESOURCE_ID

Line 1084: JTF_RS_ROLES_B jtr

1080: SELECT WIN.TRANS_OBJECT_id
1081: FROM JTF_TAE_1600_CUST_WINNERS WIN,
1082: AR_COLLECTORS ACC,
1083: JTF_RS_ROLE_RELATIONS jtrr,
1084: JTF_RS_ROLES_B jtr
1085: WHERE WIN.SOURCE_ID = -1600
1086: AND WIN.worker_id = c_worker_id
1087: AND WIN.resource_type in ('RS_EMPLOYEE', 'RS_GROUP')
1088: -- AND WIN.full_access_flag = 'Y' Bug5043777. Remove the Full_Access_Flag. Fix By LKKUMAR.

Line 1303: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr,

1299: CURSOR c_MissedProfiles(c_worker_id number) IS
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