CN_CREDIT_TYPES_ALL_VL

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name
ORG_ID CREDIT_TYPE_ID CREDIT_TYPE_NAME DESCRIPTION ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER MONETARY_FLAG PRECISION EXTENDED_PRECISION

Query

SQL_Statement

SELECT B.ORG_ID , B.credit_TYPE_ID , T.credit_type_NAME , T.DESCRIPTION , B.ATTRIBUTE_CATEGORY , B.ATTRIBUTE1 , 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.CREATED_BY , B.CREATION_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_DATE , B.LAST_UPDATE_LOGIN ,B.OBJECT_VERSION_NUMBER , B.MONETARY_FLAG, PRECISION, EXTENDED_PRECISION FROM CN_credit_TYPES_ALL_B B, CN_credit_TYPES_ALL_TL T WHERE B.credit_TYPE_ID = T.credit_TYPE_ID AND NVL(B.ORG_ID, -99) = NVL(T.ORG_ID, -99) AND T.LANGUAGE = userenv('LANG')