INV_TXN_SOURCE_TYPES

Details

Schema: FUSION
Object owner: INV
Object type: VIEW

Columns

Name
TRANSACTION_SOURCE_TYPE_NAME DESCRIPTION TRANSACTION_SOURCE_TYPE_ID LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY END_DATE START_DATE USER_DEFINED_FLAG VALIDATED_FLAG DESCRIPTIVE_FLEX_CONTEXT_CODE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REQUEST_ID TRANSACTION_SOURCE_CATEGORY TRANSACTION_SOURCE OBJECT_VERSION_NUMBER ROW_ID

Name

TRANSACTION_SOURCE_TYPE_NAME

DESCRIPTION

TRANSACTION_SOURCE_TYPE_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATION_DATE

CREATED_BY

END_DATE

START_DATE

USER_DEFINED_FLAG

VALIDATED_FLAG

DESCRIPTIVE_FLEX_CONTEXT_CODE

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

REQUEST_ID

TRANSACTION_SOURCE_CATEGORY

TRANSACTION_SOURCE

OBJECT_VERSION_NUMBER

ROW_ID

Query

SQL_Statement
SELECT INV_TXN_SOURCE_TYPES_TL.TRANSACTION_SOURCE_TYPE_NAME TRANSACTION_SOURCE_TYPE_NAME, INV_TXN_SOURCE_TYPES_TL.DESCRIPTION DESCRIPTION, INV_TXN_SOURCE_TYPES_B.TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, INV_TXN_SOURCE_TYPES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, INV_TXN_SOURCE_TYPES_B.LAST_UPDATED_BY LAST_UPDATED_BY, INV_TXN_SOURCE_TYPES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INV_TXN_SOURCE_TYPES_B.CREATION_DATE CREATION_DATE, INV_TXN_SOURCE_TYPES_B.CREATED_BY CREATED_BY, INV_TXN_SOURCE_TYPES_B.END_DATE END_DATE, INV_TXN_SOURCE_TYPES_B.START_DATE START_DATE, INV_TXN_SOURCE_TYPES_B.USER_DEFINED_FLAG USER_DEFINED_FLAG, INV_TXN_SOURCE_TYPES_B.VALIDATED_FLAG VALIDATED_FLAG, INV_TXN_SOURCE_TYPES_B.DESCRIPTIVE_FLEX_CONTEXT_CODE DESCRIPTIVE_FLEX_CONTEXT_CODE, INV_TXN_SOURCE_TYPES_B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, INV_TXN_SOURCE_TYPES_B.ATTRIBUTE1 ATTRIBUTE1, INV_TXN_SOURCE_TYPES_B.ATTRIBUTE2 ATTRIBUTE2, INV_TXN_SOURCE_TYPES_B.ATTRIBUTE3 ATTRIBUTE3, INV_TXN_SOURCE_TYPES_B.ATTRIBUTE4 ATTRIBUTE4, INV_TXN_SOURCE_TYPES_B.ATTRIBUTE5 ATTRIBUTE5, INV_TXN_SOURCE_TYPES_B.ATTRIBUTE6 ATTRIBUTE6, INV_TXN_SOURCE_TYPES_B.ATTRIBUTE7 ATTRIBUTE7, INV_TXN_SOURCE_TYPES_B.ATTRIBUTE8 ATTRIBUTE8, INV_TXN_SOURCE_TYPES_B.ATTRIBUTE9 ATTRIBUTE9, INV_TXN_SOURCE_TYPES_B.ATTRIBUTE10 ATTRIBUTE10, INV_TXN_SOURCE_TYPES_B.ATTRIBUTE11 ATTRIBUTE11, INV_TXN_SOURCE_TYPES_B.ATTRIBUTE12 ATTRIBUTE12, INV_TXN_SOURCE_TYPES_B.ATTRIBUTE13 ATTRIBUTE13, INV_TXN_SOURCE_TYPES_B.ATTRIBUTE14 ATTRIBUTE14, INV_TXN_SOURCE_TYPES_B.ATTRIBUTE15 ATTRIBUTE15, INV_TXN_SOURCE_TYPES_B.REQUEST_ID REQUEST_ID, INV_TXN_SOURCE_TYPES_B.TRANSACTION_SOURCE_CATEGORY TRANSACTION_SOURCE_CATEGORY, INV_TXN_SOURCE_TYPES_B.TRANSACTION_SOURCE TRANSACTION_SOURCE, INV_TXN_SOURCE_TYPES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, INV_TXN_SOURCE_TYPES_B.ROWID ROW_ID FROM INV_TXN_SOURCE_TYPES_TL, INV_TXN_SOURCE_TYPES_B WHERE INV_TXN_SOURCE_TYPES_TL.TRANSACTION_SOURCE_TYPE_ID = INV_TXN_SOURCE_TYPES_B.TRANSACTION_SOURCE_TYPE_ID AND INV_TXN_SOURCE_TYPES_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

INV_TXN_SOURCE_TYPES_TL.TRANSACTION_SOURCE_TYPE_NAME TRANSACTION_SOURCE_TYPE_NAME,

INV_TXN_SOURCE_TYPES_TL.DESCRIPTION DESCRIPTION,

INV_TXN_SOURCE_TYPES_B.TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID,

INV_TXN_SOURCE_TYPES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

INV_TXN_SOURCE_TYPES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

INV_TXN_SOURCE_TYPES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

INV_TXN_SOURCE_TYPES_B.CREATION_DATE CREATION_DATE,

INV_TXN_SOURCE_TYPES_B.CREATED_BY CREATED_BY,

INV_TXN_SOURCE_TYPES_B.END_DATE END_DATE,

INV_TXN_SOURCE_TYPES_B.START_DATE START_DATE,

INV_TXN_SOURCE_TYPES_B.USER_DEFINED_FLAG USER_DEFINED_FLAG,

INV_TXN_SOURCE_TYPES_B.VALIDATED_FLAG VALIDATED_FLAG,

INV_TXN_SOURCE_TYPES_B.DESCRIPTIVE_FLEX_CONTEXT_CODE DESCRIPTIVE_FLEX_CONTEXT_CODE,

INV_TXN_SOURCE_TYPES_B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

INV_TXN_SOURCE_TYPES_B.ATTRIBUTE1 ATTRIBUTE1,

INV_TXN_SOURCE_TYPES_B.ATTRIBUTE2 ATTRIBUTE2,

INV_TXN_SOURCE_TYPES_B.ATTRIBUTE3 ATTRIBUTE3,

INV_TXN_SOURCE_TYPES_B.ATTRIBUTE4 ATTRIBUTE4,

INV_TXN_SOURCE_TYPES_B.ATTRIBUTE5 ATTRIBUTE5,

INV_TXN_SOURCE_TYPES_B.ATTRIBUTE6 ATTRIBUTE6,

INV_TXN_SOURCE_TYPES_B.ATTRIBUTE7 ATTRIBUTE7,

INV_TXN_SOURCE_TYPES_B.ATTRIBUTE8 ATTRIBUTE8,

INV_TXN_SOURCE_TYPES_B.ATTRIBUTE9 ATTRIBUTE9,

INV_TXN_SOURCE_TYPES_B.ATTRIBUTE10 ATTRIBUTE10,

INV_TXN_SOURCE_TYPES_B.ATTRIBUTE11 ATTRIBUTE11,

INV_TXN_SOURCE_TYPES_B.ATTRIBUTE12 ATTRIBUTE12,

INV_TXN_SOURCE_TYPES_B.ATTRIBUTE13 ATTRIBUTE13,

INV_TXN_SOURCE_TYPES_B.ATTRIBUTE14 ATTRIBUTE14,

INV_TXN_SOURCE_TYPES_B.ATTRIBUTE15 ATTRIBUTE15,

INV_TXN_SOURCE_TYPES_B.REQUEST_ID REQUEST_ID,

INV_TXN_SOURCE_TYPES_B.TRANSACTION_SOURCE_CATEGORY TRANSACTION_SOURCE_CATEGORY,

INV_TXN_SOURCE_TYPES_B.TRANSACTION_SOURCE TRANSACTION_SOURCE,

INV_TXN_SOURCE_TYPES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

INV_TXN_SOURCE_TYPES_B.ROWID ROW_ID

FROM

INV_TXN_SOURCE_TYPES_TL,

INV_TXN_SOURCE_TYPES_B

WHERE

INV_TXN_SOURCE_TYPES_TL.TRANSACTION_SOURCE_TYPE_ID = INV_TXN_SOURCE_TYPES_B.TRANSACTION_SOURCE_TYPE_ID AND INV_TXN_SOURCE_TYPES_TL.LANGUAGE = USERENV('LANG')