1. Tables and Views for SCM
  2. WSH_DEL_DETAILS_INTERFACE_V

WSH_DEL_DETAILS_INTERFACE_V

Details

  • Schema: FUSION

  • Object owner: WSH

  • Object type: VIEW

Columns

Name

DELIVERY_DETAIL_INTERFACE_ID

PROJECT_ID

TASK_ID

COUNTRY_OF_ORIGIN_CODE

ITEM_GRADE_CODE

ITEM_EXPIRATION_DATE

INV_STRIPING_CATEGORY

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

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

INVENTORY_ITEM_ID

ORGANIZATION_ID

Query

SQL_Statement

SELECT

DELIVERY_DETAIL_INTERFACE_ID DELIVERY_DETAIL_INTERFACE_ID,

PJC_PROJECT_ID PROJECT_ID,

PJC_TASK_ID TASK_ID,

SRC_COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE,

PREFERRED_GRADE ITEM_GRADE_CODE,

SRC_ITEM_EXPIRATION_DATE ITEM_EXPIRATION_DATE,

SRC_INV_STRIPING_CATEGORY INV_STRIPING_CATEGORY,

SRC_INV_RESERVED_ATTRIBUTE1 INV_RESERVED_ATTRIBUTE1,

SRC_INV_RESERVED_ATTRIBUTE2 INV_RESERVED_ATTRIBUTE2,

SRC_INV_USER_DEF_ATTRIBUTE1 INV_USER_DEF_ATTRIBUTE1,

SRC_INV_USER_DEF_ATTRIBUTE2 INV_USER_DEF_ATTRIBUTE2,

SRC_INV_USER_DEF_ATTRIBUTE3 INV_USER_DEF_ATTRIBUTE3,

SRC_INV_USER_DEF_ATTRIBUTE4 INV_USER_DEF_ATTRIBUTE4,

SRC_INV_USER_DEF_ATTRIBUTE5 INV_USER_DEF_ATTRIBUTE5,

SRC_INV_USER_DEF_ATTRIBUTE6 INV_USER_DEF_ATTRIBUTE6,

SRC_INV_USER_DEF_ATTRIBUTE7 INV_USER_DEF_ATTRIBUTE7,

SRC_INV_USER_DEF_ATTRIBUTE8 INV_USER_DEF_ATTRIBUTE8,

SRC_INV_USER_DEF_ATTRIBUTE9 INV_USER_DEF_ATTRIBUTE9,

SRC_INV_USER_DEF_ATTRIBUTE10 INV_USER_DEF_ATTRIBUTE10,

SRC_INV_USER_DEF_ATTR_NUMBER1 INV_USER_DEF_ATTRIBUTE_NUMBER1,

SRC_INV_USER_DEF_ATTR_NUMBER2 INV_USER_DEF_ATTRIBUTE_NUMBER2,

SRC_INV_USER_DEF_ATTR_NUMBER3 INV_USER_DEF_ATTRIBUTE_NUMBER3,

SRC_INV_USER_DEF_ATTR_NUMBER4 INV_USER_DEF_ATTRIBUTE_NUMBER4,

SRC_INV_USER_DEF_ATTR_NUMBER5 INV_USER_DEF_ATTRIBUTE_NUMBER5,

SRC_INV_USER_DEF_ATTR_DATE1 INV_USER_DEF_ATTRIBUTE_DATE1,

SRC_INV_USER_DEF_ATTR_DATE2 INV_USER_DEF_ATTRIBUTE_DATE2,

SRC_INV_USER_DEF_ATTR_DATE3 INV_USER_DEF_ATTRIBUTE_DATE3,

SRC_INV_USER_DEF_ATTR_DATE4 INV_USER_DEF_ATTRIBUTE_DATE4,

SRC_INV_USER_DEF_ATTR_DATE5 INV_USER_DEF_ATTRIBUTE_DATE5,

INVENTORY_ITEM_ID INVENTORY_ITEM_ID,

ORGANIZATION_ID ORGANIZATION_ID

FROM WSH_DEL_DETAILS_INTERFACE