VIEW: APPS.JTF_IH_WRAPUP_OUTCOMES_VL

Source

View Text - Preformatted

SELECT WRP.ROWID , WRP.WRAP_ID , WRP.OBJECT_VERSION_NUMBER , WRP.CREATED_BY , WRP.CREATION_DATE , WRP.LAST_UPDATED_BY , WRP.LAST_UPDATE_DATE , WRP.LAST_UPDATE_LOGIN , OTB.RESULT_REQUIRED , WRP.OUTCOME_ID , WRP.RESULT_ID , WRP.REASON_ID , WRP.ACTION_ACTIVITY_ID, WRP.OBJECT_ID , WRP.OBJECT_TYPE , WRP.SOURCE_CODE_ID, WRP.SOURCE_CODE , WRP.SECURITY_GROUP_ID , WRP.START_DATE , WRP.END_DATE , WRP.WRAP_UP_LEVEL , OTT.SHORT_DESCRIPTION , OTB.VERSATILITY_CODE , OTB.GENERATE_PUBLIC_CALLBACK , OTB.GENERATE_PRIVATE_CALLBACK , OTB.POSITIVE_OUTCOME_FLAG , OTB.ACTIVE FROM JTF_IH_OUTCOMES_B OTB, JTF_IH_OUTCOMES_TL OTT, JTF_IH_WRAP_UPS WRP WHERE wrp.outcome_id = otb.outcome_id and wrp.outcome_id = ott.outcome_id and ott.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT WRP.ROWID
, WRP.WRAP_ID
, WRP.OBJECT_VERSION_NUMBER
, WRP.CREATED_BY
, WRP.CREATION_DATE
, WRP.LAST_UPDATED_BY
, WRP.LAST_UPDATE_DATE
, WRP.LAST_UPDATE_LOGIN
, OTB.RESULT_REQUIRED
, WRP.OUTCOME_ID
, WRP.RESULT_ID
, WRP.REASON_ID
, WRP.ACTION_ACTIVITY_ID
, WRP.OBJECT_ID
, WRP.OBJECT_TYPE
, WRP.SOURCE_CODE_ID
, WRP.SOURCE_CODE
, WRP.SECURITY_GROUP_ID
, WRP.START_DATE
, WRP.END_DATE
, WRP.WRAP_UP_LEVEL
, OTT.SHORT_DESCRIPTION
, OTB.VERSATILITY_CODE
, OTB.GENERATE_PUBLIC_CALLBACK
, OTB.GENERATE_PRIVATE_CALLBACK
, OTB.POSITIVE_OUTCOME_FLAG
, OTB.ACTIVE
FROM JTF_IH_OUTCOMES_B OTB
, JTF_IH_OUTCOMES_TL OTT
, JTF_IH_WRAP_UPS WRP
WHERE WRP.OUTCOME_ID = OTB.OUTCOME_ID
AND WRP.OUTCOME_ID = OTT.OUTCOME_ID
AND OTT.LANGUAGE = USERENV('LANG')