VIEW: APPS.ZX_PRODUCT_TYPES_DEF_V

Source

View Text - Preformatted

SELECT F.LOOKUP_CODE, F.MEANING, I.INVENTORY_ITEM_ID,I.ORGANIZATION_ID
    FROM FND_LOOKUPS F,
         MTL_SYSTEM_ITEMS_B I
    WHERE  F.LOOKUP_TYPE= 'ZX_PRODUCT_TYPE'
    AND    F.LOOKUP_CODE =  DECODE (I.CONTRACT_ITEM_TYPE_CODE,
                     'SERVICE','SERVICES',
                     'WARRANTY','SERVICES',
                     'USAGE','SERVICES',
                     'SUBSCRIPTION','GOODS',
                     'GOODS')

   

View Text - HTML Formatted

SELECT F.LOOKUP_CODE
, F.MEANING
, I.INVENTORY_ITEM_ID
, I.ORGANIZATION_ID
FROM FND_LOOKUPS F
, MTL_SYSTEM_ITEMS_B I
WHERE F.LOOKUP_TYPE= 'ZX_PRODUCT_TYPE'
AND F.LOOKUP_CODE = DECODE (I.CONTRACT_ITEM_TYPE_CODE
, 'SERVICE'
, 'SERVICES'
, 'WARRANTY'
, 'SERVICES'
, 'USAGE'
, 'SERVICES'
, 'SUBSCRIPTION'
, 'GOODS'
, 'GOODS')