APPS.AS_GAR_LEADS_PUB dependencies on JTF_TAE_1001_LEAD_NM_TRANS

Line 1482: FROM JTF_TAE_1001_LEAD_NM_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
1482: FROM JTF_TAE_1001_LEAD_NM_TRANS
1483: WHERE worker_id=c_worker_id;
1484:
1485: BEGIN
1486: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_START);

Line 1720: FROM JTF_TAE_1001_LEAD_NM_TRANS

1716: SELECT /*+ index(aaa as_accesses_n6) */ aaa.sales_lead_id ,
1717: max(DECODE(aaa.created_by_tap_flag,'Y',aaa.access_id,-999)) access_id
1718: FROM AS_ACCESSES_ALL_ALL aaa,
1719: ( SELECT distinct trans_object_id
1720: FROM JTF_TAE_1001_LEAD_NM_TRANS
1721: WHERE worker_id=c_worker_id ) w
1722: WHERE aaa.lead_id is null
1723: AND aaa.delete_flag is null
1724: AND aaa.sales_lead_id=w.trans_object_id

Line 1731: FROM JTF_TAE_1001_LEAD_NM_TRANS w

1727: HAVING SUM(DECODE(aaa.CREATED_BY_TAP_FLAG,'Y',1,0)) > 0
1728: AND SUM(DECODE(aaa.owner_flag,'Y',1,0)) = 0
1729: UNION -- Union added for Bug#4035168
1730: SELECT trans_object_id ,0
1731: FROM JTF_TAE_1001_LEAD_NM_TRANS w
1732: WHERE worker_id = c_worker_id
1733: AND NOT EXISTS
1734: (SELECT 'x'
1735: FROM AS_ACCESSES_ALL aaa

Line 1994: from JTF_TAE_1001_LEAD_NM_TRANS

1990: CURSOR new_lead_owner_def(c_worker_id number) IS
1991: SELECT /*+ index(aaa as_accesses_n6) */ aaa.sales_lead_id
1992: FROM as_accesses_all_all aaa,
1993: ( select distinct trans_object_id
1994: from JTF_TAE_1001_LEAD_NM_TRANS
1995: where worker_id=c_worker_id ) w
1996: WHERE aaa.lead_id is null
1997: and aaa.delete_flag is null
1998: AND aaa.sales_lead_id=w.trans_object_id

Line 2003: select trans_object_id from JTF_TAE_1001_LEAD_NM_TRANS w

1999: AND aaa.sales_lead_id+0=w.trans_object_id
2000: GROUP BY aaa.sales_lead_id
2001: HAVING sum(decode(aaa.owner_flag,'Y',1,0)) = 0
2002: UNION -- Union added for Bug#4035168
2003: select trans_object_id from JTF_TAE_1001_LEAD_NM_TRANS w
2004: where worker_id = c_worker_id and not exists
2005: (select 'x' from as_accesses_all aaa
2006: where aaa.sales_lead_id =w.trans_object_id);
2007:

Line 2009: Select trans_object_id from JTF_TAE_1001_LEAD_NM_TRANS w

2005: (select 'x' from as_accesses_all aaa
2006: where aaa.sales_lead_id =w.trans_object_id);
2007:
2008: CURSOR new_lead_owner_tap(c_worker_id number) IS
2009: Select trans_object_id from JTF_TAE_1001_LEAD_NM_TRANS w
2010: where worker_id = c_worker_id and not exists
2011: (select 'x' from as_accesses_all aaa
2012: where aaa.sales_lead_id =w.trans_object_id);
2013:

Line 2476: from JTF_TAE_1001_LEAD_NM_TRANS

2472: CURSOR new_lead_owner(c_worker_id number) IS
2473: SELECT /*+ index(aaa as_accesses_n6) */ aaa.sales_lead_id
2474: FROM as_accesses_all_all aaa,
2475: ( select distinct trans_object_id
2476: from JTF_TAE_1001_LEAD_NM_TRANS
2477: where worker_id=c_worker_id ) w
2478: WHERE aaa.lead_id is null
2479: and aaa.delete_flag is null
2480: AND aaa.sales_lead_id=w.trans_object_id

Line 2668: from JTF_TAE_1001_LEAD_NM_TRANS

2664: SELECT /*+ index(aaa as_accesses_n6) */ aaa.sales_lead_id ,
2665: max(decode(aaa.owner_flag,'Y',aaa.access_id,-999)) access_id
2666: FROM as_accesses_all_all aaa,
2667: ( select distinct trans_object_id
2668: from JTF_TAE_1001_LEAD_NM_TRANS
2669: where worker_id=c_worker_id ) w
2670: WHERE aaa.lead_id is null
2671: and aaa.delete_flag is null
2672: AND aaa.sales_lead_id=w.trans_object_id

Line 2676: select trans_object_id ,0 from JTF_TAE_1001_LEAD_NM_TRANS w

2672: AND aaa.sales_lead_id=w.trans_object_id
2673: AND aaa.sales_lead_id+0=w.trans_object_id
2674: GROUP BY aaa.sales_lead_id
2675: UNION -- Union added for Bug#4035168
2676: select trans_object_id ,0 from JTF_TAE_1001_LEAD_NM_TRANS w
2677: where worker_id = c_worker_id and not exists
2678: (select 'x' from as_accesses_all aaa
2679: where aaa.sales_lead_id =w.trans_object_id);
2680: