DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on JTF_RS_GROUP_MEMBERS

Line 1842: FROM JTF_RS_GROUP_MEMBERS MEM

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

Line 5300: FROM JTF_RS_GROUP_MEMBERS MEM

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