View: MTL_RELATED_ITEMS_ALL_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_RELATED_ITEMS_ALL_V

View Text

SELECT A.ROWID ROW_ID
, A.ORGANIZATION_ID ORGANIZATION_ID
, A.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, B.DESCRIPTION INVENTORY_ITEM_DESCRIPTION
, A.RELATED_ITEM_ID RELATED_ITEM_ID
, C.DESCRIPTION RELATED_ITEM_DESCRIPTION
, A.RELATIONSHIP_TYPE_ID
, A.RECIPROCAL_FLAG
, A.START_DATE START_DATE
, A.END_DATE END_DATE
, A.ATTR_CONTEXT ATTR_CONTEXT
, A.ATTR_CHAR1 ATTR_CHAR1
, A.ATTR_CHAR2 ATTR_CHAR2
, A.ATTR_CHAR3 ATTR_CHAR3
, A.ATTR_CHAR4 ATTR_CHAR4
, A.ATTR_CHAR5 ATTR_CHAR5
, A.ATTR_CHAR6 ATTR_CHAR6
, A.ATTR_CHAR7 ATTR_CHAR7
, A.ATTR_CHAR8 ATTR_CHAR8
, A.ATTR_CHAR9 ATTR_CHAR9
, A.ATTR_CHAR10 ATTR_CHAR10
, A.ATTR_NUM1 ATTR_NUM1
, A.ATTR_NUM2 ATTR_NUM2
, A.ATTR_NUM3 ATTR_NUM3
, A.ATTR_NUM4 ATTR_NUM4
, A.ATTR_NUM5 ATTR_NUM5
, A.ATTR_NUM6 ATTR_NUM6
, A.ATTR_NUM7 ATTR_NUM7
, A.ATTR_NUM8 ATTR_NUM8
, A.ATTR_NUM9 ATTR_NUM9
, A.ATTR_NUM10 ATTR_NUM10
, A.ATTR_DATE1 ATTR_DATE1
, A.ATTR_DATE2 ATTR_DATE2
, A.ATTR_DATE3 ATTR_DATE3
, A.ATTR_DATE4 ATTR_DATE4
, A.ATTR_DATE5 ATTR_DATE5
, A.ATTR_DATE6 ATTR_DATE6
, A.ATTR_DATE7 ATTR_DATE7
, A.ATTR_DATE8 ATTR_DATE8
, A.ATTR_DATE9 ATTR_DATE9
, A.ATTR_DATE10 ATTR_DATE10
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.PLANNING_ENABLED_FLAG
FROM MTL_SYSTEM_ITEMS_TL B
, MTL_SYSTEM_ITEMS_TL C
, MTL_RELATED_ITEMS A
WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND A.ORGANIZATION_ID = B.ORGANIZATION_ID
AND B.LANGUAGE = USERENV('LANG')
AND A.RELATED_ITEM_ID = C.INVENTORY_ITEM_ID
AND A.ORGANIZATION_ID = C.ORGANIZATION_ID
AND C.LANGUAGE = USERENV('LANG')

Columns