eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTY_TAE_CONTROL_PVT dependencies on JTF_QUAL_TYPE_USGS_ALL

Line 121: jtf_qual_type_usgs_all b

117: AND trans_object_type_id = p_trans_id
118: AND relation_product not in (
119: SELECT qual_relation_product
120: FROM jtf_terr_qtype_usgs_all a,
121: jtf_qual_type_usgs_all b
122: WHERE a.qual_type_usg_id = b.qual_type_usg_id
123: AND b.source_id = p_source_id
124: AND b.qual_type_id = p_trans_id)
125: RETURNING qual_product_id, relation_product BULK COLLECT INTO l_qual_prd_id_tbl, l_rel_prd_tbl;

Line 236: FROM jtf_qual_type_usgs_all

232:
233: BEGIN
234: SELECT qual_type_usg_id
235: INTO l_qual_type_usg_id
236: FROM jtf_qual_type_usgs_all
237: WHERE source_id = p_source_id
238: AND qual_type_id = p_trans_id;
239: EXCEPTION
240: WHEN NO_DATA_FOUND THEN

Line 241: x_msg_data := 'No row in table jtf_qual_type_usgs_all corresponding to source : ' || p_source_id || ' and transaction : ' ||

237: WHERE source_id = p_source_id
238: AND qual_type_id = p_trans_id;
239: EXCEPTION
240: WHEN NO_DATA_FOUND THEN
241: x_msg_data := 'No row in table jtf_qual_type_usgs_all corresponding to source : ' || p_source_id || ' and transaction : ' ||
242: p_trans_id;
243: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
244: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
245: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.no_qual_type_usg_id',

Line 981: FROM jtf_qual_type_usgs_all

977:
978: BEGIN
979: SELECT qual_type_usg_id
980: INTO l_qual_type_usg_id
981: FROM jtf_qual_type_usgs_all
982: WHERE source_id = p_source_id
983: AND qual_type_id = p_trans_id;
984: EXCEPTION
985: WHEN NO_DATA_FOUND THEN

Line 986: x_msg_data := 'No row in table jtf_qual_type_usgs_all corresponding to source : ' || p_source_id || ' and transaction : ' ||

982: WHERE source_id = p_source_id
983: AND qual_type_id = p_trans_id;
984: EXCEPTION
985: WHEN NO_DATA_FOUND THEN
986: x_msg_data := 'No row in table jtf_qual_type_usgs_all corresponding to source : ' || p_source_id || ' and transaction : ' ||
987: p_trans_id;
988: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
989: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
990: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.no_qual_type_usg_id',