Product: | AS - Sales Foundation |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT INTCODE.CODE
, INTCODE.DESCRIPTION
, '_LA:INTCODE.ENABLED_FLAG:AS_LOOKUPS:FLAG:MEANING'
, INTCODE.CURRENCY_CODE
, INTCODE.PRICE
, '_DF:AS:AS_INTEREST_CODES:INTCODE' -- ID
, INTCODE.INTEREST_CODE_ID
, INTCODE.INTEREST_TYPE_ID
, INTCODE.PARENT_INTEREST_CODE_ID
, INTCODE.CATEGORY_ID
, INTCODE.CATEGORY_SET_ID
, INTCODE.ORG_ID
, INTCODE.PF_ITEM_ID
, INTCODE.PF_ORGANIZATION_ID -- WHO
, INTCODE.LAST_UPDATE_DATE
, INTCODE.LAST_UPDATED_BY
, INTCODE.CREATION_DATE
, INTCODE.CREATED_BY
FROM AS_INTEREST_CODES_ALL INTCODE
WHERE '_SEC:INTCODE.ORG_ID' IS NOT NULL WITH READ ONLY