VIEW: APPS.FEM_COL_POPULATION_TMPLT_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.COL_POP_TEMPLT_OBJ_DEF_ID, B.TARGET_TABLE_NAME, B.TARGET_COLUMN_NAME, B.DATA_POPULATION_METHOD_CODE, B.SOURCE_TABLE_NAME, B.SOURCE_COLUMN_NAME, B.DIMENSION_ID, B.ATTRIBUTE_ID, B.ATTRIBUTE_VERSION_ID, B.AGGREGATION_METHOD, B.CONSTANT_NUMERIC_VALUE, B.CONSTANT_ALPHANUMERIC_VALUE, B.CONSTANT_DATE_VALUE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.SYSTEM_RESERVED_FLAG, T.DESCRIPTION, B.ENG_PROC_PARAM, B.PARAMETER_FLAG FROM FEM_COL_POPULATION_TMPLT_TL T,FEM_COL_POPULATION_TMPLT_B B WHERE B.TARGET_COLUMN_NAME = T.TARGET_COLUMN_NAME and B.TARGET_TABLE_NAME = T.TARGET_TABLE_NAME and B.SOURCE_TABLE_NAME = T.SOURCE_TABLE_NAME and B.COL_POP_TEMPLT_OBJ_DEF_ID=T.COL_POP_TEMPLT_OBJ_DEF_ID and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.COL_POP_TEMPLT_OBJ_DEF_ID
, B.TARGET_TABLE_NAME
, B.TARGET_COLUMN_NAME
, B.DATA_POPULATION_METHOD_CODE
, B.SOURCE_TABLE_NAME
, B.SOURCE_COLUMN_NAME
, B.DIMENSION_ID
, B.ATTRIBUTE_ID
, B.ATTRIBUTE_VERSION_ID
, B.AGGREGATION_METHOD
, B.CONSTANT_NUMERIC_VALUE
, B.CONSTANT_ALPHANUMERIC_VALUE
, B.CONSTANT_DATE_VALUE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.SYSTEM_RESERVED_FLAG
, T.DESCRIPTION
, B.ENG_PROC_PARAM
, B.PARAMETER_FLAG
FROM FEM_COL_POPULATION_TMPLT_TL T
, FEM_COL_POPULATION_TMPLT_B B
WHERE B.TARGET_COLUMN_NAME = T.TARGET_COLUMN_NAME
AND B.TARGET_TABLE_NAME = T.TARGET_TABLE_NAME
AND B.SOURCE_TABLE_NAME = T.SOURCE_TABLE_NAME
AND B.COL_POP_TEMPLT_OBJ_DEF_ID=T.COL_POP_TEMPLT_OBJ_DEF_ID
AND T.LANGUAGE = USERENV('LANG')