DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on JTF_RS_GROUP_USAGES

Line 1844: ,JTF_RS_GROUP_USAGES USG

1840: AND HST.SALESGROUP_ID <> -1
1841: AND NOT EXISTS (SELECT 'X'
1842: FROM JTF_RS_GROUP_MEMBERS MEM
1843: ,JTF_RS_SALESREPS SRP
1844: ,JTF_RS_GROUP_USAGES USG
1845: WHERE SRP.RESOURCE_ID = MEM.RESOURCE_ID
1846: AND MEM.GROUP_ID = USG.GROUP_ID
1847: AND USG.USAGE = 'SALES'
1848: AND SRP.SALESREP_ID = HST.SALESPERSON_ID

Line 5302: ,JTF_RS_GROUP_USAGES USG

5298: (OSC.SALESGROUP_ID <> -1
5299: AND NOT EXISTS (SELECT 'X'
5300: FROM JTF_RS_GROUP_MEMBERS MEM
5301: ,JTF_RS_SALESREPS SRP
5302: ,JTF_RS_GROUP_USAGES USG
5303: WHERE SRP.RESOURCE_ID = MEM.RESOURCE_ID
5304: AND MEM.GROUP_ID = USG.GROUP_ID
5305: AND USG.USAGE = 'SALES'
5306: AND SRP.SALESREP_ID = NAMEID_Q.SALESPERSON_ID