View: OE_RELATED_ITEMS_MV

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_RELATED_ITEMS_MV

View Text

SELECT MP.ORGANIZATION_ID
, REL.INVENTORY_ITEM_ID
, REL.RELATED_ITEM_ID
, REL.RELATIONSHIP_TYPE_ID
, LOOK.MEANING RELATIONSHIP_TYPE
, REL.RECIPROCAL_FLAG
, MV.ITEM_DESCRIPTION RELATED_ITEM_DESCRIPTION
, MV.ITEM RELATED_ITEM
, B.PRIMARY_UOM_CODE UOM
, B.LIST_PRICE_PER_UNIT UNIT_PRICE
, DECODE(REL.RELATIONSHIP_TYPE_ID
, 2
, 'R'
, 4
, 'R'
, 8
, 'R'
, 'A') SUBSTITUTION_TYPE
, B.CUSTOMER_ORDER_ENABLED_FLAG
, B.BOM_ITEM_TYPE
FROM MTL_RELATED_ITEMS_VIEW REL
, MFG_LOOKUPS LOOK
, OE_ITEMS_ORD_MV MV
, MTL_SYSTEM_ITEMS_B B
, MTL_PARAMETERS MP
WHERE REL.RELATED_ITEM_ID = MV.INVENTORY_ITEM_ID
AND REL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MV.ORGANIZATION_ID
AND LOOK.LOOKUP_TYPE='MTL_RELATIONSHIP_TYPES'
AND LOOK.ENABLED_FLAG ='Y'
AND SYSDATE BETWEEN NVL(LOOK.START_DATE_ACTIVE
, SYSDATE)
AND NVL(LOOK.END_DATE_ACTIVE
, SYSDATE)
AND REL.RELATIONSHIP_TYPE_ID = LOOK.LOOKUP_CODE
AND MV.ITEM_IDENTIFIER_TYPE = 'INT'
AND MV.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND MV.ORGANIZATION_ID = B.ORGANIZATION_ID
AND LOOK.LOOKUP_CODE <> '14'

Columns