VIEW: APPS.FEM_COLUMN_REQUIREMNT_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.OBJECT_VERSION_NUMBER, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.LAST_UPDATED_BY, B.ACTIVITY_DIM_COMPONENT_FLAG, B.COST_OBJ_DIM_REQUIREMENT_CODE, B.COST_OBJ_DIM_COMPONENT_FLAG, B.DATA_LENGTH, B.DATA_SCALE, B.DATA_PRECISION, B.UOM_COLUMN_NAME, B.DIMENSION_ID, B.CREATION_DATE, B.CREATED_BY, B.COLUMN_NAME, B.FEM_DATA_TYPE_CODE, B.DATA_TYPE, B.PROCESS_KEY_CANDIDATE_FLG, B.PROCESS_KEY_COL_ID, B.DISPLAY_SEQ, B.RESTRICTED_FLAG, B.ACTIVITY_DIM_REQUIREMENT_CODE, T.DISPLAY_NAME, T.DESCRIPTION from FEM_COLUMN_REQUIREMNT_TL T, FEM_COLUMN_REQUIREMNT_B B WHERE B.COLUMN_NAME = T.COLUMN_NAME and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.OBJECT_VERSION_NUMBER
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.LAST_UPDATED_BY
, B.ACTIVITY_DIM_COMPONENT_FLAG
, B.COST_OBJ_DIM_REQUIREMENT_CODE
, B.COST_OBJ_DIM_COMPONENT_FLAG
, B.DATA_LENGTH
, B.DATA_SCALE
, B.DATA_PRECISION
, B.UOM_COLUMN_NAME
, B.DIMENSION_ID
, B.CREATION_DATE
, B.CREATED_BY
, B.COLUMN_NAME
, B.FEM_DATA_TYPE_CODE
, B.DATA_TYPE
, B.PROCESS_KEY_CANDIDATE_FLG
, B.PROCESS_KEY_COL_ID
, B.DISPLAY_SEQ
, B.RESTRICTED_FLAG
, B.ACTIVITY_DIM_REQUIREMENT_CODE
, T.DISPLAY_NAME
, T.DESCRIPTION
FROM FEM_COLUMN_REQUIREMNT_TL T
, FEM_COLUMN_REQUIREMNT_B B
WHERE B.COLUMN_NAME = T.COLUMN_NAME
AND T.LANGUAGE = USERENV('LANG')