View: AS_INTEREST_CODES_MC_V

Product:	AS - Sales Foundation
Description:	View to show price and curreny code for a product family item associated with a secondary inyterest code.
Implementation/DBA Data:	APPS.AS_INTEREST_CODES_MC_V

View Text

SELECT MC.ROWID
, CODE.INTEREST_CODE_ID
, CODE.CODE
, MC.CURRENCY_CODE
, MC.PRICE
, MC.DESCRIPTION
, CODE.PF_ITEM_ID
, CODE.PF_ORGANIZATION_ID
, MC.LAST_UPDATE_DATE
, MC.LAST_UPDATED_BY
, MC.CREATION_DATE
, MC.CREATED_BY
, MC.LAST_UPDATE_LOGIN
FROM AS_INTEREST_CODES_V CODE
, AS_INTEREST_CODES_MC MC
WHERE MC.INTEREST_CODE_ID = CODE.INTEREST_CODE_ID
AND CODE.PARENT_INTEREST_CODE_ID IS NOT NULL

Columns