VIEW: APPS.FEM_DSNP_SIC_ATTR_V

Source

View Text - Preformatted

SELECT CREATED_BY_OBJECT_ID ,ATTRIBUTE_ID ,VERSION_ID ,SIC_ID,DIM_ATTRIBUTE_NUMERIC_MEMBER,DIM_ATTRIBUTE_VALUE_SET_ID,DIM_ATTRIBUTE_VARCHAR_MEMBER,NUMBER_ASSIGN_VALUE,VARCHAR_ASSIGN_VALUE,DATE_ASSIGN_VALUE,'Y' READ_ONLY_FLAG,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN from FEM_DSNP_SIC_ATTR union all select 0 ,A.ATTRIBUTE_ID ,A.VERSION_ID ,A.SIC_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.READ_ONLY_FLAG,A.CREATION_DATE,A.CREATED_BY,A.LAST_UPDATED_BY,A.LAST_UPDATE_DATE,A.LAST_UPDATE_LOGIN from FEM_SIC_ATTR A,FEM_SIC_B B where A.SIC_ID=B.SIC_ID and B.personal_flag = 'Y'

View Text - HTML Formatted

SELECT CREATED_BY_OBJECT_ID
, ATTRIBUTE_ID
, VERSION_ID
, SIC_ID
, DIM_ATTRIBUTE_NUMERIC_MEMBER
, DIM_ATTRIBUTE_VALUE_SET_ID
, DIM_ATTRIBUTE_VARCHAR_MEMBER
, NUMBER_ASSIGN_VALUE
, VARCHAR_ASSIGN_VALUE
, DATE_ASSIGN_VALUE
, 'Y' READ_ONLY_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM FEM_DSNP_SIC_ATTR UNION ALL SELECT 0
, A.ATTRIBUTE_ID
, A.VERSION_ID
, A.SIC_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.READ_ONLY_FLAG
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
FROM FEM_SIC_ATTR A
, FEM_SIC_B B
WHERE A.SIC_ID=B.SIC_ID
AND B.PERSONAL_FLAG = 'Y'