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