VIEW: INV.MTL_RELATED_ITEMS#

Source

View Text - Preformatted

select INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, RELATED_ITEM_ID RELATED_ITEM_ID, RELATIONSHIP_TYPE_ID RELATIONSHIP_TYPE_ID, RECIPROCAL_FLAG RECIPROCAL_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, START_DATE START_DATE, END_DATE END_DATE, ATTR_CONTEXT ATTR_CONTEXT, ATTR_CHAR1 ATTR_CHAR1, ATTR_CHAR2 ATTR_CHAR2, ATTR_CHAR3 ATTR_CHAR3, ATTR_CHAR4 ATTR_CHAR4, ATTR_CHAR5 ATTR_CHAR5, ATTR_CHAR6 ATTR_CHAR6, ATTR_CHAR7 ATTR_CHAR7, ATTR_CHAR8 ATTR_CHAR8, ATTR_CHAR9 ATTR_CHAR9, ATTR_CHAR10 ATTR_CHAR10, ATTR_NUM1 ATTR_NUM1, ATTR_NUM2 ATTR_NUM2, ATTR_NUM3 ATTR_NUM3, ATTR_NUM4 ATTR_NUM4, ATTR_NUM5 ATTR_NUM5, ATTR_NUM6 ATTR_NUM6, ATTR_NUM7 ATTR_NUM7, ATTR_NUM8 ATTR_NUM8, ATTR_NUM9 ATTR_NUM9, ATTR_NUM10 ATTR_NUM10, ATTR_DATE1 ATTR_DATE1, ATTR_DATE2 ATTR_DATE2, ATTR_DATE3 ATTR_DATE3, ATTR_DATE4 ATTR_DATE4, ATTR_DATE5 ATTR_DATE5, ATTR_DATE6 ATTR_DATE6, ATTR_DATE7 ATTR_DATE7, ATTR_DATE8 ATTR_DATE8, ATTR_DATE9 ATTR_DATE9, ATTR_DATE10 ATTR_DATE10, PLANNING_ENABLED_FLAG PLANNING_ENABLED_FLAG from "INV"."MTL_RELATED_ITEMS"

View Text - HTML Formatted

SELECT INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, RELATED_ITEM_ID RELATED_ITEM_ID
, RELATIONSHIP_TYPE_ID RELATIONSHIP_TYPE_ID
, RECIPROCAL_FLAG RECIPROCAL_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, START_DATE START_DATE
, END_DATE END_DATE
, ATTR_CONTEXT ATTR_CONTEXT
, ATTR_CHAR1 ATTR_CHAR1
, ATTR_CHAR2 ATTR_CHAR2
, ATTR_CHAR3 ATTR_CHAR3
, ATTR_CHAR4 ATTR_CHAR4
, ATTR_CHAR5 ATTR_CHAR5
, ATTR_CHAR6 ATTR_CHAR6
, ATTR_CHAR7 ATTR_CHAR7
, ATTR_CHAR8 ATTR_CHAR8
, ATTR_CHAR9 ATTR_CHAR9
, ATTR_CHAR10 ATTR_CHAR10
, ATTR_NUM1 ATTR_NUM1
, ATTR_NUM2 ATTR_NUM2
, ATTR_NUM3 ATTR_NUM3
, ATTR_NUM4 ATTR_NUM4
, ATTR_NUM5 ATTR_NUM5
, ATTR_NUM6 ATTR_NUM6
, ATTR_NUM7 ATTR_NUM7
, ATTR_NUM8 ATTR_NUM8
, ATTR_NUM9 ATTR_NUM9
, ATTR_NUM10 ATTR_NUM10
, ATTR_DATE1 ATTR_DATE1
, ATTR_DATE2 ATTR_DATE2
, ATTR_DATE3 ATTR_DATE3
, ATTR_DATE4 ATTR_DATE4
, ATTR_DATE5 ATTR_DATE5
, ATTR_DATE6 ATTR_DATE6
, ATTR_DATE7 ATTR_DATE7
, ATTR_DATE8 ATTR_DATE8
, ATTR_DATE9 ATTR_DATE9
, ATTR_DATE10 ATTR_DATE10
, PLANNING_ENABLED_FLAG PLANNING_ENABLED_FLAG
FROM "INV"."MTL_RELATED_ITEMS"