eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: GMO_INSTR_TASK_DEFN_VL

Product:	GMO - Manufacturing Execution System for Process Manufacturing
Description:	Task View definined on GMO_INSTR_TASK_DEFN Base and Translation Tables
Implementation/DBA Data:	APPS.GMO_INSTR_TASK_DEFN_VL

View Text

SELECT B.ROWID ROW_ID
, B.TASK_ID
, B.ENTITY_NAME
, B.INSTRUCTION_TYPE
, B.TASK_NAME
, B.TASK_TYPE
, B.TARGET
, B.ATTRIBUTE_SQL
, B.ATTRIBUTE_DISPLAY_COL_COUNT
, B.ENTITY_KEY_PATTERN
, B.MAX_ALLOWED_TASK
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, T.DISPLAY_NAME
FROM GMO_INSTR_TASK_DEFN_TL T
, GMO_INSTR_TASK_DEFN_B B
WHERE B.TASK_ID = T.TASK_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
TASK_ID
ENTITY_NAME
INSTRUCTION_TYPE
TASK_NAME
TASK_TYPE
TARGET
ATTRIBUTE_SQL
ATTRIBUTE_DISPLAY_COL_COUNT
ENTITY_KEY_PATTERN
MAX_ALLOWED_TASK
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
DISPLAY_NAME