VIEW: APPS.FEM_CCTR_ORGS_ATTR_VS

Source

View Text - Preformatted

SELECT A.ATTRIBUTE_ID, A.VERSION_ID, A.COMPANY_COST_CENTER_ORG_ID, A.DIM_ATTRIBUTE_NUMERIC_MEMBER, A.DIM_ATTRIBUTE_VALUE_SET_ID, A.DIM_ATTRIBUTE_VARCHAR_MEMBER, A.NUMBER_ASSIGN_VALUE, A.VARCHAR_ASSIGN_VALUE, A.DATE_ASSIGN_VALUE, A.creation_date, A.created_by, A.last_updated_by, A.last_update_date, A.last_update_login, A.object_version_number FROM FEM_CCTR_ORGS_attr A, FEM_DIMENSIONS_B D WHERE VALUE_SET_ID = fem_dimension_util_pkg.dimension_value_set_id(D.dimension_id) AND D.dimension_varchar_label = 'COMPANY_COST_CENTER_ORG'

View Text - HTML Formatted

SELECT A.ATTRIBUTE_ID
, A.VERSION_ID
, A.COMPANY_COST_CENTER_ORG_ID
, A.DIM_ATTRIBUTE_NUMERIC_MEMBER
, A.DIM_ATTRIBUTE_VALUE_SET_ID
, A.DIM_ATTRIBUTE_VARCHAR_MEMBER
, A.NUMBER_ASSIGN_VALUE
, A.VARCHAR_ASSIGN_VALUE
, A.DATE_ASSIGN_VALUE
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, A.OBJECT_VERSION_NUMBER
FROM FEM_CCTR_ORGS_ATTR A
, FEM_DIMENSIONS_B D
WHERE VALUE_SET_ID = FEM_DIMENSION_UTIL_PKG.DIMENSION_VALUE_SET_ID(D.DIMENSION_ID)
AND D.DIMENSION_VARCHAR_LABEL = 'COMPANY_COST_CENTER_ORG'