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 309: FROM JTF_TAE_1001_LEAD_WINNERS

305:
306: CURSOR c_get_res_type_count(c_resource_type VARCHAR2, c_request_id NUMBER, c_worker_id NUMBER)
307: IS
308: SELECT count(*)
309: FROM JTF_TAE_1001_LEAD_WINNERS
310: WHERE request_id = c_request_id
311: AND resource_type = c_resource_type
312: AND worker_id = c_worker_id
313: AND ROWNUM < 2;

Line 354: INSERT INTO JTF_TAE_1001_LEAD_WINNERS

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

Line 411: JTF_TAE_1001_LEAD_WINNERS T,

407: J.person_id,
408: T.org_id,
409: T.worker_id
410: FROM
411: JTF_TAE_1001_LEAD_WINNERS T,
412: (
413: SELECT TM.team_resource_id resource_id,
414: TM.person_id person_id2,
415: MIN(G.group_id)group_id,

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

521: WHERE j.team_id = t.resource_id
522: AND t.request_id = l_request_id
523: AND t.worker_id = l_worker_id
524: AND t.resource_type = 'RS_TEAM'
525: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_LEAD_WINNERS rt1
526: WHERE rt1.resource_id = j.resource_id
527: AND NVL(rt1.group_id,-1) = NVL(j.group_id,-1)
528: AND rt1.request_id = t.request_id
529: AND rt1.worker_id = t.worker_id

Line 576: FROM JTF_TAE_1001_LEAD_WINNERS

572:
573: CURSOR c_get_res_type_count(c_resource_type VARCHAR2, c_request_id NUMBER, c_worker_id NUMBER)
574: IS
575: SELECT count(*)
576: FROM JTF_TAE_1001_LEAD_WINNERS
577: WHERE request_id = c_request_id
578: AND resource_type = c_resource_type
579: AND worker_id = c_worker_id
580: AND ROWNUM < 2;

Line 619: INSERT INTO JTF_TAE_1001_LEAD_WINNERS

615: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
616: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE
617: **/
618:
619: INSERT INTO JTF_TAE_1001_LEAD_WINNERS
620: (trans_object_id,
621: trans_detail_object_id,
622: terr_id,
623: resource_id,

Line 677: JTF_TAE_1001_LEAD_WINNERS t,

673: J.person_id,
674: T.org_id,
675: T.worker_id
676: FROM
677: JTF_TAE_1001_LEAD_WINNERS t,
678: (
679: SELECT MIN(m.resource_id) resource_id,
680: res.category resource_category,
681: m.group_id group_id, MIN(res.source_id) person_id

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

703: WHERE j.group_id = t.resource_id
704: AND t.request_id = l_request_id
705: AND t.worker_id = l_worker_id
706: AND t.resource_type = 'RS_GROUP'
707: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_LEAD_WINNERS rt1
708: WHERE rt1.resource_id = j.resource_id
709: AND NVL(rt1.group_id,-1) = NVL(j.group_id,-1)
710: AND rt1.request_id = t.request_id
711: AND rt1.worker_id = t.worker_id

Line 779: JTF_TAE_1001_LEAD_WINNERS WIN

775: A.salesforce_id,
776: A.sales_group_id,
777: NVL(WIN.full_access_flag,'N')
778: FROM AS_ACCESSES_ALL_ALL A,
779: JTF_TAE_1001_LEAD_WINNERS WIN
780: WHERE A.lead_id is NULL
781: AND A.sales_lead_id is NOT NULL
782: AND A.delete_flag is NULL
783: AND NVL(A.team_leader_flag,'N') <> NVL(WIN.full_access_flag,'N')

Line 966: FROM JTF_TAE_1001_LEAD_WINNERS W

962: MIN(W.person_id) person_id,
963: W.trans_object_id sales_lead_id,
964: MAX(W.full_access_flag) FAF,
965: W.org_id
966: FROM JTF_TAE_1001_LEAD_WINNERS W
967: WHERE W.source_id = -1001
968: AND W.worker_id = c_worker_id
969: AND W.resource_type = 'RS_EMPLOYEE'
970: 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 1243: FROM JTF_TAE_1001_LEAD_WINNERS W

1239: SELECT w.terr_id
1240: ,w.trans_object_id
1241: ,w.resource_id
1242: ,w.group_id
1243: FROM JTF_TAE_1001_LEAD_WINNERS W
1244: WHERE W.source_id = -1001
1245: AND W.worker_id = c_worker_id
1246: AND W.resource_type = 'RS_EMPLOYEE'
1247: 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 1551: FROM JTF_TAE_1001_LEAD_WINNERS W

1547: AND ACC.lead_id IS NULL
1548: AND ACC.sales_lead_id IS NOT NULL
1549: AND ACC.delete_flag IS NULL
1550: AND NOT EXISTS (SELECT 'X'
1551: FROM JTF_TAE_1001_LEAD_WINNERS W
1552: WHERE W.trans_object_id = ACC.sales_lead_id
1553: AND W.worker_id = l_worker_id
1554: AND W.resource_id = ACC.salesforce_id
1555: AND W.group_id = ACC.sales_group_id)

Line 1571: FROM JTF_TAE_1001_LEAD_WINNERS W

1567: AND ACC.freeze_flag = 'N'
1568: AND ACC.lead_id IS NULL
1569: AND ACC.sales_lead_id IS NOT NULL
1570: AND NOT EXISTS (SELECT 'X'
1571: FROM JTF_TAE_1001_LEAD_WINNERS W
1572: WHERE W.trans_object_id = ACC.sales_lead_id
1573: AND W.worker_id = l_worker_id
1574: AND W.resource_id = ACC.salesforce_id
1575: AND W.group_id = ACC.sales_group_id)

Line 1601: FROM JTF_TAE_1001_LEAD_WINNERS W

1597: AND ACC.lead_id IS NULL
1598: AND ACC.sales_lead_id IS NOT NULL
1599: AND ACC.delete_flag IS NULL
1600: AND NOT EXISTS (SELECT 'X'
1601: FROM JTF_TAE_1001_LEAD_WINNERS W
1602: WHERE W.trans_object_id = ACC.sales_lead_id
1603: AND W.resource_id = ACC.salesforce_id
1604: AND W.worker_id = l_worker_id
1605: AND W.group_id = ACC.sales_group_id);

Line 1617: FROM JTF_TAE_1001_LEAD_WINNERS W

1613: AND ACC.freeze_flag = 'N'
1614: AND ACC.lead_id IS NULL
1615: AND ACC.sales_lead_id IS NOT NULL
1616: AND NOT EXISTS (SELECT 'X'
1617: FROM JTF_TAE_1001_LEAD_WINNERS W
1618: WHERE W.trans_object_id = ACC.sales_lead_id
1619: AND W.resource_id = ACC.salesforce_id
1620: AND W.worker_id = l_worker_id
1621: AND W.group_id = ACC.sales_group_id);