VIEW: APPS.FEM_TAB_COL_PROP_ATTRB_V

Source

View Text - Preformatted

SELECT c.table_name, c.column_name, c.display_name, p.column_property_code, r.display_seq, c.dimension_id, d.member_vl_object_name, d.member_col, d.member_name_col, d.hierarchy_table_name FROM fem_tab_columns_v c, fem_tab_column_prop p, fem_column_requiremnt_b r, fem_xdim_dimensions d WHERE p.table_name = c.table_name AND p.column_name = c.column_name AND p.column_name = r.column_name AND c.dimension_id = d.dimension_id(+)

View Text - HTML Formatted

SELECT C.TABLE_NAME
, C.COLUMN_NAME
, C.DISPLAY_NAME
, P.COLUMN_PROPERTY_CODE
, R.DISPLAY_SEQ
, C.DIMENSION_ID
, D.MEMBER_VL_OBJECT_NAME
, D.MEMBER_COL
, D.MEMBER_NAME_COL
, D.HIERARCHY_TABLE_NAME
FROM FEM_TAB_COLUMNS_V C
, FEM_TAB_COLUMN_PROP P
, FEM_COLUMN_REQUIREMNT_B R
, FEM_XDIM_DIMENSIONS D
WHERE P.TABLE_NAME = C.TABLE_NAME
AND P.COLUMN_NAME = C.COLUMN_NAME
AND P.COLUMN_NAME = R.COLUMN_NAME
AND C.DIMENSION_ID = D.DIMENSION_ID(+)