VIEW: APPS.OE_PC_RSETS_V

Source

View Text - Preformatted

SELECT r.rowid row_id ,r.record_set_id ,r.entity_id ,e.entity_short_name ,e.entity_display_name ,e.db_object_name ,e.db_object_type ,e.application_id ,r.record_set_short_name ,r.pk_record_set_flag ,tl.display_name record_set_display_name ,tl.description record_set_description ,r.system_flag ,r.created_by ,r.creation_date ,r.last_updated_by ,r.last_update_date ,r.last_update_login ,r.attribute_category ,r.attribute1 ,r.attribute2 ,r.attribute3 ,r.attribute4 ,r.attribute5 ,r.attribute6 ,r.attribute7 ,r.attribute8 ,r.attribute9 ,r.attribute10 ,r.attribute11 ,r.attribute12 ,r.attribute13 ,r.attribute14 ,r.attribute15 FROM OE_PC_RSETS r, OE_PC_RSETS_TL tl, OE_PC_ENTITIES_V e WHERE r.record_set_id = tl.record_set_id and tl.language = USERENV('LANG') AND r.entity_id = e.entity_id

View Text - HTML Formatted

SELECT R.ROWID ROW_ID
, R.RECORD_SET_ID
, R.ENTITY_ID
, E.ENTITY_SHORT_NAME
, E.ENTITY_DISPLAY_NAME
, E.DB_OBJECT_NAME
, E.DB_OBJECT_TYPE
, E.APPLICATION_ID
, R.RECORD_SET_SHORT_NAME
, R.PK_RECORD_SET_FLAG
, TL.DISPLAY_NAME RECORD_SET_DISPLAY_NAME
, TL.DESCRIPTION RECORD_SET_DESCRIPTION
, R.SYSTEM_FLAG
, R.CREATED_BY
, R.CREATION_DATE
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_DATE
, R.LAST_UPDATE_LOGIN
, R.ATTRIBUTE_CATEGORY
, R.ATTRIBUTE1
, R.ATTRIBUTE2
, R.ATTRIBUTE3
, R.ATTRIBUTE4
, R.ATTRIBUTE5
, R.ATTRIBUTE6
, R.ATTRIBUTE7
, R.ATTRIBUTE8
, R.ATTRIBUTE9
, R.ATTRIBUTE10
, R.ATTRIBUTE11
, R.ATTRIBUTE12
, R.ATTRIBUTE13
, R.ATTRIBUTE14
, R.ATTRIBUTE15
FROM OE_PC_RSETS R
, OE_PC_RSETS_TL TL
, OE_PC_ENTITIES_V E
WHERE R.RECORD_SET_ID = TL.RECORD_SET_ID
AND TL.LANGUAGE = USERENV('LANG')
AND R.ENTITY_ID = E.ENTITY_ID