VIEW: APPS.JTF_IH_WRAP_UPS_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, outc.result_required, res.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, outc.short_description, res.short_description, rea.short_description, rea.generate_public_callback, rea.generate_private_callback, rea.versatility_code, res.generate_public_callback, res.generate_private_callback, res.versatility_code, res.positive_response_flag, outc.generate_public_callback, outc.generate_private_callback, outc.versatility_code, outc.positive_outcome_flag, rea.active, res.active, outc.active, wrp.wrap_up_level from jtf_ih_wrap_ups wrp, jtf_ih_outcomes_vl outc, jtf_ih_results_vl res, jtf_ih_reasons_vl rea WHERE wrp.outcome_id = outc.outcome_id and wrp.reason_id = rea.reason_id (+) and wrp.result_id = res.result_id (+)

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
, OUTC.RESULT_REQUIRED
, RES.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
, OUTC.SHORT_DESCRIPTION
, RES.SHORT_DESCRIPTION
, REA.SHORT_DESCRIPTION
, REA.GENERATE_PUBLIC_CALLBACK
, REA.GENERATE_PRIVATE_CALLBACK
, REA.VERSATILITY_CODE
, RES.GENERATE_PUBLIC_CALLBACK
, RES.GENERATE_PRIVATE_CALLBACK
, RES.VERSATILITY_CODE
, RES.POSITIVE_RESPONSE_FLAG
, OUTC.GENERATE_PUBLIC_CALLBACK
, OUTC.GENERATE_PRIVATE_CALLBACK
, OUTC.VERSATILITY_CODE
, OUTC.POSITIVE_OUTCOME_FLAG
, REA.ACTIVE
, RES.ACTIVE
, OUTC.ACTIVE
, WRP.WRAP_UP_LEVEL
FROM JTF_IH_WRAP_UPS WRP
, JTF_IH_OUTCOMES_VL OUTC
, JTF_IH_RESULTS_VL RES
, JTF_IH_REASONS_VL REA
WHERE WRP.OUTCOME_ID = OUTC.OUTCOME_ID
AND WRP.REASON_ID = REA.REASON_ID (+)
AND WRP.RESULT_ID = RES.RESULT_ID (+)