[Home] [Help]
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
Name |
ORGNID |
ITEMID |
ITEMCODE |
INGREDIENTCODE |
INGREDIENTNAME |
CLASSIFICATION |
CLASSIFICATIONTYPE |
PERCENT1 |
PERCENT1QUALIFIER |
PERCENTWEIGHTVOLUMEIDENTIFIER |