DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on JTF_RS_GROUP_MEMBERS

Line 1872: FROM JTF_RS_GROUP_MEMBERS MEM

1868: ,HST.HEADER_INTERFACE_ID HEADER_INTERFACE_ID
1869: ,(CASE WHEN HST.SALESGROUP_ID IS NOT NULL
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

Line 5444: FROM JTF_RS_GROUP_MEMBERS MEM

5440: ,NAMEID_Q.SALESPERSON_ID SALESPERSON_ID
5441: ,(CASE WHEN OSC.SALESGROUP_ID IS NULL OR
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