DBA Data[Home] [Help]

APPS.JTF_TERR_MERGE_PUB dependencies on JTF_TERR_QUAL_ALL

Line 71: FROM jtf_terr_qual_all jtq

67: , jtv.last_update_login = HZ_UTILITY_PUB.last_update_login
68: WHERE jtv.low_value_char_id = p_from_FK_id
69: AND EXISTS (
70: SELECT jtq.terr_qual_id
71: FROM jtf_terr_qual_all jtq
72: WHERE jtq.qual_usg_id IN (-1511, -1435, -1078, -1064, -1063, -1037, -1014, -1002, -1001, -1201, -1094, -1039)
73: AND jtq.terr_qual_id = jtv.terr_qual_id
74: );
75:

Line 155: FROM jtf_terr_qual_all jtq

151: , jtv.last_update_login = HZ_UTILITY_PUB.last_update_login
152: WHERE jtv.low_value_char_id = p_from_FK_id
153: AND EXISTS (
154: SELECT jtq.terr_qual_id
155: FROM jtf_terr_qual_all jtq
156: WHERE jtq.qual_usg_id IN (-1094, -1093, -1077, -1039, -1005, -1201, -1094)
157: AND jtq.terr_qual_id = jtv.terr_qual_id
158: );
159: