VIEW: APPS.ASO_I_RELATED_ITEMS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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