ACA_AUTO_SEQ_METADATA_VL

Details

• Schema: FUSION

• Object owner: ACA

• Object type: VIEW

Columns

Name
AUTO_SEQ_METADATA_ID OBJECT_VERSION_NUMBER AUTO_SEQ_CLASS_ID AUTO_SEQ_CODE STARTING_NUMBER INCREMENT_BY PREFIX SUFFIX MAXIMUM_ATTEMPTS IS_SEEDED DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.AUTO_SEQ_METADATA_ID AUTO_SEQ_METADATA_ID, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.AUTO_SEQ_CLASS_ID AUTO_SEQ_CLASS_ID, B.AUTO_SEQ_CODE AUTO_SEQ_CODE, B.STARTING_NUMBER STARTING_NUMBER, B.INCREMENT_BY INCREMENT_BY, B.PREFIX PREFIX, B.SUFFIX SUFFIX, B.MAXIMUM_ATTEMPTS MAXIMUM_ATTEMPTS, B.IS_SEEDED IS_SEEDED, TL.DESCRIPTION DESCRIPTION, 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_AUTO_SEQ_METADATA_B B, ACA_AUTO_SEQ_METADATA_TL TL WHERE B.AUTO_SEQ_METADATA_ID = TL.AUTO_SEQ_METADATA_ID AND TL.LANGUAGE = USERENV('LANG')