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_OPPTYS_PUB dependencies on JTF_TAE_1001_OPPOR_WINNERS

Line 274: FROM JTF_TAE_1001_OPPOR_WINNERS

270:
271: CURSOR c_get_res_type_count(c_resource_type VARCHAR2, c_request_id NUMBER, c_worker_id NUMBER)
272: IS
273: SELECT count(*)
274: FROM JTF_TAE_1001_OPPOR_WINNERS
275: WHERE request_id = c_request_id
276: AND resource_type = c_resource_type
277: AND worker_id = c_worker_id
278: AND ROWNUM < 2;

Line 318: INSERT INTO JTF_TAE_1001_OPPOR_WINNERS

314: /** Note
315: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
316: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE
317: **/
318: INSERT INTO JTF_TAE_1001_OPPOR_WINNERS
319: (trans_object_id,
320: trans_detail_object_id,
321: terr_id,
322: resource_id,

Line 375: JTF_TAE_1001_OPPOR_WINNERS T,

371: J.person_id,
372: T.org_id,
373: T.worker_id
374: FROM
375: JTF_TAE_1001_OPPOR_WINNERS T,
376: (
377: SELECT TM.team_resource_id resource_id,
378: TM.person_id person_id2,
379: MIN(G.group_id)group_id,

Line 489: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_OPPOR_WINNERS rt1

485: WHERE j.team_id = t.resource_id
486: AND t.request_id = l_request_id
487: AND t.worker_id = l_worker_id
488: AND t.resource_type = 'RS_TEAM'
489: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_OPPOR_WINNERS rt1
490: WHERE rt1.resource_id = j.resource_id
491: AND NVL(rt1.group_id,-1) = NVL(j.group_id,-1)
492: AND rt1.request_id = t.request_id
493: AND rt1.worker_id = t.worker_id

Line 540: FROM JTF_TAE_1001_OPPOR_WINNERS

536:
537: CURSOR c_get_res_type_count(c_resource_type VARCHAR2, c_request_id NUMBER, c_worker_id NUMBER)
538: IS
539: SELECT count(*)
540: FROM JTF_TAE_1001_OPPOR_WINNERS
541: WHERE request_id = c_request_id
542: AND resource_type = c_resource_type
543: AND worker_id = c_worker_id
544: AND ROWNUM < 2;

Line 583: INSERT INTO JTF_TAE_1001_OPPOR_WINNERS

579: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
580: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE
581: **/
582:
583: INSERT INTO JTF_TAE_1001_OPPOR_WINNERS
584: (trans_object_id,
585: trans_detail_object_id,
586: terr_id,
587: resource_id,

Line 641: JTF_TAE_1001_OPPOR_WINNERS t,

637: J.person_id,
638: T.org_id,
639: T.worker_id
640: FROM
641: JTF_TAE_1001_OPPOR_WINNERS t,
642: (
643: SELECT min(m.resource_id) resource_id,
644: res.category resource_category,
645: m.group_id group_id, min(res.source_id) person_id

Line 671: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_OPPOR_WINNERS rt1

667: WHERE j.group_id = t.resource_id
668: AND t.request_id = l_request_id
669: AND t.worker_id = l_worker_id
670: AND t.resource_type = 'RS_GROUP'
671: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_OPPOR_WINNERS rt1
672: WHERE rt1.resource_id = j.resource_id
673: AND NVL(rt1.group_id,-1) = NVL(j.group_id,-1)
674: AND rt1.request_id = t.request_id
675: AND rt1.worker_id = t.worker_id

Line 742: JTF_TAE_1001_OPPOR_WINNERS WIN

738: A.salesforce_id,
739: A.sales_group_id,
740: NVL(WIN.full_access_flag,'N')
741: FROM AS_ACCESSES_ALL_ALL A,
742: JTF_TAE_1001_OPPOR_WINNERS WIN
743: WHERE A.lead_id is NOT NULL
744: AND A.sales_lead_id is NULL
745: AND A.delete_flag is NULL
746: AND NVL(A.team_leader_flag,'N') <> NVL(WIN.full_access_flag,'N')

Line 927: FROM JTF_TAE_1001_OPPOR_WINNERS W

923: MIN(W.person_id) person_id,
924: W.trans_object_id lead_id,
925: MAX(W.full_access_flag) faf,
926: W.ORG_ID
927: FROM JTF_TAE_1001_OPPOR_WINNERS W
928: WHERE W.source_id = -1001
929: AND W.worker_id = c_worker_id
930: AND W.resource_type = 'RS_EMPLOYEE'
931: 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 1196: FROM JTF_TAE_1001_OPPOR_WINNERS W

1192: SELECT w.terr_id
1193: ,w.trans_object_id
1194: ,w.resource_id
1195: ,w.group_id
1196: FROM JTF_TAE_1001_OPPOR_WINNERS W
1197: WHERE W.SOURCE_ID = -1001
1198: AND W.worker_id = c_worker_id
1199: AND W.resource_type = 'RS_EMPLOYEE'
1200: 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 1505: FROM JTF_TAE_1001_OPPOR_WINNERS W

1501: AND ACC.lead_id IS NOT NULL
1502: AND ACC.sales_lead_id IS NULL
1503: AND ACC.delete_flag IS NULL
1504: AND NOT EXISTS (SELECT 'X'
1505: FROM JTF_TAE_1001_OPPOR_WINNERS W
1506: WHERE W.trans_object_id = ACC.lead_id
1507: AND W.worker_id = l_worker_id
1508: AND W.resource_id = ACC.salesforce_id
1509: AND W.group_id = ACC.sales_group_id)

Line 1529: FROM JTF_TAE_1001_OPPOR_WINNERS W

1525: AND ACC.freeze_flag = 'N'
1526: AND ACC.lead_id IS NOT NULL
1527: AND ACC.sales_lead_id IS NULL
1528: AND NOT EXISTS (SELECT 'X'
1529: FROM JTF_TAE_1001_OPPOR_WINNERS W
1530: WHERE W.trans_object_id = ACC.lead_id
1531: AND W.worker_id = l_worker_id
1532: AND W.resource_id = ACC.salesforce_id
1533: AND W.group_id = ACC.sales_group_id)

Line 1563: FROM JTF_TAE_1001_OPPOR_WINNERS W

1559: AND ACC.lead_id IS NOT NULL
1560: AND ACC.sales_lead_id IS NULL
1561: AND ACC.delete_flag IS NULL
1562: AND NOT EXISTS (SELECT 'X'
1563: FROM JTF_TAE_1001_OPPOR_WINNERS W
1564: WHERE W.trans_object_id = ACC.lead_id
1565: AND W.resource_id = ACC.salesforce_id
1566: AND W.worker_id = l_worker_id
1567: AND W.group_id = ACC.sales_group_id)

Line 1583: FROM JTF_TAE_1001_OPPOR_WINNERS W

1579: AND ACC.freeze_flag = 'N'
1580: AND ACC.lead_id IS NOT NULL
1581: AND ACC.sales_lead_id IS NULL
1582: AND NOT EXISTS (SELECT 'X'
1583: FROM JTF_TAE_1001_OPPOR_WINNERS W
1584: WHERE W.trans_object_id = ACC.lead_id
1585: AND W.resource_id = ACC.salesforce_id
1586: AND W.worker_id = l_worker_id
1587: AND W.group_id = ACC.sales_group_id)