VIEW: APPS.FPA_AW_PC_INFO_V

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))