VIEW: APPS.IEX_CHECKLIST_ITEMS_VL

Source

View Text - Preformatted

SELECT B.CHECKLIST_ITEM_ID CHECKLIST_ITEM_ID, B.CHECKLIST_ITEM_NAME CHECKLIST_ITEM_NAME, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.STATUS STATUS, /* IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_CHECKLIST_STATUS',B.STATUS) STATUS_MEANING */ LK.MEANING STATUS_MEANING, B.MANDATORY_FLAG MANDATORY_FLAG, B.START_DATE_ACTIVE START_DATE_ACTIVE, B.END_DATE_ACTIVE END_DATE_ACTIVE, B.CHECKLIST_PARENT_ITEM_ID CHECKLIST_PARENT_ITEM_ID, T.CHECKLIST_ITEM_TEXT CHECKLIST_ITEM_TEXT, T.DESCRIPTION DESCRIPTION, B.TASK_LINK TASK_LINK, B.QUESTIONNAIRE_LINK QUESTIONNAIRE_LINK, B.CHECKLIST_ITEM_TYPE CHECKLIST_ITEM_TYPE, B.TASK_LAST_MODIFIED_DATE TASK_LAST_MODIFIED_DATE, B.VIEW_LINK VIEW_LINK FROM IEX_CHECKLIST_ITEMS_TL T, IEX_CHECKLIST_ITEMS_B B, IEX_LOOKUPS_V lk WHERE B.CHECKLIST_ITEM_ID = T.CHECKLIST_ITEM_ID AND T.LANGUAGE = USERENV('LANG') AND B.STATUS = LK.LOOKUP_CODE(+) AND LK.LOOKUP_TYPE(+) = 'IEX_CHECKLIST_STATUS'

View Text - HTML Formatted

SELECT B.CHECKLIST_ITEM_ID CHECKLIST_ITEM_ID
, B.CHECKLIST_ITEM_NAME CHECKLIST_ITEM_NAME
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.STATUS STATUS
, /* IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_CHECKLIST_STATUS'
, B.STATUS) STATUS_MEANING */ LK.MEANING STATUS_MEANING
, B.MANDATORY_FLAG MANDATORY_FLAG
, B.START_DATE_ACTIVE START_DATE_ACTIVE
, B.END_DATE_ACTIVE END_DATE_ACTIVE
, B.CHECKLIST_PARENT_ITEM_ID CHECKLIST_PARENT_ITEM_ID
, T.CHECKLIST_ITEM_TEXT CHECKLIST_ITEM_TEXT
, T.DESCRIPTION DESCRIPTION
, B.TASK_LINK TASK_LINK
, B.QUESTIONNAIRE_LINK QUESTIONNAIRE_LINK
, B.CHECKLIST_ITEM_TYPE CHECKLIST_ITEM_TYPE
, B.TASK_LAST_MODIFIED_DATE TASK_LAST_MODIFIED_DATE
, B.VIEW_LINK VIEW_LINK
FROM IEX_CHECKLIST_ITEMS_TL T
, IEX_CHECKLIST_ITEMS_B B
, IEX_LOOKUPS_V LK
WHERE B.CHECKLIST_ITEM_ID = T.CHECKLIST_ITEM_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.STATUS = LK.LOOKUP_CODE(+)
AND LK.LOOKUP_TYPE(+) = 'IEX_CHECKLIST_STATUS'