DBA Data[Home] [Help]

VIEW: APPS.XTR_DEAL_OVERWRITE_TYPES_V

Source

View Text - Preformatted

SELECT xdo.DEAL_OVERWRITE_TYPE_ID, xdo.CREATED_BY, xdo.CREATION_DATE, xdo.LAST_UPDATED_BY, xdo.LAST_UPDATE_DATE, xdo.LAST_UPDATE_LOGIN, xdo.DEAL_TYPE, xdo.CODE, xdo.AUTHORIZED, fnd.MEANING as CODE_MNG from XTR_DEAL_OVERWRITE_TYPES xdo, FND_LOOKUPS fnd WHERE fnd.LOOKUP_TYPE = 'XTR_DEAL_OVERWRITE_TYPE_CODE'
View Text - HTML Formatted

SELECT XDO.DEAL_OVERWRITE_TYPE_ID
, XDO.CREATED_BY
, XDO.CREATION_DATE
, XDO.LAST_UPDATED_BY
, XDO.LAST_UPDATE_DATE
, XDO.LAST_UPDATE_LOGIN
, XDO.DEAL_TYPE
, XDO.CODE
, XDO.AUTHORIZED
, FND.MEANING AS CODE_MNG
FROM XTR_DEAL_OVERWRITE_TYPES XDO
, FND_LOOKUPS FND
WHERE FND.LOOKUP_TYPE = 'XTR_DEAL_OVERWRITE_TYPE_CODE'