DBA Data[Home] [Help]

APPS.JTY_TAE_CONTROL_PVT dependencies on JTF_TERR_QTYPE_USGS_ALL

Line 130: FROM jtf_terr_qtype_usgs_all a,

126: WHERE source_id = p_source_id
127: AND trans_object_type_id = p_trans_id
128: AND relation_product not in (
129: SELECT qual_relation_product
130: FROM jtf_terr_qtype_usgs_all a,
131: jtf_qual_type_usgs_all b
132: WHERE a.qual_type_usg_id = b.qual_type_usg_id
133: AND b.source_id = p_source_id
134: AND b.qual_type_id = p_trans_id)

Line 171: FROM jtf_terr_qtype_usgs_all a,

167: WHERE source_id = p_source_id
168: AND trans_type_id = p_trans_id
169: AND attr_relation_product not in (
170: SELECT qual_relation_product
171: FROM jtf_terr_qtype_usgs_all a,
172: jtf_qual_type_usgs_all b
173: WHERE a.qual_type_usg_id = b.qual_type_usg_id
174: AND b.source_id = p_source_id
175: AND b.qual_type_id = p_trans_id)