View: FPA_AW_PC_INFO_V

Product:	FPA - Project Portfolio Analysis
Description:
Implementation/DBA Data:	APPS.FPA_AW_PC_INFO_V

View Text

SELECT PLANNING_CYCLE
, PORTFOLIO
, PC_STATUS
, CALENDAR_NAME
, PERIOD_TYPE
, SUBMISSION_DUE_DATE
, INITIATE_DATE
, CONVERSION_RATE_DATE
, CURRENCY_CODE
, CONVERSION_RATE_TYPE
, FUNDING_PERIOD_FROM
, FUNDING_PERIOD_TO
, EFFECTIVE_PERIOD_TO
, PC_CATEGORY
, SCENARIO_COUNT
, LAST_APPROVED_FLAG
, LAST_FLAG
, CAL_PERIOD_TYPE FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_PC_INFO_TBL'
, ''
, 'DIMENSION PLANNING_CYCLE
FROM PLANNING_CYCLE_D WITH ATTRIBUTE PORTFOLIO
FROM PORTFOLIO_PC_R ATTRIBUTE PC_STATUS
FROM STATUS_PC_R ATTRIBUTE CALENDAR_NAME
FROM CALENDAR_PC_R ATTRIBUTE PERIOD_TYPE
FROM PERIOD_TYPE_PC_R ATTRIBUTE CAL_PERIOD_TYPE
FROM CAL_PERIOD_TYPE_PC_R ATTRIBUTE SUBMISSION_DUE_DATE
FROM PC_SUBMISSION_DUE_DATE_R ATTRIBUTE INITIATE_DATE
FROM PC_INITIATE_DATE_R ATTRIBUTE CONVERSION_RATE_DATE
FROM CURRENCY_DATE_PC_R MEASURE FUNDING_PERIOD_FROM
FROM PC_FUNDING_PERIOD_FROM_M MEASURE FUNDING_PERIOD_TO
FROM PC_FUNDING_PERIOD_TO_M MEASURE EFFECTIVE_PERIOD_TO
FROM PC_EFFECTIVE_PERIOD_TO_M MEASURE CURRENCY_CODE
FROM PC_CURRENCY_M MEASURE CONVERSION_RATE_TYPE
FROM PC_CONVERSION_RATE_TYPE_M MEASURE PC_CATEGORY
FROM PC_CATEGORY_M MEASURE SCENARIO_COUNT
FROM AW_EXPR STATLEN(LIMIT(SCENARIO_D TO PLANNING_CYCLE_SCENARIO_R EQ PLANNING_CYCLE_D)) MEASURE LAST_APPROVED_FLAG
FROM PC_LAST_APPROVED_FLAG_M MEASURE LAST_FLAG
FROM PC_LAST_FLAG_M'))

Columns