View: ASO_I_RELATED_ITEMS_V

Product:	ASO - Order Capture
Description:	View showing Item Relationships
Implementation/DBA Data:	APPS.ASO_I_RELATED_ITEMS_V

View Text

SELECT A.ORGANIZATION_ID
, A.INVENTORY_ITEM_ID
, A.RELATED_ITEM_ID
, A.RELATIONSHIP_TYPE_ID
, C.MEANING RELATIONSHIP_TYPE
, A.RECIPROCAL_FLAG
, B.DESCRIPTION RELATED_ITEM_DESCRIPTION
, B.CONCATENATED_SEGMENTS RELATED_ITEM
, B.PADDED_CONCATENATED_SEGMENTS PADDED_CONCATENATED_SEGMENTS
, B.PRIMARY_UOM_CODE UOM
, B.LIST_PRICE_PER_UNIT UNIT_PRICE
FROM MTL_RELATED_ITEMS_VIEW A
, MFG_LOOKUPS C
, MTL_SYSTEM_ITEMS_VL B
WHERE A.RELATED_ITEM_ID = B.INVENTORY_ITEM_ID
AND A.ORGANIZATION_ID = B.ORGANIZATION_ID
AND C.LOOKUP_TYPE = 'MTL_RELATIONSHIP_TYPES'
AND A.RELATIONSHIP_TYPE_ID = C.LOOKUP_CODE

Columns