View: OE_PC_RSETS_V

Product:	ONT - Order Management
Description:	This view stores the processing constraints record sets.
Implementation/DBA Data:	APPS.OE_PC_RSETS_V

View Text

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

Columns