1. Tables and Views for SCM
  2. INV_TRANSACTION_TYPES_VL

INV_TRANSACTION_TYPES_VL

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: VIEW

Columns

Name

TRANSACTION_TYPE_NAME

DESCRIPTION

TRANSACTION_TYPE_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATION_DATE

CREATED_BY

TRANSACTION_ACTION_ID

TRANSACTION_SOURCE_TYPE_ID

END_DATE

START_DATE

USER_DEFINED_FLAG

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE_CATEGORY

TYPE_CLASS

SHORTAGE_MSG_BACKGROUND_FLAG

SHORTAGE_MSG_ONLINE_FLAG

STATUS_CONTROL_FLAG

LOCATION_REQUIRED_FLAG

OBJECT_VERSION_NUMBER

ROW_ID

Query

SQL_Statement

SELECT

INV_TRANSACTION_TYPES_TL.TRANSACTION_TYPE_NAME TRANSACTION_TYPE_NAME,

INV_TRANSACTION_TYPES_TL.DESCRIPTION DESCRIPTION,

INV_TRANSACTION_TYPES_B.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID,

INV_TRANSACTION_TYPES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

INV_TRANSACTION_TYPES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

INV_TRANSACTION_TYPES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

INV_TRANSACTION_TYPES_B.CREATION_DATE CREATION_DATE,

INV_TRANSACTION_TYPES_B.CREATED_BY CREATED_BY,

INV_TRANSACTION_TYPES_B.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID,

INV_TRANSACTION_TYPES_B.TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID,

INV_TRANSACTION_TYPES_B.END_DATE END_DATE,

INV_TRANSACTION_TYPES_B.START_DATE START_DATE,

INV_TRANSACTION_TYPES_B.USER_DEFINED_FLAG USER_DEFINED_FLAG,

INV_TRANSACTION_TYPES_B.ATTRIBUTE1 ATTRIBUTE1,

INV_TRANSACTION_TYPES_B.ATTRIBUTE2 ATTRIBUTE2,

INV_TRANSACTION_TYPES_B.ATTRIBUTE3 ATTRIBUTE3,

INV_TRANSACTION_TYPES_B.ATTRIBUTE4 ATTRIBUTE4,

INV_TRANSACTION_TYPES_B.ATTRIBUTE5 ATTRIBUTE5,

INV_TRANSACTION_TYPES_B.ATTRIBUTE6 ATTRIBUTE6,

INV_TRANSACTION_TYPES_B.ATTRIBUTE7 ATTRIBUTE7,

INV_TRANSACTION_TYPES_B.ATTRIBUTE8 ATTRIBUTE8,

INV_TRANSACTION_TYPES_B.ATTRIBUTE9 ATTRIBUTE9,

INV_TRANSACTION_TYPES_B.ATTRIBUTE10 ATTRIBUTE10,

INV_TRANSACTION_TYPES_B.ATTRIBUTE11 ATTRIBUTE11,

INV_TRANSACTION_TYPES_B.ATTRIBUTE12 ATTRIBUTE12,

INV_TRANSACTION_TYPES_B.ATTRIBUTE13 ATTRIBUTE13,

INV_TRANSACTION_TYPES_B.ATTRIBUTE14 ATTRIBUTE14,

INV_TRANSACTION_TYPES_B.ATTRIBUTE15 ATTRIBUTE15,

INV_TRANSACTION_TYPES_B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

INV_TRANSACTION_TYPES_B.TYPE_CLASS TYPE_CLASS,

INV_TRANSACTION_TYPES_B.SHORTAGE_MSG_BACKGROUND_FLAG SHORTAGE_MSG_BACKGROUND_FLAG,

INV_TRANSACTION_TYPES_B.SHORTAGE_MSG_ONLINE_FLAG SHORTAGE_MSG_ONLINE_FLAG,

INV_TRANSACTION_TYPES_B.STATUS_CONTROL_FLAG STATUS_CONTROL_FLAG,

INV_TRANSACTION_TYPES_B.LOCATION_REQUIRED_FLAG LOCATION_REQUIRED_FLAG,

INV_TRANSACTION_TYPES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

INV_TRANSACTION_TYPES_B.ROWID ROW_ID

FROM

INV_TRANSACTION_TYPES_TL,

INV_TRANSACTION_TYPES_B

WHERE

INV_TRANSACTION_TYPES_TL.TRANSACTION_TYPE_ID = INV_TRANSACTION_TYPES_B.TRANSACTION_TYPE_ID AND INV_TRANSACTION_TYPES_TL.LANGUAGE = USERENV('LANG')