VIEW: APPS.EGO_GTIN_COLOR_ATTRS_V

Source

View Text - Preformatted

SELECT MSI.INVENTORY_ITEM_ID, MSI.ORGANIZATION_ID, MXR.CROSS_REFERENCE GLOBAL_TRADING_ITEM_NUMBER, EGM.COLOR_CODE_VALUE, EGM.COLOR_CODE_LIST_AGENCY, NVL(EGO_USER_ATTRS_DATA_PVT.Get_Attr_Disp_Val_From_VSet ( 431 ,NULL ,EGM.COLOR_CODE_VALUE ,NULL ,'Color_Code_Value' ,'EGO_ITEM_GTIN_MULTI_ATTRS' ,'Gtin_Color_Description' ,NULL ,'EGO_ITEM' ,'INVENTORY_ITEM_ID' ,MSI.INVENTORY_ITEM_ID ,'ORGANIZATION_ID' ,MSI.ORGANIZATION_ID ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ) ,EGM.COLOR_CODE_VALUE ) AS COLOR_CODE_DESCRIPTION FROM MTL_SYSTEM_ITEMS_B MSI, MTL_CROSS_REFERENCES MXR, ego_itm_gtn_mul_attrs_b 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 = 'Gtin_Color_Description' AND application_id = 431)

View Text - HTML Formatted

SELECT MSI.INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID
, MXR.CROSS_REFERENCE GLOBAL_TRADING_ITEM_NUMBER
, EGM.COLOR_CODE_VALUE
, EGM.COLOR_CODE_LIST_AGENCY
, NVL(EGO_USER_ATTRS_DATA_PVT.GET_ATTR_DISP_VAL_FROM_VSET ( 431
, NULL
, EGM.COLOR_CODE_VALUE
, NULL
, 'COLOR_CODE_VALUE'
, 'EGO_ITEM_GTIN_MULTI_ATTRS'
, 'GTIN_COLOR_DESCRIPTION'
, NULL
, 'EGO_ITEM'
, 'INVENTORY_ITEM_ID'
, MSI.INVENTORY_ITEM_ID
, 'ORGANIZATION_ID'
, MSI.ORGANIZATION_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL )
, EGM.COLOR_CODE_VALUE ) AS COLOR_CODE_DESCRIPTION
FROM MTL_SYSTEM_ITEMS_B MSI
, MTL_CROSS_REFERENCES MXR
, EGO_ITM_GTN_MUL_ATTRS_B 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 = 'GTIN_COLOR_DESCRIPTION'
AND APPLICATION_ID = 431)