VIEW: APPS.ENI_ITEM_V

Source

View Text - Preformatted

SELECT STAR.ID ,STAR.VALUE ,DECODE(STAR.INVENTORY_ITEM_ID, -1, (SELECT DESCRIPTION FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'ITEM' AND LOOKUP_CODE = '-1' AND LANGUAGE = USERENV('LANG')), MTI_TL.DESCRIPTION) DESCRIPTION ,STAR.INVENTORY_ITEM_ID ,DECODE(STAR.ORGANIZATION_ID, -99, NULL, STAR.ORGANIZATION_ID) ,STAR.VBH_CATEGORY_ID ,DECODE(STAR.VBH_CATEGORY_ID, -1, (SELECT DESCRIPTION FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'ITEM_CATG' AND LOOKUP_CODE = '-1' AND LANGUAGE = USERENV('LANG')), CTL.DESCRIPTION) ,STAR.PRIMARY_UOM_CODE ,STAR.CREATION_DATE ,STAR.LAST_UPDATE_DATE ,STAR.UNIT_WEIGHT ,STAR.UNIT_VOLUME ,STAR.WEIGHT_UOM_CODE ,STAR.VOLUME_UOM_CODE ,MTI_TL.DESCRIPTION FROM ENI_OLTP_ITEM_STAR STAR, MTL_SYSTEM_ITEMS_TL MTI_TL, MTL_CATEGORIES_TL CTL WHERE STAR.MASTER_ID IS NULL AND STAR.INVENTORY_ITEM_ID = MTI_TL.INVENTORY_ITEM_ID(+) AND STAR.ORGANIZATION_ID = MTI_TL.ORGANIZATION_ID(+) AND MTI_TL.LANGUAGE(+) = USERENV('LANG') AND STAR.VBH_CATEGORY_ID = CTL.CATEGORY_ID(+) AND CTL.LANGUAGE(+) = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT STAR.ID
, STAR.VALUE
, DECODE(STAR.INVENTORY_ITEM_ID
, -1
, (SELECT DESCRIPTION
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'ITEM'
AND LOOKUP_CODE = '-1'
AND LANGUAGE = USERENV('LANG'))
, MTI_TL.DESCRIPTION) DESCRIPTION
, STAR.INVENTORY_ITEM_ID
, DECODE(STAR.ORGANIZATION_ID
, -99
, NULL
, STAR.ORGANIZATION_ID)
, STAR.VBH_CATEGORY_ID
, DECODE(STAR.VBH_CATEGORY_ID
, -1
, (SELECT DESCRIPTION
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'ITEM_CATG'
AND LOOKUP_CODE = '-1'
AND LANGUAGE = USERENV('LANG'))
, CTL.DESCRIPTION)
, STAR.PRIMARY_UOM_CODE
, STAR.CREATION_DATE
, STAR.LAST_UPDATE_DATE
, STAR.UNIT_WEIGHT
, STAR.UNIT_VOLUME
, STAR.WEIGHT_UOM_CODE
, STAR.VOLUME_UOM_CODE
, MTI_TL.DESCRIPTION
FROM ENI_OLTP_ITEM_STAR STAR
, MTL_SYSTEM_ITEMS_TL MTI_TL
, MTL_CATEGORIES_TL CTL
WHERE STAR.MASTER_ID IS NULL
AND STAR.INVENTORY_ITEM_ID = MTI_TL.INVENTORY_ITEM_ID(+)
AND STAR.ORGANIZATION_ID = MTI_TL.ORGANIZATION_ID(+)
AND MTI_TL.LANGUAGE(+) = USERENV('LANG')
AND STAR.VBH_CATEGORY_ID = CTL.CATEGORY_ID(+)
AND CTL.LANGUAGE(+) = USERENV('LANG') WITH READ ONLY