SELECT B.INTEREST_CODE_ID INTEREST_CODE_ID , T.CODE INTEREST_CODE , T.DESCRIPTION DESCRIPTION , MOC.ENABLED_FLAG ENABLED_FLAG , MOC.ORG_ID ORG_ID , B.INTEREST_TYPE_ID INTEREST_TYPE_ID , B.PARENT_INTEREST_CODE_ID PARENT_INTEREST_CODE_ID FROM AS_INTEREST_CODES_B B , AS_INTEREST_CODES_TL T , AS_INTEREST_CODES_ALL MOC , AS_INTEREST_TYPES_ALL MOT WHERE B.INTEREST_CODE_ID = T.INTEREST_CODE_ID AND B.INTEREST_CODE_ID = MOC.INTEREST_CODE_ID AND B.INTEREST_TYPE_ID = MOT.INTEREST_TYPE_ID AND MOC.ORG_ID = MOT.ORG_ID AND T.LANGUAGE = USERENV( 'LANG') AND NLS_UPPER(MOT.EXPECTED_PURCHASE_FLAG) = 'Y' WITH READ ONLY