DBA Data[Home] [Help]

APPS.JTF_TERR_JSP_REPORTS dependencies on JTF_TERR_QUALIFIERS_V

Line 116: FROM jtf_terr_qualifiers_v

112: TERR_ID,
113: QUAL_USG_ID,
114: ORG_ID,
115: WF_NOTIFICATION.SubstituteSpecialChars(qualifier_name) qualifier_name
116: FROM jtf_terr_qualifiers_v
117: WHERE qualifier_type_name <> 'RESOURCE'
118: and terr_id = ci_terr_id
119: and terr_qual_id is not null -- added becuse we have some real bad data in jtadom
120: ;

Line 153: FROM jtf_terr_qualifiers_v

149: TERR_ID,
150: QUAL_USG_ID,
151: ORG_ID,
152: WF_NOTIFICATION.SubstituteSpecialChars(qualifier_name) qualifier_name
153: FROM jtf_terr_qualifiers_v
154: WHERE qualifier_type_name = 'RESOURCE'
155: and terr_id = ci_terr_id;
156:
157: