CN_TP_PROCESS_CODES_VL
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: VIEW
Columns
Name |
---|
PROCESS_CODE NAME DESCRIPTION ENABLED_FLAG CLASSIFICATION_FLAG CREDIT_FLAG ROLLUP_FLAG ELIGIBLE_FLAG CALCULATE_FLAG 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 MODULE_ID |
Query
SQL_Statement |
---|
Select B.PROCESS_CODE ,TL.NAME ,TL.DESCRIPTION ,B.ENABLED_FLAG ,B.CLASSIFICATION_FLAG ,B.CREDIT_FLAG ,B.ROLLUP_FLAG ,B.ELIGIBLE_FLAG ,B.CALCULATE_FLAG ,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.MODULE_ID FROM CN_TP_PROCESS_CODES_B B, CN_TP_PROCESS_CODES_TL TL WHERE B.PROCESS_CODE = TL.PROCESS_CODE AND TL.LANGUAGE = USERENV('LANG') |