DBA Data[Home] [Help]

APPS.JTF_TERR_DIAGNOSTIC_TEST dependencies on JTF_QUAL_TYPES_ALL

Line 87: , jtf_qual_types_all qta

83: CURSOR C_valid_terrs_with_reps(lc_source_id NUMBER)
84: IS
85: select qta.description name, count(*) terr_count
86: from jtf_terr_denorm_rules_all jtdr
87: , jtf_qual_types_all qta
88: where jtdr.source_id = lc_source_id
89: and jtdr.terr_id = jtdr.related_terr_id
90: and jtdr.qual_type_id = qta.qual_type_id
91: and jtdr.resource_exists_flag = 'Y'