APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on JTF_QUAL_TYPE_USGS_ALL

Line 835: ,jtf_qual_type_usgs_all jqtu

831: MAX(p.first_char_flag) first_char_flag,
832: COUNT(r.qual_factor_id) cartesian_terr_X_factors
833: FROM jtf_terr_denorm_rules_all d
834: ,jtf_terr_qtype_usgs_all jtqu
835: ,jtf_qual_type_usgs_all jqtu
836: ,JTF_TAE_QUAL_PRODUCTS P
837: , JTF_TAE_QUAL_PROD_FACTORS R
838: WHERE jtqu.qual_relation_product = p.relation_product
839: AND jqtu.source_id = d.source_id

Line 912: ,jtf_qual_type_usgs_all jqtu

908: MAX(p.first_char_flag) first_char_flag,
909: COUNT(r.dea_attr_factors_id) cartesian_terr_X_factors
910: FROM jty_denorm_dea_rules_all d
911: ,jtf_terr_qtype_usgs_all jtqu
912: ,jtf_qual_type_usgs_all jqtu
913: ,jty_dea_attr_products P
914: ,jty_dea_attr_prod_factors R
915: WHERE jtqu.qual_relation_product = p.attr_relation_product
916: AND jqtu.source_id = d.source_id

Line 1068: FROM jtf_qual_type_usgs_all

1064:
1065: BEGIN
1066: SELECT qual_type_usg_id
1067: INTO l_qual_type_usg_id
1068: FROM jtf_qual_type_usgs_all
1069: WHERE source_id = p_source_id
1070: AND qual_type_id = p_trans_id;
1071: EXCEPTION
1072: WHEN NO_DATA_FOUND THEN

Line 1076: 'No row in table jtf_qual_type_usgs_all corresponding to source : ' || p_source_id || ' and transaction : ' ||

1072: WHEN NO_DATA_FOUND THEN
1073: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1074: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1075: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.no_qual_type_usg_id',
1076: 'No row in table jtf_qual_type_usgs_all corresponding to source : ' || p_source_id || ' and transaction : ' ||
1077: p_trans_id);
1078: END IF;
1079: RAISE;
1080: END;