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' -- RESOLVE FK
, INTTYPE.INTEREST_TYPE
, PARENT_INTCODE.CODE
, PARA.ORGANIZATION_CODE
, ORG.NAME -- 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 MTL_PARAMETERS PARA
, HR_ALL_ORGANIZATION_UNITS ORG
, AS_INTEREST_TYPES_ALL INTTYPE
, AS_INTEREST_CODES_ALL PARENT_INTCODE
, AS_INTEREST_CODES_ALL INTCODE
WHERE INTCODE.ORG_ID = PARA.ORGANIZATION_ID (+)
AND INTCODE.ORG_ID = ORG.ORGANIZATION_ID (+)
AND INTCODE.PARENT_INTEREST_CODE_ID = PARENT_INTCODE.INTEREST_CODE_ID (+)
AND INTCODE.INTEREST_TYPE_ID = INTTYPE.INTEREST_TYPE_ID AND '_SEC:INTCODE.ORG_ID' IS NOT NULL WITH READ ONLY