VIEW: APPS.ASO_QUOTE_STATUSES_VL

Source

View Text - Preformatted

SELECT B.ROWID , B.QUOTE_STATUS_ID , B.CREATION_DATE , b.CREATED_BY , b.LAST_UPDATED_BY , b.LAST_UPDATE_DATE , b.LAST_UPDATE_LOGIN , b.REQUEST_ID , b.PROGRAM_APPLICATION_ID , b.PROGRAM_ID , b.PROGRAM_UPDATE_DATE , b.STATUS_CODE , t.meaning , t.description , b.UPDATE_ALLOWED_FLAG , b.auto_version_flag , b.user_maintainable_flag , b.effective_start_date , b.effective_end_date , b.ATTRIBUTE_CATEGORY , b.ALLOW_LOV_TO_FLAG , b.ALLOW_LOV_FROM_FLAG , b.ATTRIBUTE1 , b.ALLOW_NEW_TO_FLAG , b.ALLOW_NEW_FROM_FLAG , b.seed_tag , b.enabled_flag , b.ATTRIBUTE2 , b.ATTRIBUTE3 , b.ATTRIBUTE4 , b.ATTRIBUTE5 , b.ATTRIBUTE6 , b.ATTRIBUTE7 , b.ATTRIBUTE8 , b.ATTRIBUTE9 , b.ATTRIBUTE10 , b.ATTRIBUTE11 , b.ATTRIBUTE12 , b.ATTRIBUTE13 , b.ATTRIBUTE14 , b.ATTRIBUTE15 , b.ATTRIBUTE16 , b.ATTRIBUTE17, b.ATTRIBUTE18 , b.ATTRIBUTE19, b.ATTRIBUTE20 FROM ASO_QUOTE_STATUSES_B B, ASO_QUOTE_STATUSES_TL T WHERE b.quote_status_id = t.quote_status_id and t.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID
, B.QUOTE_STATUS_ID
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.REQUEST_ID
, B.PROGRAM_APPLICATION_ID
, B.PROGRAM_ID
, B.PROGRAM_UPDATE_DATE
, B.STATUS_CODE
, T.MEANING
, T.DESCRIPTION
, B.UPDATE_ALLOWED_FLAG
, B.AUTO_VERSION_FLAG
, B.USER_MAINTAINABLE_FLAG
, B.EFFECTIVE_START_DATE
, B.EFFECTIVE_END_DATE
, B.ATTRIBUTE_CATEGORY
, B.ALLOW_LOV_TO_FLAG
, B.ALLOW_LOV_FROM_FLAG
, B.ATTRIBUTE1
, B.ALLOW_NEW_TO_FLAG
, B.ALLOW_NEW_FROM_FLAG
, B.SEED_TAG
, B.ENABLED_FLAG
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.ATTRIBUTE16
, B.ATTRIBUTE17
, B.ATTRIBUTE18
, B.ATTRIBUTE19
, B.ATTRIBUTE20
FROM ASO_QUOTE_STATUSES_B B
, ASO_QUOTE_STATUSES_TL T
WHERE B.QUOTE_STATUS_ID = T.QUOTE_STATUS_ID
AND T.LANGUAGE = USERENV('LANG')