View: GR_ITEMS_INGRED_XML

Product:	GR - Process Manufacturing Regulatory Management
Description:	View for Master Item Associations + Inventory Item and its associated Inventory Items details
Implementation/DBA Data:	APPS.GR_ITEMS_INGRED_XML

View Text

SELECT C.ORGANIZATION_ID ORGNID
, C.PRODUCT_ITEM_ID ITEMID
, M.CONCATENATED_SEGMENTS ITEMCODE
, G.CONCATENATED_SEGMENTS INGREDIENTCODE
, G.DESCRIPTION INGREDIENTNAME
, G.CAS_NUMBER CLASSIFICATION
, 'CAS NO.' CLASSIFICATIONTYPE
, C.CONCENTRATION_PERCENTAGE PERCENT1
, '=' PERCENT1QUALIFIER
, 'W' PERCENTWEIGHTVOLUMEIDENTIFIER
FROM GR_INGREDIENT_CONCENTRATIONS C
, MTL_SYSTEM_ITEMS_KFV G
, MTL_SYSTEM_ITEMS_KFV M
WHERE C.INGREDIENT_ITEM_ID = G.INVENTORY_ITEM_ID
AND C.ORGANIZATION_ID = G.ORGANIZATION_ID
AND C.PRODUCT_ITEM_ID = M.INVENTORY_ITEM_ID
AND C.ORGANIZATION_ID = M.ORGANIZATION_ID

Columns