1. Tables and Views for SCM
  2. INV_MATERIAL_TXNS_V

INV_MATERIAL_TXNS_V

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: VIEW

Columns

Name

TRANSACTION_ID

ITEM_GRADE_CODE

ITEM_EXPIRATION_DATE

INV_USER_DEF_ATTRIBUTE_NUMBER1

INV_USER_DEF_ATTRIBUTE_NUMBER2

INV_USER_DEF_ATTRIBUTE_NUMBER3

INV_USER_DEF_ATTRIBUTE_NUMBER4

INV_USER_DEF_ATTRIBUTE_NUMBER5

INV_USER_DEF_ATTRIBUTE_DATE1

INV_USER_DEF_ATTRIBUTE_DATE2

INV_USER_DEF_ATTRIBUTE_DATE3

INV_USER_DEF_ATTRIBUTE_DATE4

INV_USER_DEF_ATTRIBUTE_DATE5

INV_RESERVED_ATTRIBUTE1

INV_RESERVED_ATTRIBUTE2

INV_USER_DEF_ATTRIBUTE1

INV_USER_DEF_ATTRIBUTE2

INV_USER_DEF_ATTRIBUTE3

INV_USER_DEF_ATTRIBUTE4

INV_USER_DEF_ATTRIBUTE5

INV_USER_DEF_ATTRIBUTE6

INV_USER_DEF_ATTRIBUTE7

INV_USER_DEF_ATTRIBUTE8

INV_USER_DEF_ATTRIBUTE9

INV_USER_DEF_ATTRIBUTE10

COUNTRY_OF_ORIGIN_CODE

INV_STRIPING_CATEGORY

TASK_ID

PROJECT_ID

Query

SQL_Statement

SELECT

TRANSACTION_ID TRANSACTION_ID,

TO_ITEM_GRADE_CODE ITEM_GRADE_CODE,

TO_ITEM_EXPIRATION_DATE ITEM_EXPIRATION_DATE,

TO_INV_USER_DEF_ATTR_NUMBER1 INV_USER_DEF_ATTRIBUTE_NUMBER1,

TO_INV_USER_DEF_ATTR_NUMBER2 INV_USER_DEF_ATTRIBUTE_NUMBER2,

TO_INV_USER_DEF_ATTR_NUMBER3 INV_USER_DEF_ATTRIBUTE_NUMBER3,

TO_INV_USER_DEF_ATTR_NUMBER4 INV_USER_DEF_ATTRIBUTE_NUMBER4,

TO_INV_USER_DEF_ATTR_NUMBER5 INV_USER_DEF_ATTRIBUTE_NUMBER5,

TO_INV_USER_DEF_ATTR_DATE1 INV_USER_DEF_ATTRIBUTE_DATE1,

TO_INV_USER_DEF_ATTR_DATE2 INV_USER_DEF_ATTRIBUTE_DATE2,

TO_INV_USER_DEF_ATTR_DATE3 INV_USER_DEF_ATTRIBUTE_DATE3,

TO_INV_USER_DEF_ATTR_DATE4 INV_USER_DEF_ATTRIBUTE_DATE4,

TO_INV_USER_DEF_ATTR_DATE5 INV_USER_DEF_ATTRIBUTE_DATE5,

TO_INV_RESERVED_ATTR1 INV_RESERVED_ATTRIBUTE1,

TO_INV_RESERVED_ATTR2 INV_RESERVED_ATTRIBUTE2,

TO_INV_USER_DEF_ATTR1 INV_USER_DEF_ATTRIBUTE1,

TO_INV_USER_DEF_ATTR2 INV_USER_DEF_ATTRIBUTE2,

TO_INV_USER_DEF_ATTR3 INV_USER_DEF_ATTRIBUTE3,

TO_INV_USER_DEF_ATTR4 INV_USER_DEF_ATTRIBUTE4,

TO_INV_USER_DEF_ATTR5 INV_USER_DEF_ATTRIBUTE5,

TO_INV_USER_DEF_ATTR6 INV_USER_DEF_ATTRIBUTE6,

TO_INV_USER_DEF_ATTR7 INV_USER_DEF_ATTRIBUTE7,

TO_INV_USER_DEF_ATTR8 INV_USER_DEF_ATTRIBUTE8,

TO_INV_USER_DEF_ATTR9 INV_USER_DEF_ATTRIBUTE9,

TO_INV_USER_DEF_ATTR10 INV_USER_DEF_ATTRIBUTE10,

COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE,

TO_INV_STRIPING_CATEGORY INV_STRIPING_CATEGORY,

TASK_ID TASK_ID,

PROJECT_ID PROJECT_ID

FROM

INV_MATERIAL_TXNS