PJF_TXN_SOURCES_VL

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name

TRANSACTION_SOURCE_ID TRANSACTION_SOURCE USER_TRANSACTION_SOURCE DESCRIPTION PREDEFINED_FLAG BATCH_SIZE 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 PRE_PROCESSING_EXTENSION POST_PROCESSING_EXTENSION

Query

SQL_Statement

SELECT PJF_TXN_SOURCES_B.TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID, PJF_TXN_SOURCES_B.TRANSACTION_SOURCE TRANSACTION_SOURCE, PJF_TXN_SOURCES_TL.USER_TRANSACTION_SOURCE USER_TRANSACTION_SOURCE, PJF_TXN_SOURCES_TL.DESCRIPTION DESCRIPTION, PJF_TXN_SOURCES_B.PREDEFINED_FLAG PREDEFINED_FLAG, PJF_TXN_SOURCES_B.BATCH_SIZE BATCH_SIZE, PJF_TXN_SOURCES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, PJF_TXN_SOURCES_B.LAST_UPDATED_BY LAST_UPDATED_BY, PJF_TXN_SOURCES_B.CREATION_DATE CREATION_DATE, PJF_TXN_SOURCES_B.CREATED_BY CREATED_BY, PJF_TXN_SOURCES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PJF_TXN_SOURCES_B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, PJF_TXN_SOURCES_B.ATTRIBUTE1 ATTRIBUTE1, PJF_TXN_SOURCES_B.ATTRIBUTE2 ATTRIBUTE2, PJF_TXN_SOURCES_B.ATTRIBUTE3 ATTRIBUTE3, PJF_TXN_SOURCES_B.ATTRIBUTE4 ATTRIBUTE4, PJF_TXN_SOURCES_B.ATTRIBUTE5 ATTRIBUTE5, PJF_TXN_SOURCES_B.ATTRIBUTE6 ATTRIBUTE6, PJF_TXN_SOURCES_B.ATTRIBUTE7 ATTRIBUTE7, PJF_TXN_SOURCES_B.ATTRIBUTE8 ATTRIBUTE8, PJF_TXN_SOURCES_B.ATTRIBUTE9 ATTRIBUTE9, PJF_TXN_SOURCES_B.ATTRIBUTE10 ATTRIBUTE10, PJF_TXN_SOURCES_B.ATTRIBUTE11 ATTRIBUTE11, PJF_TXN_SOURCES_B.ATTRIBUTE12 ATTRIBUTE12, PJF_TXN_SOURCES_B.ATTRIBUTE13 ATTRIBUTE13, PJF_TXN_SOURCES_B.ATTRIBUTE14 ATTRIBUTE14, PJF_TXN_SOURCES_B.ATTRIBUTE15 ATTRIBUTE15, PJF_TXN_SOURCES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PJF_TXN_SOURCES_B.PRE_PROCESSING_EXTENSION PRE_PROCESSING_EXTENSION, PJF_TXN_SOURCES_B.POST_PROCESSING_EXTENSION POST_PROCESSING_EXTENSION FROM PJF_TXN_SOURCES_B, PJF_TXN_SOURCES_TL WHERE PJF_TXN_SOURCES_B.TRANSACTION_SOURCE_ID = PJF_TXN_SOURCES_TL.TRANSACTION_SOURCE_ID AND PJF_TXN_SOURCES_TL.LANGUAGE = USERENV('LANG')