DBA Data[Home] [Help]

APPS.JTF_TERR_DEFINITION_REPORT_PVT dependencies on JTF_TERR_VALUES_DESC_V

Line 88: FROM jtf_terr_values_desc_v j1

84: , VALUE2_ID
85: , wf_notification.substitutespecialchars(VALUE2_DESC) VALUE2_DESC
86: , VALUE3_ID
87: , wf_notification.substitutespecialchars(VALUE3_DESC) VALUE3_DESC
88: FROM jtf_terr_values_desc_v j1
89: WHERE j1.terr_qual_id = p_terr_qual_id
90: ORDER BY j1.LOW_VALUE_CHAR_DESC, j1.COMPARISON_OPERATOR;
91:
92: BEGIN

Line 411: FROM jtf_terr_values_desc_v j1

407: , j1.LOW_VALUE_CHAR_ID
408: , wf_notification.substitutespecialchars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
409: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
410: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG
411: FROM jtf_terr_values_desc_v j1
412: WHERE j1.terr_qual_id = p_terr_qual_id
413: ORDER BY j1.LOW_VALUE_CHAR_DESC, j1.COMPARISON_OPERATOR;
414:
415: BEGIN