VIEW: APPS.IBY_F_CRDT_APP_STATUS_VL

Source

View Text - Preformatted

SELECT STB.ROWID ROW_ID, STB.CREDIT_APP_STATUS_ID, STB.OBJECT_VERSION_NUMBER, STB.CREATED_BY, STB.CREATION_DATE, STB.LAST_UPDATED_BY, STB.LAST_UPDATE_DATE, STB.LAST_UPDATE_LOGIN, STTL.NAME, STTL.DESCRIPTION, STTL.CUST_FACING_NAME, STB.STATUS_CODE, STB.START_DATE_ACTIVE, STB.END_DATE_ACTIVE, STB.UPDATE_ALLOWED_FLAG, STB.SEEDED_FLAG, STB.STATUS_CATEGORY_CODE, STB.STATUS_NUMBER, STB.SECURITY_GROUP_ID, STB.ATTRIBUTE_CATEGORY, STB.ATTRIBUTE1, STB.ATTRIBUTE2, STB.ATTRIBUTE3, STB.ATTRIBUTE4, STB.ATTRIBUTE5, STB.ATTRIBUTE6, STB.ATTRIBUTE7, STB.ATTRIBUTE8, STB.ATTRIBUTE9, STB.ATTRIBUTE10, STB.ATTRIBUTE11, STB.ATTRIBUTE12, STB.ATTRIBUTE13, STB.ATTRIBUTE14, STB.ATTRIBUTE15 FROM IBY_F_CRDT_APP_STATUS_B STB, IBY_F_CRDT_APP_STATUS_TL STTL WHERE STB.CREDIT_APP_STATUS_ID = STTL.CREDIT_APP_STATUS_ID AND STTL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT STB.ROWID ROW_ID
, STB.CREDIT_APP_STATUS_ID
, STB.OBJECT_VERSION_NUMBER
, STB.CREATED_BY
, STB.CREATION_DATE
, STB.LAST_UPDATED_BY
, STB.LAST_UPDATE_DATE
, STB.LAST_UPDATE_LOGIN
, STTL.NAME
, STTL.DESCRIPTION
, STTL.CUST_FACING_NAME
, STB.STATUS_CODE
, STB.START_DATE_ACTIVE
, STB.END_DATE_ACTIVE
, STB.UPDATE_ALLOWED_FLAG
, STB.SEEDED_FLAG
, STB.STATUS_CATEGORY_CODE
, STB.STATUS_NUMBER
, STB.SECURITY_GROUP_ID
, STB.ATTRIBUTE_CATEGORY
, STB.ATTRIBUTE1
, STB.ATTRIBUTE2
, STB.ATTRIBUTE3
, STB.ATTRIBUTE4
, STB.ATTRIBUTE5
, STB.ATTRIBUTE6
, STB.ATTRIBUTE7
, STB.ATTRIBUTE8
, STB.ATTRIBUTE9
, STB.ATTRIBUTE10
, STB.ATTRIBUTE11
, STB.ATTRIBUTE12
, STB.ATTRIBUTE13
, STB.ATTRIBUTE14
, STB.ATTRIBUTE15
FROM IBY_F_CRDT_APP_STATUS_B STB
, IBY_F_CRDT_APP_STATUS_TL STTL
WHERE STB.CREDIT_APP_STATUS_ID = STTL.CREDIT_APP_STATUS_ID
AND STTL.LANGUAGE = USERENV('LANG')