VIEW: APPS.IGS_SC_OBJ_ATTR_MTHS_V

Source

View Text - Preformatted

SELECT at.OBJ_GROUP_ID , tb.OBJECT_ID , at.OBJ_ATTRIB_ID , at.OBJ_ATTRIB_NAME , mt.OBJ_ATTRIB_TYPE , mt.STATIC_TYPE , mt.NULL_ALLOW_FLAG, mt. SELECT_TEXT , at.CREATION_DATE , at.CREATED_BY , at.LAST_UPDATED_BY , at.LAST_UPDATE_DATE , at.LAST_UPDATE_LOGIN FROM igs_sc_obj_att_mths mt, igs_sc_obj_attribs at, igs_sc_objects tb WHERE tb.OBJECT_ID (+) = mt.OBJECT_ID AND tb.OBJ_GROUP_ID = at.OBJ_GROUP_ID AND at.OBJ_ATTRIB_ID (+)= mt.OBJ_ATTRIB_ID UNION SELECT at.OBJ_GROUP_ID , tb.OBJECT_ID , at.OBJ_ATTRIB_ID , at.OBJ_ATTRIB_NAME , '' , '' , 'N', '' , at.CREATION_DATE , at.CREATED_BY , at.LAST_UPDATED_BY , at.LAST_UPDATE_DATE , at.LAST_UPDATE_LOGIN FROM igs_sc_obj_attribs at, igs_sc_objects tb WHERE tb.OBJ_GROUP_ID = at.OBJ_GROUP_ID AND at.OBJ_ATTRIB_ID NOT IN ( SELECT at.OBJ_ATTRIB_ID FROM igs_sc_obj_att_mths mt WHERE at.OBJ_ATTRIB_ID = mt.OBJ_ATTRIB_ID AND mt.OBJECT_ID = tb.OBJECT_ID )

View Text - HTML Formatted

SELECT AT.OBJ_GROUP_ID
, TB.OBJECT_ID
, AT.OBJ_ATTRIB_ID
, AT.OBJ_ATTRIB_NAME
, MT.OBJ_ATTRIB_TYPE
, MT.STATIC_TYPE
, MT.NULL_ALLOW_FLAG
, MT. SELECT_TEXT
, AT.CREATION_DATE
, AT.CREATED_BY
, AT.LAST_UPDATED_BY
, AT.LAST_UPDATE_DATE
, AT.LAST_UPDATE_LOGIN
FROM IGS_SC_OBJ_ATT_MTHS MT
, IGS_SC_OBJ_ATTRIBS AT
, IGS_SC_OBJECTS TB
WHERE TB.OBJECT_ID (+) = MT.OBJECT_ID
AND TB.OBJ_GROUP_ID = AT.OBJ_GROUP_ID
AND AT.OBJ_ATTRIB_ID (+)= MT.OBJ_ATTRIB_ID UNION SELECT AT.OBJ_GROUP_ID
, TB.OBJECT_ID
, AT.OBJ_ATTRIB_ID
, AT.OBJ_ATTRIB_NAME
, ''
, ''
, 'N'
, ''
, AT.CREATION_DATE
, AT.CREATED_BY
, AT.LAST_UPDATED_BY
, AT.LAST_UPDATE_DATE
, AT.LAST_UPDATE_LOGIN
FROM IGS_SC_OBJ_ATTRIBS AT
, IGS_SC_OBJECTS TB
WHERE TB.OBJ_GROUP_ID = AT.OBJ_GROUP_ID
AND AT.OBJ_ATTRIB_ID NOT IN ( SELECT AT.OBJ_ATTRIB_ID
FROM IGS_SC_OBJ_ATT_MTHS MT
WHERE AT.OBJ_ATTRIB_ID = MT.OBJ_ATTRIB_ID
AND MT.OBJECT_ID = TB.OBJECT_ID )