DBA Data[Home] [Help]

APPS.AS_GAR_QOT_PUB dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 281: JTF_TERR_RSC_ACCESS_ALL acc

277: IS
278: SELECT count(*)
279: FROM JTF_TERR_RSC_ALL rsc,
280: JTF_TERR_DENORM_RULES_ALL rules,
281: JTF_TERR_RSC_ACCESS_ALL acc
282: WHERE rules.terr_id = rsc.terr_id
283: AND rsc.resource_type = 'RS_TEAM'
284: AND acc.access_type = 'QUOTE'
285: AND rules.source_id = -1001

Line 549: JTF_TERR_RSC_ACCESS_ALL acc

545: IS
546: SELECT count(*)
547: FROM JTF_TERR_RSC_ALL rsc,
548: JTF_TERR_DENORM_RULES_ALL rules,
549: JTF_TERR_RSC_ACCESS_ALL acc
550: WHERE rules.terr_id = rsc.terr_id
551: AND rsc.resource_type = 'RS_GROUP'
552: AND acc.access_type = 'QUOTE'
553: AND rules.source_id = -1001