ACA_DOCUMENT_VERSION

Details

Schema: FUSION
Object owner: ACA
Object type: VIEW

Columns

Name
DOCUMENT_VERSION_ID DOCUMENT_NAME DESCRIPTION DOCUMENT_TYPE DOCUMENT_VERSION LATEST_VERSION VERSION_NUMBER REVISION PRODUCT_LINE DOCUMENT_CATEGORY DOCUMENT_NUMBER FROM_CONTEXT_ACTION_ID UNTIL_CONTEXT_ACTION_ID START_EFFECTIVE_DATE END_EFFECTIVE_DATE LIFECYCLE_PHASE APPROVAL_STATUS LOCKED_DATE LOCKED_BY LAST_UNLOCKED_DATE LAST_UNLOCKED_BY DOCUMENT_COMMENT SOURCE_SYSTEM SOURCE_SYSTEM_VERSION SOURCE_FILE_TYPE SOURCE_FILE_SUBTYPE FAMILY CONFIGURATION VARIANT MODEL_TYPE STANDARD_PART OBJECT_VERSION_NUMBER DOCUMENT_VERSION_MASTER_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DOCUMENT_TIMESTAMP

Name

DOCUMENT_VERSION_ID

DOCUMENT_NAME

DESCRIPTION

DOCUMENT_TYPE

DOCUMENT_VERSION

LATEST_VERSION

VERSION_NUMBER

REVISION

PRODUCT_LINE

DOCUMENT_CATEGORY

DOCUMENT_NUMBER

FROM_CONTEXT_ACTION_ID

UNTIL_CONTEXT_ACTION_ID

START_EFFECTIVE_DATE

END_EFFECTIVE_DATE

LIFECYCLE_PHASE

APPROVAL_STATUS

LOCKED_DATE

LOCKED_BY

LAST_UNLOCKED_DATE

LAST_UNLOCKED_BY

DOCUMENT_COMMENT

SOURCE_SYSTEM

SOURCE_SYSTEM_VERSION

SOURCE_FILE_TYPE

SOURCE_FILE_SUBTYPE

FAMILY

CONFIGURATION

VARIANT

MODEL_TYPE

STANDARD_PART

OBJECT_VERSION_NUMBER

DOCUMENT_VERSION_MASTER_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

DOCUMENT_TIMESTAMP

Query

SQL_Statement
SELECT B.DOCUMENT_VERSION_ID DOCUMENT_VERSION_ID, T.DOCUMENT_NAME DOCUMENT_NAME, T.DESCRIPTION DESCRIPTION, B.DOCUMENT_TYPE DOCUMENT_TYPE, B.DOCUMENT_VERSION DOCUMENT_VERSION, B.LATEST_VERSION LATEST_VERSION, B.VERSION_NUMBER VERSION_NUMBER, B.REVISION REVISION, B.PRODUCT_LINE PRODUCT_LINE, B.DOCUMENT_CATEGORY DOCUMENT_CATEGORY, B.DOCUMENT_NUMBER DOCUMENT_NUMBER, B.FROM_CONTEXT_ACTION_ID FROM_CONTEXT_ACTION_ID, B.UNTIL_CONTEXT_ACTION_ID UNTIL_CONTEXT_ACTION_ID, B.START_EFFECTIVE_DATE START_EFFECTIVE_DATE, B.END_EFFECTIVE_DATE END_EFFECTIVE_DATE, B.LIFECYCLE_PHASE LIFECYCLE_PHASE, B.APPROVAL_STATUS APPROVAL_STATUS, B.LOCKED_DATE LOCKED_DATE, B.LOCKED_BY LOCKED_BY, B.LAST_UNLOCKED_DATE LAST_UNLOCKED_DATE, B.LAST_UNLOCKED_BY LAST_UNLOCKED_BY, T.DOCUMENT_COMMENT DOCUMENT_COMMENT, B.SOURCE_SYSTEM SOURCE_SYSTEM, B.SOURCE_SYSTEM_VERSION SOURCE_SYSTEM_VERSION, B.SOURCE_FILE_TYPE SOURCE_FILE_TYPE, B.SOURCE_FILE_SUBTYPE SOURCE_FILE_SUBTYPE, B.FAMILY FAMILY, B.CONFIGURATION CONFIGURATION, B.VARIANT VARIANT, B.MODEL_TYPE MODEL_TYPE, B.STANDARD_PART STANDARD_PART, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.DOCUMENT_VERSION_MASTER_ID DOCUMENT_VERSION_MASTER_ID, 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, B.DOCUMENT_TIMESTAMP DOCUMENT_TIMESTAMP FROM ACA_DOCUMENT_VERSION_B B, ACA_DOCUMENT_VERSION_TL T WHERE B.DOCUMENT_VERSION_ID = T.DOCUMENT_VERSION_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.DOCUMENT_VERSION_ID DOCUMENT_VERSION_ID,

T.DOCUMENT_NAME DOCUMENT_NAME,

T.DESCRIPTION DESCRIPTION,

B.DOCUMENT_TYPE DOCUMENT_TYPE,

B.DOCUMENT_VERSION DOCUMENT_VERSION,

B.LATEST_VERSION LATEST_VERSION,

B.VERSION_NUMBER VERSION_NUMBER,

B.REVISION REVISION,

B.PRODUCT_LINE PRODUCT_LINE,

B.DOCUMENT_CATEGORY DOCUMENT_CATEGORY,

B.DOCUMENT_NUMBER DOCUMENT_NUMBER,

B.FROM_CONTEXT_ACTION_ID FROM_CONTEXT_ACTION_ID,

B.UNTIL_CONTEXT_ACTION_ID UNTIL_CONTEXT_ACTION_ID,

B.START_EFFECTIVE_DATE START_EFFECTIVE_DATE,

B.END_EFFECTIVE_DATE END_EFFECTIVE_DATE,

B.LIFECYCLE_PHASE LIFECYCLE_PHASE,

B.APPROVAL_STATUS APPROVAL_STATUS,

B.LOCKED_DATE LOCKED_DATE,

B.LOCKED_BY LOCKED_BY,

B.LAST_UNLOCKED_DATE LAST_UNLOCKED_DATE,

B.LAST_UNLOCKED_BY LAST_UNLOCKED_BY,

T.DOCUMENT_COMMENT DOCUMENT_COMMENT,

B.SOURCE_SYSTEM SOURCE_SYSTEM,

B.SOURCE_SYSTEM_VERSION SOURCE_SYSTEM_VERSION,

B.SOURCE_FILE_TYPE SOURCE_FILE_TYPE,

B.SOURCE_FILE_SUBTYPE SOURCE_FILE_SUBTYPE,

B.FAMILY FAMILY,

B.CONFIGURATION CONFIGURATION,

B.VARIANT VARIANT,

B.MODEL_TYPE MODEL_TYPE,

B.STANDARD_PART STANDARD_PART,

B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

B.DOCUMENT_VERSION_MASTER_ID DOCUMENT_VERSION_MASTER_ID,

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,

B.DOCUMENT_TIMESTAMP DOCUMENT_TIMESTAMP

FROM

ACA_DOCUMENT_VERSION_B B,

ACA_DOCUMENT_VERSION_TL T

WHERE

B.DOCUMENT_VERSION_ID = T.DOCUMENT_VERSION_ID AND T.LANGUAGE = USERENV('LANG')