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_LEADS_PUB dependencies on JTF_TAE_1001_LEAD_WINNERS

Line 268: FROM JTF_TAE_1001_LEAD_WINNERS

264:
265: CURSOR c_get_res_type_count(c_resource_type VARCHAR2, c_request_id NUMBER, c_worker_id NUMBER)
266: IS
267: SELECT count(*)
268: FROM JTF_TAE_1001_LEAD_WINNERS
269: WHERE request_id = c_request_id
270: AND resource_type = c_resource_type
271: AND worker_id = c_worker_id
272: AND ROWNUM < 2;

Line 313: INSERT INTO JTF_TAE_1001_LEAD_WINNERS

309: /** Note
310: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
311: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE
312: **/
313: INSERT INTO JTF_TAE_1001_LEAD_WINNERS
314: (trans_object_id,
315: trans_detail_object_id,
316: terr_id,
317: resource_id,

Line 370: JTF_TAE_1001_LEAD_WINNERS T,

366: J.person_id,
367: T.org_id,
368: T.worker_id
369: FROM
370: JTF_TAE_1001_LEAD_WINNERS T,
371: (
372: SELECT TM.team_resource_id resource_id,
373: TM.person_id person_id2,
374: MIN(G.group_id)group_id,

Line 484: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_LEAD_WINNERS rt1

480: WHERE j.team_id = t.resource_id
481: AND t.request_id = l_request_id
482: AND t.worker_id = l_worker_id
483: AND t.resource_type = 'RS_TEAM'
484: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_LEAD_WINNERS rt1
485: WHERE rt1.resource_id = j.resource_id
486: AND NVL(rt1.group_id,-1) = NVL(j.group_id,-1)
487: AND rt1.request_id = t.request_id
488: AND rt1.worker_id = t.worker_id

Line 535: FROM JTF_TAE_1001_LEAD_WINNERS

531:
532: CURSOR c_get_res_type_count(c_resource_type VARCHAR2, c_request_id NUMBER, c_worker_id NUMBER)
533: IS
534: SELECT count(*)
535: FROM JTF_TAE_1001_LEAD_WINNERS
536: WHERE request_id = c_request_id
537: AND resource_type = c_resource_type
538: AND worker_id = c_worker_id
539: AND ROWNUM < 2;

Line 578: INSERT INTO JTF_TAE_1001_LEAD_WINNERS

574: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
575: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE
576: **/
577:
578: INSERT INTO JTF_TAE_1001_LEAD_WINNERS
579: (trans_object_id,
580: trans_detail_object_id,
581: terr_id,
582: resource_id,

Line 636: JTF_TAE_1001_LEAD_WINNERS t,

632: J.person_id,
633: T.org_id,
634: T.worker_id
635: FROM
636: JTF_TAE_1001_LEAD_WINNERS t,
637: (
638: SELECT MIN(m.resource_id) resource_id,
639: res.category resource_category,
640: m.group_id group_id, MIN(res.source_id) person_id

Line 666: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_LEAD_WINNERS rt1

662: WHERE j.group_id = t.resource_id
663: AND t.request_id = l_request_id
664: AND t.worker_id = l_worker_id
665: AND t.resource_type = 'RS_GROUP'
666: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_LEAD_WINNERS rt1
667: WHERE rt1.resource_id = j.resource_id
668: AND NVL(rt1.group_id,-1) = NVL(j.group_id,-1)
669: AND rt1.request_id = t.request_id
670: AND rt1.worker_id = t.worker_id

Line 738: JTF_TAE_1001_LEAD_WINNERS WIN

734: A.salesforce_id,
735: A.sales_group_id,
736: NVL(WIN.full_access_flag,'N')
737: FROM AS_ACCESSES_ALL_ALL A,
738: JTF_TAE_1001_LEAD_WINNERS WIN
739: WHERE A.lead_id is NULL
740: AND A.sales_lead_id is NOT NULL
741: AND A.delete_flag is NULL
742: AND NVL(A.team_leader_flag,'N') <> NVL(WIN.full_access_flag,'N')

Line 925: FROM JTF_TAE_1001_LEAD_WINNERS W

921: MIN(W.person_id) person_id,
922: W.trans_object_id sales_lead_id,
923: MAX(W.full_access_flag) FAF,
924: W.org_id
925: FROM JTF_TAE_1001_LEAD_WINNERS W
926: WHERE W.source_id = -1001
927: AND W.worker_id = c_worker_id
928: AND W.resource_type = 'RS_EMPLOYEE'
929: 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 1202: FROM JTF_TAE_1001_LEAD_WINNERS W

1198: SELECT w.terr_id
1199: ,w.trans_object_id
1200: ,w.resource_id
1201: ,w.group_id
1202: FROM JTF_TAE_1001_LEAD_WINNERS W
1203: WHERE W.source_id = -1001
1204: AND W.worker_id = c_worker_id
1205: AND W.resource_type = 'RS_EMPLOYEE'
1206: 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 1510: FROM JTF_TAE_1001_LEAD_WINNERS W

1506: AND ACC.lead_id IS NULL
1507: AND ACC.sales_lead_id IS NOT NULL
1508: AND ACC.delete_flag IS NULL
1509: AND NOT EXISTS (SELECT 'X'
1510: FROM JTF_TAE_1001_LEAD_WINNERS W
1511: WHERE W.trans_object_id = ACC.sales_lead_id
1512: AND W.worker_id = l_worker_id
1513: AND W.resource_id = ACC.salesforce_id
1514: AND W.group_id = ACC.sales_group_id)

Line 1530: FROM JTF_TAE_1001_LEAD_WINNERS W

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

Line 1560: FROM JTF_TAE_1001_LEAD_WINNERS W

1556: AND ACC.lead_id IS NULL
1557: AND ACC.sales_lead_id IS NOT NULL
1558: AND ACC.delete_flag IS NULL
1559: AND NOT EXISTS (SELECT 'X'
1560: FROM JTF_TAE_1001_LEAD_WINNERS W
1561: WHERE W.trans_object_id = ACC.sales_lead_id
1562: AND W.resource_id = ACC.salesforce_id
1563: AND W.worker_id = l_worker_id
1564: AND W.group_id = ACC.sales_group_id);

Line 1576: FROM JTF_TAE_1001_LEAD_WINNERS W

1572: AND ACC.freeze_flag = 'N'
1573: AND ACC.lead_id IS NULL
1574: AND ACC.sales_lead_id IS NOT NULL
1575: AND NOT EXISTS (SELECT 'X'
1576: FROM JTF_TAE_1001_LEAD_WINNERS W
1577: WHERE W.trans_object_id = ACC.sales_lead_id
1578: AND W.resource_id = ACC.salesforce_id
1579: AND W.worker_id = l_worker_id
1580: AND W.group_id = ACC.sales_group_id);