View: OE_RELATED_ITEMS_V

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

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
, T.DESCRIPTION RELATED_ITEM_DESCRIPTION
, B.CONCATENATED_SEGMENTS 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
, MTL_SYSTEM_ITEMS_TL T
, MTL_SYSTEM_ITEMS_B_KFV B
, MTL_PARAMETERS MP
WHERE REL.RELATED_ITEM_ID = B.INVENTORY_ITEM_ID
AND REL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
AND MP.ORGANIZATION_ID = B.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 B.BOM_ITEM_TYPE IN (1
, 4)
AND B.CUSTOMER_ORDER_ENABLED_FLAG = 'Y'
AND LOOK.LOOKUP_CODE <> '14'
AND B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
AND T.LANGUAGE = USERENV('LANG')
AND (TRUNC(SYSDATE) BETWEEN NVL(REL.START_DATE
, TRUNC(SYSDATE))
AND NVL(REL.END_DATE
, TRUNC(SYSDATE)))

Columns