APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on JTF_QUAL_TYPE_USGS_ALL

Line 790: ,jtf_qual_type_usgs_all jqtu

786: MAX(p.first_char_flag) first_char_flag,
787: COUNT(r.qual_factor_id) cartesian_terr_X_factors
788: FROM jtf_terr_denorm_rules_all d
789: ,jtf_terr_qtype_usgs_all jtqu
790: ,jtf_qual_type_usgs_all jqtu
791: ,JTF_TAE_QUAL_PRODUCTS P
792: , JTF_TAE_QUAL_PROD_FACTORS R
793: WHERE jtqu.qual_relation_product = p.relation_product
794: AND jqtu.source_id = d.source_id

Line 867: ,jtf_qual_type_usgs_all jqtu

863: MAX(p.first_char_flag) first_char_flag,
864: COUNT(r.dea_attr_factors_id) cartesian_terr_X_factors
865: FROM jty_denorm_dea_rules_all d
866: ,jtf_terr_qtype_usgs_all jtqu
867: ,jtf_qual_type_usgs_all jqtu
868: ,jty_dea_attr_products P
869: ,jty_dea_attr_prod_factors R
870: WHERE jtqu.qual_relation_product = p.attr_relation_product
871: AND jqtu.source_id = d.source_id

Line 1015: FROM jtf_qual_type_usgs_all

1011:
1012: BEGIN
1013: SELECT qual_type_usg_id
1014: INTO l_qual_type_usg_id
1015: FROM jtf_qual_type_usgs_all
1016: WHERE source_id = p_source_id
1017: AND qual_type_id = p_trans_id;
1018: EXCEPTION
1019: WHEN NO_DATA_FOUND THEN

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

1018: EXCEPTION
1019: WHEN NO_DATA_FOUND THEN
1020: jty_log(FND_LOG.LEVEL_EXCEPTION,
1021: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.no_qual_type_usg_id',
1022: 'No row in table jtf_qual_type_usgs_all corresponding to source : ' || p_source_id || ' and transaction : ' ||
1023: p_trans_id);
1024: RAISE;
1025: END;
1026: