APPS.AS_GAR_OPPTYS_PUB dependencies on JTF_TAE_1001_OPPOR_TRANS

Line 1431: FROM JTF_TAE_1001_OPPOR_TRANS

1427:
1428:
1429: CURSOR del_oppty_totalmode(c_worker_id number) IS
1430: SELECT distinct trans_object_id
1431: FROM JTF_TAE_1001_OPPOR_TRANS
1432: WHERE worker_id=c_worker_id;
1433:
1434: CURSOR del_oppty_newmode(c_worker_id number) IS
1435: SELECT distinct trans_object_id

Line 1663: FROM JTF_TAE_1001_OPPOR_TRANS

1659: SELECT /*+ index(aaa as_accesses_n3) */ aaa.lead_id ,
1660: max(decode(aaa.created_by_tap_flag,'Y',aaa.access_id,-999)) access_id
1661: FROM AS_ACCESSES_ALL_ALL aaa,
1662: ( SELECT distinct trans_object_id
1663: FROM JTF_TAE_1001_OPPOR_TRANS
1664: WHERE worker_id=c_worker_id ) w
1665: WHERE aaa.lead_id IS NOT NULL
1666: AND aaa.sales_lead_id IS NULL
1667: AND aaa.delete_flag IS NULL

Line 1675: FROM JTF_TAE_1001_OPPOR_TRANS w

1671: HAVING SUM(DECODE(aaa.CREATED_BY_TAP_FLAG,'Y',1,0)) > 0
1672: AND SUM(DECODE(aaa.owner_flag,'Y',1,0)) = 0
1673: UNION -- Union added for Bug#4035168
1674: SELECT trans_object_id ,0
1675: FROM JTF_TAE_1001_OPPOR_TRANS w
1676: WHERE worker_id = c_worker_id
1677: AND NOT EXISTS
1678: (SELECT 'x'
1679: FROM AS_ACCESSES_ALL aaa