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 186: JTF_RS_ROLES_B jtr

182: ACC.COLLECTOR_ID
183: FROM JTF_TAE_1600_CUST_WINNERS WIN,
184: AR_COLLECTORS ACC,
185: JTF_RS_ROLE_RELATIONS jtrr,
186: JTF_RS_ROLES_B jtr
187: WHERE WIN.SOURCE_ID = -1600
188: AND WIN.worker_id = c_worker_id
189: AND WIN.resource_type in ('RS_EMPLOYEE', 'RS_GROUP')
190: -- AND WIN.full_access_flag = 'Y' Bug5043777. Remove the Full_Access_Flag. Fix By LKKUMAR.

Line 401: JTF_RS_ROLES_B jtr

397: ACC.COLLECTOR_ID
398: FROM JTF_TAE_1600_CUST_WINNERS WIN,
399: AR_COLLECTORS ACC,
400: JTF_RS_ROLE_RELATIONS jtrr,
401: JTF_RS_ROLES_B jtr
402: WHERE WIN.SOURCE_ID = -1600
403: AND WIN.worker_id = c_worker_id
404: AND WIN.resource_type in ('RS_EMPLOYEE', 'RS_GROUP')
405: --AND WIN.full_access_flag = 'Y' Bug5043777. Remove the Full_Access_Flag

Line 612: JTF_RS_ROLES_B jtr,

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

Line 655: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr,

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

Line 900: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr

896: nvl(WIN.org_id,-777) org_id,
897: win.resource_type,
898: WIN.PERSON_ID
899: FROM JTF_TAE_1600_CUST_WINNERS WIN,
900: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr
901: WHERE WIN.SOURCE_ID = -1600
902: AND WIN.worker_id = c_worker_id
903: AND WIN.RESOURCE_TYPE IN ('RS_EMPLOYEE', 'RS_GROUP')
904: AND jtrr.role_resource_id = WIN.RESOURCE_ID

Line 1142: JTF_RS_ROLES_B jtr

1138: SELECT WIN.TRANS_OBJECT_id
1139: FROM JTF_TAE_1600_CUST_WINNERS WIN,
1140: AR_COLLECTORS ACC,
1141: JTF_RS_ROLE_RELATIONS jtrr,
1142: JTF_RS_ROLES_B jtr
1143: WHERE WIN.SOURCE_ID = -1600
1144: AND WIN.worker_id = c_worker_id
1145: AND WIN.resource_type in ('RS_EMPLOYEE', 'RS_GROUP')
1146: -- AND WIN.full_access_flag = 'Y' Bug5043777. Remove the Full_Access_Flag. Fix By LKKUMAR.

Line 1365: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr,

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