VIEW: APPS.MTL_RELATED_ITEMS_ALL_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')