View: ZX_PRODUCT_TYPES_DEF_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_PRODUCT_TYPES_DEF_V

View Text

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')