[Home] [Help]
View: EGO_GTIN_HAND_INF_ATTRS_V
Product: | EGO - Advanced Product Catalog |
Description: | View for Handling information gtin attributes |
Implementation/DBA Data: |
APPS.EGO_GTIN_HAND_INF_ATTRS_V
|
View Text
SELECT MSI.INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID
, MXR.CROSS_REFERENCE GLOBAL_TRADE_ITEM_NUMBER
, DECODE(EGM.LANGUAGE
, 'US'
, 'EN'
, EGM.LANGUAGE) AS LANGUAGE
, EGM.SOURCE_LANG
, EGM.HANDLING_INSTRUCTIONS_CODE
FROM MTL_SYSTEM_ITEMS_B MSI
, MTL_CROSS_REFERENCES MXR
, EGO_ITM_GTN_MUL_ATTRS_TL EGM
, MTL_PARAMETERS MP
WHERE MSI.INVENTORY_ITEM_ID = EGM.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = EGM.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
AND MXR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND NVL(MXR.ORGANIZATION_ID
, MSI.ORGANIZATION_ID) = MSI.ORGANIZATION_ID
AND MXR.UOM_CODE = MSI.PRIMARY_UOM_CODE
AND MXR.CROSS_REFERENCE_TYPE = 'GTIN'
AND EGM.ATTR_GROUP_ID = (SELECT ATTR_GROUP_ID
FROM EGO_ATTR_GROUPS_V
WHERE ATTR_GROUP_TYPE = 'EGO_ITEM_GTIN_MULTI_ATTRS'
AND ATTR_GROUP_NAME = 'HANDLING_INFORMATION'
AND APPLICATION_ID = 431)
Columns
Name |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
GLOBAL_TRADE_ITEM_NUMBER |
LANGUAGE |
SOURCE_LANG |
HANDLING_INSTRUCTIONS_CODE |