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.AS_GAR_ACCOUNTS_PUB dependencies on JTF_TAE_1001_ACCOUNT_WINNERS

Line 62: FROM JTF_TAE_1001_ACCOUNT_WINNERS

58: l_proc VARCHAR2(30):= 'GAR_WRAPPER::';
59: l_count NUMBER;
60: CURSOR get_count(c_worker_id number) IS
61: SELECT COUNT(*)
62: FROM JTF_TAE_1001_ACCOUNT_WINNERS
63: WHERE worker_id = c_worker_id
64: AND resource_type IN ('RS_PARTNER','RS_PARTY')
65: AND ROWNUM < 2;
66: BEGIN

Line 313: FROM JTF_TAE_1001_ACCOUNT_WINNERS

309:
310: CURSOR c_get_res_type_count(c_resource_type VARCHAR2, c_request_id NUMBER, c_worker_id NUMBER)
311: IS
312: SELECT count(*)
313: FROM JTF_TAE_1001_ACCOUNT_WINNERS
314: WHERE request_id = c_request_id
315: AND resource_type = c_resource_type
316: AND worker_id = c_worker_id
317: AND ROWNUM < 2;

Line 357: INSERT INTO JTF_TAE_1001_ACCOUNT_WINNERS

353: /** Note
354: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
355: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE
356: **/
357: INSERT INTO JTF_TAE_1001_ACCOUNT_WINNERS
358: (trans_object_id,
359: trans_detail_object_id,
360: terr_id,
361: resource_id,

Line 414: JTF_TAE_1001_ACCOUNT_WINNERS T,

410: J.person_id,
411: T.org_id,
412: T.worker_id
413: FROM
414: JTF_TAE_1001_ACCOUNT_WINNERS T,
415: (
416: SELECT TM.team_resource_id resource_id,
417: TM.person_id person_id2,
418: MIN(G.group_id)group_id,

Line 529: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_ACCOUNT_WINNERS rt1

525: WHERE j.team_id = t.resource_id
526: AND t.request_id = l_request_id
527: AND t.worker_id = l_worker_id
528: AND t.resource_type = 'RS_TEAM'
529: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_ACCOUNT_WINNERS rt1
530: WHERE rt1.resource_id = j.resource_id
531: AND NVL(rt1.group_id,-1) = NVL(j.group_id,-1)
532: AND rt1.request_id = t.request_id
533: AND rt1.worker_id = t.worker_id

Line 580: FROM JTF_TAE_1001_ACCOUNT_WINNERS

576:
577: CURSOR c_get_res_type_count(c_resource_type VARCHAR2, c_request_id NUMBER, c_worker_id NUMBER)
578: IS
579: SELECT count(*)
580: FROM JTF_TAE_1001_ACCOUNT_WINNERS
581: WHERE request_id = c_request_id
582: AND resource_type = c_resource_type
583: AND worker_id = c_worker_id
584: AND ROWNUM < 2;

Line 624: INSERT INTO JTF_TAE_1001_ACCOUNT_WINNERS

620: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
621: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE
622: **/
623:
624: INSERT INTO JTF_TAE_1001_ACCOUNT_WINNERS
625: (trans_object_id,
626: trans_detail_object_id,
627: terr_id,
628: resource_id,

Line 682: JTF_TAE_1001_ACCOUNT_WINNERS t,

678: J.person_id,
679: T.org_id,
680: T.worker_id
681: FROM
682: JTF_TAE_1001_ACCOUNT_WINNERS t,
683: (
684: SELECT MIN(m.resource_id) resource_id,
685: res.CATEGORY resource_category,
686: m.group_id group_id, MIN(res.source_id) person_id

Line 712: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_ACCOUNT_WINNERS rt1

708: WHERE j.group_id = t.resource_id
709: AND t.request_id = l_request_id
710: AND t.worker_id = l_worker_id
711: AND t.resource_type = 'RS_GROUP'
712: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_ACCOUNT_WINNERS rt1
713: WHERE rt1.resource_id = j.resource_id
714: AND NVL(rt1.group_id,-1) = NVL(j.group_id,-1)
715: AND rt1.request_id = t.request_id
716: AND rt1.worker_id = t.worker_id

Line 783: JTF_TAE_1001_ACCOUNT_WINNERS WIN

779: A.salesforce_id,
780: A.sales_group_id,
781: NVL(WIN.full_access_flag,'N')
782: FROM AS_ACCESSES_ALL_ALL A,
783: JTF_TAE_1001_ACCOUNT_WINNERS WIN
784: WHERE A.lead_id is NULL
785: AND A.delete_flag is NULL
786: AND A.sales_lead_id is NULL
787: AND NVL(A.team_leader_flag,'N') <> NVL(WIN.full_access_flag,'N')

Line 975: FROM JTF_TAE_1001_ACCOUNT_WINNERS W

971: MAX(W.full_access_flag) faf,
972: W.resource_type,
973: org_id,
974: NULL
975: FROM JTF_TAE_1001_ACCOUNT_WINNERS W
976: WHERE W.source_id = -1001
977: AND W.worker_id = c_worker_id
978: AND W.resource_type ='RS_EMPLOYEE'
979: AND W.group_id is NOT NULL

Line 996: FROM JTF_TAE_1001_ACCOUNT_WINNERS W,

992: MAX(W.FULL_ACCESS_FLAG) FAF,
993: W.RESOURCE_TYPE,
994: ORG_ID,
995: ATR.RESOURCE_TYPE SALESFORCE_ROLE_CODE
996: FROM JTF_TAE_1001_ACCOUNT_WINNERS W,
997: AS_TERR_RESOURCES_TMP ATR
998: WHERE W.SOURCE_ID = -1001
999: AND W.worker_id = c_worker_id
1000: AND W.RESOURCE_TYPE = 'RS_EMPLOYEE'

Line 1316: FROM JTF_TAE_1001_ACCOUNT_WINNERS W

1312: SELECT w.terr_id
1313: ,w.trans_object_id
1314: ,w.resource_id
1315: ,w.group_id
1316: FROM JTF_TAE_1001_ACCOUNT_WINNERS W
1317: WHERE W.source_id = -1001
1318: AND W.worker_id = c_worker_id
1319: AND W.resource_type = 'RS_EMPLOYEE'
1320: AND W.group_id IS NOT NULL --- Added to work around the JTY functionality which allows group_id to be NULL during setup of resources.

Line 1568: JTF_TAE_1001_ACCOUNT_WINNERS WIN,

1564: A.partner_customer_id,
1565: A.partner_cont_party_id,
1566: NVL(WIN.full_access_flag,'N')
1567: FROM AS_ACCESSES_ALL_ALL A,
1568: JTF_TAE_1001_ACCOUNT_WINNERS WIN,
1569: JTF_RS_ROLE_RELATIONS REL,
1570: JTF_RS_ROLES_B ROL
1571: WHERE WIN.source_id = -1001
1572: AND A.delete_flag is NULL

Line 1787: FROM JTF_TAE_1001_ACCOUNT_WINNERS W,

1783: MAX(W.full_access_flag) faf,
1784: W.org_id,
1785: W.resource_type,
1786: RES.source_id
1787: FROM JTF_TAE_1001_ACCOUNT_WINNERS W,
1788: JTF_RS_RESOURCE_EXTNS RES,
1789: JTF_RS_ROLE_RELATIONS REL,
1790: JTF_RS_ROLES_B ROL
1791: WHERE W.source_id = -1001

Line 2055: FROM JTF_TAE_1001_ACCOUNT_WINNERS W,JTF_RS_ROLE_RELATIONS REL,JTF_RS_ROLES_B ROL

2051: SELECT w.terr_id
2052: ,w.trans_object_id
2053: ,w.resource_id
2054: ,w.group_id
2055: FROM JTF_TAE_1001_ACCOUNT_WINNERS W,JTF_RS_ROLE_RELATIONS REL,JTF_RS_ROLES_B ROL
2056: WHERE W.source_id = -1001
2057: AND W.worker_id = c_worker_id
2058: AND W.resource_type in ('RS_PARTNER','RS_PARTY')
2059: AND W.resource_id=REL.role_resource_id

Line 2370: FROM JTF_TAE_1001_ACCOUNT_WINNERS W

2366: AND NVL(ACC.freeze_flag,'N') = 'N'
2367: AND ACC.lead_id IS NULL
2368: AND ACC.sales_lead_id IS NULL
2369: AND NOT EXISTS (SELECT 'X'
2370: FROM JTF_TAE_1001_ACCOUNT_WINNERS W
2371: WHERE W.trans_object_id = ACC.customer_id
2372: AND W.worker_id = l_worker_id
2373: AND W.resource_id = ACC.salesforce_id
2374: AND NVL(W.group_id,-777)=NVL(ACC.sales_group_id,-777))

Line 2393: FROM JTF_TAE_1001_ACCOUNT_WINNERS W

2389: AND ACC.lead_id IS NULL
2390: AND ACC.delete_flag is NULL
2391: AND ACC.sales_lead_id IS NULL
2392: AND NOT EXISTS (SELECT 'X'
2393: FROM JTF_TAE_1001_ACCOUNT_WINNERS W
2394: WHERE W.trans_object_id = ACC.customer_id
2395: AND W.worker_id = l_worker_id
2396: AND W.resource_id = ACC.salesforce_id
2397: AND NVL(W.group_id,-777)= NVL(ACC.sales_group_id,-777))

Line 2425: FROM JTF_TAE_1001_ACCOUNT_WINNERS W

2421: AND NVL(ACC.freeze_flag,'N') = 'N'
2422: AND ACC.lead_id IS NULL
2423: AND ACC.sales_lead_id IS NULL
2424: AND NOT EXISTS (SELECT 'X'
2425: FROM JTF_TAE_1001_ACCOUNT_WINNERS W
2426: WHERE W.trans_object_id = ACC.customer_id
2427: AND W.worker_id = l_worker_id
2428: AND W.resource_id = ACC.salesforce_id
2429: AND NVL(W.group_id,-777)= NVL(ACC.sales_group_id,-777));

Line 2442: FROM JTF_TAE_1001_ACCOUNT_WINNERS W

2438: AND ACC.delete_flag is NULL
2439: AND ACC.lead_id IS NULL
2440: AND ACC.sales_lead_id IS NULL
2441: AND NOT EXISTS (SELECT 'X'
2442: FROM JTF_TAE_1001_ACCOUNT_WINNERS W
2443: WHERE W.trans_object_id = ACC.customer_id
2444: AND W.worker_id = l_worker_id
2445: AND W.resource_id = ACC.salesforce_id
2446: AND NVL(W.group_id,-777)= NVL(ACC.sales_group_id,-777));