PJF_TXN_DOCUMENT_VL

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name

DOCUMENT_ID DOCUMENT_CODE DOCUMENT_NAME DESCRIPTION PREDEFINED_FLAG TRANSACTION_SOURCE_ID START_DATE_ACTIVE END_DATE_ACTIVE COSTED_FLAG ALLOW_BURDEN_FLAG ALLOW_DUPLICATE_REF_FLAG ALLOW_EMP_ORG_OVERRIDE_FLAG PURGEABLE_FLAG IMPORT_COST_ACC_FLAG COST_ACC_JOURNAL_FLAG ADJUST_ACC_JOURNAL_FLAG ACCT_DURING_IMPORT SKIP_TXN_CONTROLS TIEBACK_TO_SOURCE ACCT_SOURCE_CODE PROCESS_FUNDS_CHECK COMMITMENT_FLAG COMMITMENT_TYPE REVALIDATE_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 OBJECT_VERSION_NUMBER EXP_BATCH_APPROVAL_FLAG IMPORT_IN_CLOSED_PERIOD_FLAG ALLOW_INACTIVE_SUSP_ASSGN_FLAG

Query

SQL_Statement

SELECT B.DOCUMENT_ID DOCUMENT_ID, B.DOCUMENT_CODE DOCUMENT_CODE, T.DOCUMENT_NAME DOCUMENT_NAME, T.DESCRIPTION DESCRIPTION, B.PREDEFINED_FLAG PREDEFINED_FLAG, B.TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID, B.START_DATE_ACTIVE START_DATE_ACTIVE, B.END_DATE_ACTIVE END_DATE_ACTIVE, B.COSTED_FLAG COSTED_FLAG, B.ALLOW_BURDEN_FLAG ALLOW_BURDEN_FLAG, B.ALLOW_DUPLICATE_REF_FLAG ALLOW_DUPLICATE_REF_FLAG, B.ALLOW_EMP_ORG_OVERRIDE_FLAG ALLOW_EMP_ORG_OVERRIDE_FLAG, B.PURGEABLE_FLAG PURGEABLE_FLAG, B.IMPORT_COST_ACC_FLAG IMPORT_COST_ACC_FLAG, B.COST_ACC_JOURNAL_FLAG COST_ACC_JOURNAL_FLAG, B.ADJUST_ACC_JOURNAL_FLAG ADJUST_ACC_JOURNAL_FLAG, B.ACCT_DURING_IMPORT ACCT_DURING_IMPORT, B.SKIP_TXN_CONTROLS SKIP_TXN_CONTROLS, B.TIEBACK_TO_SOURCE TIEBACK_TO_SOURCE, B.ACCT_SOURCE_CODE ACCT_SOURCE_CODE, B.PROCESS_FUNDS_CHECK PROCESS_FUNDS_CHECK, B.COMMITMENT_FLAG COMMITMENT_FLAG, B.COMMITMENT_TYPE COMMITMENT_TYPE, B.REVALIDATE_FLAG REVALIDATE_FLAG, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, B.ATTRIBUTE1 ATTRIBUTE1, B.ATTRIBUTE2 ATTRIBUTE2, B.ATTRIBUTE3 ATTRIBUTE3, B.ATTRIBUTE4 ATTRIBUTE4, B.ATTRIBUTE5 ATTRIBUTE5, B.ATTRIBUTE6 ATTRIBUTE6, B.ATTRIBUTE7 ATTRIBUTE7, B.ATTRIBUTE8 ATTRIBUTE8, B.ATTRIBUTE9 ATTRIBUTE9, B.ATTRIBUTE10 ATTRIBUTE10, B.ATTRIBUTE11 ATTRIBUTE11, B.ATTRIBUTE12 ATTRIBUTE12, B.ATTRIBUTE13 ATTRIBUTE13, B.ATTRIBUTE14 ATTRIBUTE14, B.ATTRIBUTE15 ATTRIBUTE15, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.EXP_BATCH_APPROVAL_FLAG, B.IMPORT_IN_CLOSED_PERIOD_FLAG, B.ALLOW_INACTIVE_SUSP_ASSGN_FLAG FROM PJF_TXN_DOCUMENT_B B, PJF_TXN_DOCUMENT_TL T WHERE T.DOCUMENT_ID = B.DOCUMENT_ID AND T.LANGUAGE = USERENV('LANG')