ACA_CS_CLASS_VL

Details

• Schema: FUSION

• Object owner: ACA

• Object type: VIEW

Columns

Name
CLASS_ID OBJECT_VERSION_NUMBER CLASS_FAMILY_CODE CLASS_CODE CLASS_NAME CLASS_SUB_FAMILY_CODE DELETED_FLAG DISABLE_DATE OBJECT_CREATION_ALLOWED_FLAG NUMBER_GENERATION_METHOD TRACK_HISTORY_FLAG PARENT_CLASS_ID PRODUCT_OWNED CLASS_POLICY DESCRIPTION BIP_TEMPLATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.CLASS_ID CLASS_ID, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.CLASS_FAMILY_CODE CLASS_FAMILY_CODE, B.CLASS_CODE CLASS_CODE, TL.CLASS_NAME CLASS_NAME, B.CLASS_SUB_FAMILY_CODE CLASS_SUB_FAMILY_CODE, B.DELETED_FLAG DELETED_FLAG, B.DISABLE_DATE DISABLE_DATE, B.OBJECT_CREATION_ALLOWED_FLAG OBJECT_CREATION_ALLOWED_FLAG, B.NUMBER_GENERATION_METHOD NUMBER_GENERATION_METHOD, B.TRACK_HISTORY_FLAG TRACK_HISTORY_FLAG, B.PARENT_CLASS_ID PARENT_CLASS_ID, B.PRODUCT_OWNED PRODUCT_OWNED, B.CLASS_POLICY CLASS_POLICY, TL.DESCRIPTION DESCRIPTION, B.BIP_TEMPLATE BIP_TEMPLATE, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM ACA_CS_CLASS_B B, ACA_CS_CLASS_TL TL WHERE B.CLASS_ID = TL.CLASS_ID AND TL.LANGUAGE = USERENV('LANG')