[Home] [Help]
View: EGO_ITEM_GTIN_V
Product: | EGO - Advanced Product Catalog |
Description: | View for item gtin details |
Implementation/DBA Data: |
APPS.EGO_ITEM_GTIN_V
|
View Text
SELECT MXR.INVENTORY_ITEM_ID
, MP.ORGANIZATION_ID
, MSIK.CONCATENATED_SEGMENTS ITEM_NUMBER
, MP.MASTER_ORGANIZATION_ID
, MXR.CROSS_REFERENCE GTIN
, MXR.DESCRIPTION
, MXR.ORG_INDEPENDENT_FLAG
, MXR.UOM_CODE
, MUOM.UNIT_OF_MEASURE
, MSIK.TRADE_ITEM_DESCRIPTOR
, EGA.PUBLICATION_STATUS
FROM MTL_CROSS_REFERENCES MXR
, MTL_SYSTEM_ITEMS_KFV MSIK
, MTL_UNITS_OF_MEASURE MUOM
, MTL_PARAMETERS MP
, EGO_ITEM_GTN_ATTRS_VL EGA
WHERE MSIK.INVENTORY_ITEM_ID = EGA.INVENTORY_ITEM_ID
AND MSIK.ORGANIZATION_ID = EGA.ORGANIZATION_ID
AND MSIK.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
AND MXR.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND NVL(MXR.ORGANIZATION_ID
, MSIK.ORGANIZATION_ID) = MSIK.ORGANIZATION_ID
AND MXR.UOM_CODE = MSIK.PRIMARY_UOM_CODE
AND MXR.CROSS_REFERENCE_TYPE = 'GTIN'
AND MUOM.UOM_CODE = MSIK.PRIMARY_UOM_CODE
Columns
Name |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
ITEM_NUMBER |
MASTER_ORGANIZATION_ID |
GTIN |
DESCRIPTION |
ORG_INDEPENDENT_FLAG |
UOM_CODE |
UNIT_OF_MEASURE |
TRADE_ITEM_DESCRIPTOR |
PUBLICATION_STATUS |