[Home] [Help]
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
Name |
ROW_ID |
INTEREST_CODE_ID |
CODE |
CURRENCY_CODE |
PRICE |
DESCRIPTION |
PF_ITEM_ID |
PF_ORGANIZATION_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |