VIEW: APPS.OE_PC_RSETS_VL

Source

View Text - Preformatted

SELECT r.rowid row_id ,r.record_set_id ,r.entity_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 WHERE r.record_set_id = tl.record_set_id and tl.language = USERENV('LANG')

View Text - HTML Formatted

SELECT R.ROWID ROW_ID
, R.RECORD_SET_ID
, R.ENTITY_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
WHERE R.RECORD_SET_ID = TL.RECORD_SET_ID
AND TL.LANGUAGE = USERENV('LANG')