FND Design Data [Home] [Help]

View: GMO_INSTR_TASK_ATTR_COLS_VL

Product: GMO - Manufacturing Execution System for Process Manufacturing
Description: View on GMO_INSTR_TASK_ATTR_COLS Base and Translation Table
Implementation/DBA Data: ViewAPPS.GMO_INSTR_TASK_ATTR_COLS_VL
View Text

SELECT B.ROWID ROW_ID
, B.LAST_UPDATE_LOGIN
, B.TASK_NAME
, B.COLUMN_NO
, B.ATTR_COL_SEQ
, B.ENTITY_NAME
, T.COLUMN_HEADING
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
FROM GMO_INSTR_TASK_ATTR_COLS_TL T
, GMO_INSTR_TASK_ATTR_COLS_B B
WHERE B.ATTR_COL_SEQ = T.ATTR_COL_SEQ
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
LAST_UPDATE_LOGIN
TASK_NAME
COLUMN_NO
ATTR_COL_SEQ
ENTITY_NAME
COLUMN_HEADING
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY