DBA Data[Home] [Help]

APPS.JTY_COLLECTION_MIGRATION_PKG dependencies on JTF_QUAL_USGS_ALL

Line 155: jtf_qual_usgs_all col_usg, jtf_qual_usgs_all sales_usg

151: col_usg.qual_usg_id QUAL_USG_ID, jtq.QUALIFIER_MODE,
152: jtq.OVERLAP_ALLOWED_FLAG, jtq.USE_TO_NAME_FLAG, jtq.GENERATE_FLAG,
153: jtq.ORG_ID, jtq.SECURITY_GROUP_ID, jtq.OBJECT_VERSION_NUMBER
154: from JTF_TERR_QUAL_ALL jtq,
155: jtf_qual_usgs_all col_usg, jtf_qual_usgs_all sales_usg
156: where jtq.terr_id = v_terr_id
157: and jtq.qual_usg_id = sales_usg.qual_usg_id
158: and jtq.org_id = sales_usg.org_id
159: and col_usg.qual_type_usg_id = v_qtype_usg_id