VIEW: APPS.JTF_IH_ACTION_ACTION_ITEMS_VL

Source

View Text - Preformatted

SELECT aai.action_item_id, aai.action_id, aw.outcome_id, aw.result_id, aw.reason_id, aai.default_wrap_id, ai.short_description, a.short_description, aw.outcome_short_desc, aw.result_short_desc, aw.reason_short_desc, a.active, ai.active, aai.object_version_number, aai.created_by, aai.creation_date, aai.last_updated_by, aai.last_update_date, aai.last_update_login, aw.start_date, aw.end_date from jtf_ih_action_action_items aai, jtf_ih_action_items_vl ai, jtf_ih_actions_vl a, jtf_ih_wrap_ups_vl aw WHERE aai.action_id=a.action_id and aai.action_item_id=ai.action_item_id and aai.default_wrap_id=aw.wrap_id(+)

View Text - HTML Formatted

SELECT AAI.ACTION_ITEM_ID
, AAI.ACTION_ID
, AW.OUTCOME_ID
, AW.RESULT_ID
, AW.REASON_ID
, AAI.DEFAULT_WRAP_ID
, AI.SHORT_DESCRIPTION
, A.SHORT_DESCRIPTION
, AW.OUTCOME_SHORT_DESC
, AW.RESULT_SHORT_DESC
, AW.REASON_SHORT_DESC
, A.ACTIVE
, AI.ACTIVE
, AAI.OBJECT_VERSION_NUMBER
, AAI.CREATED_BY
, AAI.CREATION_DATE
, AAI.LAST_UPDATED_BY
, AAI.LAST_UPDATE_DATE
, AAI.LAST_UPDATE_LOGIN
, AW.START_DATE
, AW.END_DATE
FROM JTF_IH_ACTION_ACTION_ITEMS AAI
, JTF_IH_ACTION_ITEMS_VL AI
, JTF_IH_ACTIONS_VL A
, JTF_IH_WRAP_UPS_VL AW
WHERE AAI.ACTION_ID=A.ACTION_ID
AND AAI.ACTION_ITEM_ID=AI.ACTION_ITEM_ID
AND AAI.DEFAULT_WRAP_ID=AW.WRAP_ID(+)