View: GL_LEDGER_NORM_MSVS_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_LEDGER_NORM_MSVS_V

View Text

SELECT LSV.ROWID ROW_ID
, LSV.LEDGER_ID LEDGER_ID
, LSV.SEGMENT_VALUE SEGMENT_VALUE
, LSV.SEGMENT_VALUE_TYPE_CODE SEGMENT_VALUE_TYPE_CODE
, LSV.STATUS_CODE STATUS_CODE
, LSV.RECORD_ID RECORD_ID
, LSV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LSV.LAST_UPDATED_BY LAST_UPDATED_BY
, LSV.CREATION_DATE CREATION_DATE
, LSV.CREATED_BY CREATED_BY
, LSV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LSV.START_DATE START_DATE
, LSV.END_DATE END_DATE
, LSV.CONTEXT CONTEXT
, LSV.ATTRIBUTE1 ATTRIBUTE1
, LSV.ATTRIBUTE2 ATTRIBUTE2
, LSV.ATTRIBUTE3 ATTRIBUTE3
, LSV.ATTRIBUTE4 ATTRIBUTE4
, LSV.ATTRIBUTE5 ATTRIBUTE5
, LSV.ATTRIBUTE6 ATTRIBUTE6
, LSV.ATTRIBUTE7 ATTRIBUTE7
, LSV.ATTRIBUTE8 ATTRIBUTE8
, LSV.ATTRIBUTE9 ATTRIBUTE9
, LSV.ATTRIBUTE10 ATTRIBUTE10
, LSV.ATTRIBUTE11 ATTRIBUTE11
, LSV.ATTRIBUTE12 ATTRIBUTE12
, LSV.ATTRIBUTE13 ATTRIBUTE13
, LSV.ATTRIBUTE14 ATTRIBUTE14
, LSV.ATTRIBUTE15 ATTRIBUTE15
, LSV.REQUEST_ID REQUEST_ID
FROM GL_LEDGER_NORM_SEG_VALS LSV
WHERE NVL(LSV.STATUS_CODE
, 'X') <> 'D'
AND LSV.SEGMENT_TYPE_CODE = 'M' ORDER BY LSV.SEGMENT_VALUE

Columns