APPS.AS_GAR_LEADS_PUB dependencies on JTF_TAE_1001_LEAD_TRANS

Line 1477: FROM JTF_TAE_1001_LEAD_TRANS

1473:
1474:
1475: CURSOR del_lead_totalmode(c_worker_id number) IS
1476: SELECT distinct trans_object_id
1477: FROM JTF_TAE_1001_LEAD_TRANS
1478: WHERE worker_id=c_worker_id;
1479:
1480: CURSOR del_lead_newmode(c_worker_id number) IS
1481: SELECT distinct trans_object_id

Line 1693: FROM JTF_TAE_1001_LEAD_TRANS

1689: SELECT /*+ index(aaa as_accesses_n6) */ aaa.sales_lead_id ,
1690: max(DECODE(aaa.created_by_tap_flag,'Y',aaa.access_id,-999)) access_id
1691: FROM AS_ACCESSES_ALL_ALL aaa,
1692: ( SELECT distinct trans_object_id
1693: FROM JTF_TAE_1001_LEAD_TRANS
1694: WHERE worker_id=c_worker_id ) w
1695: WHERE aaa.lead_id is NULL
1696: AND aaa.sales_lead_id is NOT NULL
1697: AND aaa.delete_flag is NULL

Line 1705: FROM JTF_TAE_1001_LEAD_TRANS w

1701: HAVING SUM(DECODE(aaa.CREATED_BY_TAP_FLAG,'Y',1,0)) > 0
1702: AND SUM(DECODE(aaa.owner_flag,'Y',1,0)) = 0
1703: UNION -- Union added for Bug#4035168
1704: SELECT trans_object_id ,0
1705: FROM JTF_TAE_1001_LEAD_TRANS w
1706: WHERE worker_id = c_worker_id
1707: AND NOT EXISTS
1708: (SELECT 'x'
1709: FROM AS_ACCESSES_ALL aaa

Line 1970: from jtf_tae_1001_lead_trans

1966: CURSOR tot_lead_owner_def(c_worker_id number) IS
1967: SELECT /*+ index(aaa as_accesses_n6) */ aaa.sales_lead_id
1968: FROM as_accesses_all_all aaa,
1969: ( select distinct trans_object_id
1970: from jtf_tae_1001_lead_trans
1971: where worker_id=c_worker_id ) w
1972: WHERE aaa.lead_id is null
1973: and aaa.delete_flag is null
1974: AND aaa.sales_lead_id=w.trans_object_id

Line 1979: select trans_object_id from jtf_tae_1001_lead_trans w

1975: AND aaa.sales_lead_id+0=w.trans_object_id
1976: GROUP BY aaa.sales_lead_id
1977: HAVING sum(decode(aaa.owner_flag,'Y',1,0)) = 0
1978: UNION -- Union added for Bug#4035168
1979: select trans_object_id from jtf_tae_1001_lead_trans w
1980: where worker_id = c_worker_id and not exists
1981: (select 'x' from as_accesses_all aaa
1982: where aaa.sales_lead_id =w.trans_object_id);
1983:

Line 1985: Select trans_object_id from jtf_tae_1001_lead_trans w

1981: (select 'x' from as_accesses_all aaa
1982: where aaa.sales_lead_id =w.trans_object_id);
1983:
1984: CURSOR tot_lead_owner_tap(c_worker_id number) IS
1985: Select trans_object_id from jtf_tae_1001_lead_trans w
1986: where worker_id = c_worker_id and not exists
1987: (select 'x' from as_accesses_all aaa
1988: where aaa.sales_lead_id =w.trans_object_id);
1989:

Line 2463: from jtf_tae_1001_lead_trans

2459: CURSOR tot_lead_owner(c_worker_id number) IS
2460: SELECT /*+ index(aaa as_accesses_n6) */ aaa.sales_lead_id
2461: FROM as_accesses_all_all aaa,
2462: ( select distinct trans_object_id
2463: from jtf_tae_1001_lead_trans
2464: where worker_id=c_worker_id ) w
2465: WHERE aaa.lead_id is null
2466: and aaa.delete_flag is null
2467: AND aaa.sales_lead_id=w.trans_object_id

Line 2649: from jtf_tae_1001_lead_trans

2645: SELECT /*+ index(aaa as_accesses_n6) */ aaa.sales_lead_id ,
2646: max(decode(aaa.owner_flag,'Y',aaa.access_id,-999)) access_id
2647: FROM as_accesses_all_all aaa,
2648: ( select distinct trans_object_id
2649: from jtf_tae_1001_lead_trans
2650: where worker_id=c_worker_id ) w
2651: WHERE aaa.lead_id is null
2652: and aaa.delete_flag is null
2653: AND aaa.sales_lead_id=w.trans_object_id

Line 2657: select trans_object_id ,0 from jtf_tae_1001_lead_trans w

2653: AND aaa.sales_lead_id=w.trans_object_id
2654: AND aaa.sales_lead_id+0=w.trans_object_id
2655: GROUP BY aaa.sales_lead_id
2656: UNION -- Union added for Bug#4035168
2657: select trans_object_id ,0 from jtf_tae_1001_lead_trans w
2658: where worker_id = c_worker_id and not exists
2659: (select 'x' from as_accesses_all aaa
2660: where aaa.sales_lead_id =w.trans_object_id);
2661: