[Home] [Help]
View: IGI_MHC_CAL_PRICE_INDEXES_V
Product: | IGI - Public Sector Financials International |
Description: | IGI_MHC_CAL_PRICE_INDEXES_V contains the names of the calendars and the price indexes attached to them. |
Implementation/DBA Data: |
APPS.IGI_MHC_CAL_PRICE_INDEXES_V
|
View Text
SELECT MPI.ROWID ROW_ID
, MPI. PRICE_INDEX_ID PRICE_INDEX_ID
, PI.PRICE_INDEX_NAME PRICE_INDEX_NAME
, MPI.CALENDAR_TYPE CALENDAR_TYPE
, CAL.DESCRIPTION DESCRIPTION
FROM FA_CALENDAR_TYPES CAL
, FA_PRICE_INDEXES PI
, IGI_MHC_CALENDAR_PRICE_INDEXES MPI
WHERE MPI.PRICE_INDEX_ID = PI.PRICE_INDEX_ID
AND MPI.CALENDAR_TYPE = CAL.CALENDAR_TYPE
Columns
Name |
ROW_ID |
PRICE_INDEX_ID |
PRICE_INDEX_NAME |
CALENDAR_TYPE |
DESCRIPTION |