DBA Data[Home] [Help]

APPS.JTF_TERRITORY_RESOURCE_PVT dependencies on JTF_SEEDED_QUAL_USGS_V

Line 3870: FROM jtf_seeded_qual_usgs_v jsquv, JTF_TERR_QUAL JTQ

3866: v_Terr_Qual_Id number;
3867:
3868: CURSOR c_Terr_ResQual IS
3869: SELECT JTQ.TERR_QUAL_ID
3870: FROM jtf_seeded_qual_usgs_v jsquv, JTF_TERR_QUAL JTQ
3871: WHERE JTQ.terr_id = p_Terr_id and
3872: JTQ.qual_usg_id = jsquv.qual_usg_id and
3873: jsquv.qual_type_id = -1001 and
3874: jsquv.qual_type_id in ( select related_id

Line 3886: from jtf_seeded_qual_usgs_v jsquv, jtf_terr_values jtv, jtf_terr_qual jtq

3882: jtv.low_value_number, jtv.high_value_number,
3883: jtv.INTEREST_TYPE_ID, jtv.PRIMARY_INTEREST_CODE_ID,
3884: jtv.SECONDARY_INTEREST_CODE_ID, jsquv.DISPLAY_TYPE, jsquv.CONVERT_TO_ID_FLAG,
3885: jtv.ID_USED_FLAG, jtv.CURRENCY_CODE, jtv.LOW_VALUE_CHAR_ID
3886: from jtf_seeded_qual_usgs_v jsquv, jtf_terr_values jtv, jtf_terr_qual jtq
3887: where jtv.terr_qual_id = v_Terr_Qual_Id and
3888: jtv.terr_qual_id = jtq.terr_qual_id and
3889: jtq.qual_usg_id = jsquv.qual_usg_id;
3890: