DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on JTF_RS_GROUP_USAGES

Line 1874: ,JTF_RS_GROUP_USAGES USG

1870: AND HST.SALESGROUP_ID <> -1
1871: AND NOT EXISTS (SELECT 'X'
1872: FROM JTF_RS_GROUP_MEMBERS MEM
1873: ,JTF_RS_SALESREPS SRP
1874: ,JTF_RS_GROUP_USAGES USG
1875: WHERE SRP.RESOURCE_ID = MEM.RESOURCE_ID
1876: AND MEM.GROUP_ID = USG.GROUP_ID
1877: AND USG.USAGE = 'SALES'
1878: AND SRP.SALESREP_ID = HST.SALESPERSON_ID

Line 5446: ,JTF_RS_GROUP_USAGES USG

5442: (OSC.SALESGROUP_ID <> -1
5443: AND NOT EXISTS (SELECT 'X'
5444: FROM JTF_RS_GROUP_MEMBERS MEM
5445: ,JTF_RS_SALESREPS SRP
5446: ,JTF_RS_GROUP_USAGES USG
5447: WHERE SRP.RESOURCE_ID = MEM.RESOURCE_ID
5448: AND MEM.GROUP_ID = USG.GROUP_ID
5449: AND USG.USAGE = 'SALES'
5450: AND SRP.SALESREP_ID = NAMEID_Q.SALESPERSON_ID