APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTF_TERR_QUAL_ALL

Line 861: jtf_terr_qual_all jtqa,

857: jtdr.end_date,
858: count(*) over(partition by jtqa.qual_usg_id)
859: FROM jtf_terr_all jta,
860: jtf_terr_denorm_rules_all jtdr,
861: jtf_terr_qual_all jtqa,
862: jtf_terr_values_all jtva,
863: jtf_qual_usgs_all jqua,
864: jtf_qual_type_usgs_all jqtu,
865: jtf_qual_type_denorm_v inlv

Line 918: jtf_terr_qual_all jtqa,

914: jtdr.end_date,
915: count(*) over(partition by jtqa.qual_usg_id)
916: FROM jtf_terr_all jta,
917: jtf_terr_denorm_rules_all jtdr,
918: jtf_terr_qual_all jtqa,
919: jtf_terr_values_all jtva,
920: jtf_qual_usgs_all jqua,
921: jtf_qual_type_usgs_all jqtu,
922: jtf_qual_type_denorm_v inlv,

Line 981: jtf_terr_qual_all jtqa,

977: jtdr.end_date,
978: count(*) over(partition by jtqa.qual_usg_id)
979: FROM jtf_terr_all jta,
980: jty_denorm_dea_rules_all jtdr,
981: jtf_terr_qual_all jtqa,
982: jtf_terr_values_all jtva,
983: jtf_qual_usgs_all jqua,
984: jtf_qual_type_usgs_all jqtu,
985: jtf_qual_type_denorm_v inlv

Line 1035: jtf_terr_qual_all jtqa,

1031: jtdr.end_date,
1032: count(*) over(partition by jtqa.qual_usg_id)
1033: FROM jtf_terr_all jta,
1034: jty_denorm_dea_rules_all jtdr,
1035: jtf_terr_qual_all jtqa,
1036: jtf_terr_values_all jtva,
1037: jtf_qual_usgs_all jqua,
1038: jtf_qual_type_usgs_all jqtu,
1039: jtf_qual_type_denorm_v inlv,

Line 1081: FROM JTF_TERR_QUAL_ALL jtqa, JTF_TERR_USGS_ALL jtua, JTF_TERR_ALL jta

1077:
1078:
1079: CURSOR c_actual_tab_reference is
1080: SELECT COUNT(*)
1081: FROM JTF_TERR_QUAL_ALL jtqa, JTF_TERR_USGS_ALL jtua, JTF_TERR_ALL jta
1082: WHERE jtqa.QUAL_USG_ID NOT IN
1083: (-1040, -1041, -1042, -1044, -1744, -1734, -1048, -1096, -1038, -1061, -1060, -1043,
1084: -1095, -1051, -1050, -1037, -1210, -1045, -1046, -1206, -1213, -1039, -1218)
1085: AND JTQA.TERR_ID = JTUA.TERR_ID

Line 2251: FROM jtf_terr_qual_all i1, jtf_qual_usgs_all i2, jtf_qual_type_usgs_all i3

2247: SET o.first_char = SUBSTR(o.low_value_char, 1, 1)
2248: WHERE o.terr_qual_id IN (
2249: SELECT /*+ INDEX (i2 jtf_qual_usgs_n3) */
2250: i1.terr_qual_id
2251: FROM jtf_terr_qual_all i1, jtf_qual_usgs_all i2, jtf_qual_type_usgs_all i3
2252: WHERE i1.qual_usg_id = i2.qual_usg_id
2253: AND i2.display_type = 'CHAR'
2254: AND i2.lov_sql IS NULL
2255: AND i2.org_id = -3113