FND Design Data [Home] [Help]

View: JTF_IH_RESULT_REASONS_VL

Product: JTF - CRM Foundation
Description:
Implementation/DBA Data: ViewAPPS.JTF_IH_RESULT_REASONS_VL
View Text

SELECT REARES.RESULT_ID
, REARES.REASON_ID
, RES.SHORT_DESCRIPTION
, REA.SHORT_DESCRIPTION
FROM JTF_IH_RESULT_REASONS REARES
, JTF_IH_RESULTS_VL RES
, JTF_IH_REASONS_VL REA
WHERE REARES.RESULT_ID = RES.RESULT_ID
AND REARES.REASON_ID = REA.REASON_ID

Columns

Name
RESULT_ID
REASON_ID
RESULT_SHORT_DESC
REASON_SHORT_DESC