-------------------------------------------------------------------------------------------------------------
Test Case :
================
CREATE TABLE ID_OWN_PS.TRANSACTION
(
  CURRENCY_FUNC_COD    NUMBER(12)         NOT NULL,
  DATA_TYPE_COD        NUMBER(12)         NOT NULL,
  GL_POST_ACCN_COD     NUMBER(12)         NOT NULL,
  PRDMKT_COD           NUMBER(12)         NOT NULL,
  SCENARIO_COD         NUMBER(12)         NOT NULL,
  ACCN_PERIOD_COD      NUMBER(12)         NOT NULL,
  TRANS_DES_VC         VARCHAR2(300 BYTE),
  CURRENCY_TRAN_COD    NUMBER(12)         NOT NULL,
  REP_ENT_COD          NUMBER(12)         NOT NULL,
  COST_CENTER_COD      NUMBER(12)         NOT NULL,
  ACCN_PERIOD_COD_1    NUMBER(12)         NOT NULL,
  ACCN_YEAR_COD_VC     VARCHAR2(100 BYTE) NOT NULL,
  CURR_ACCN_PERIOD_START_DT  DATE,
  FUNCT_AMNT_FAA_NB    NUMBER
);

Insert into ID_OWN_DW.ID_T_DW_MST_TIME_PER2FY
(CURRENCY_FUNC_COD, DATA_TYPE_COD, GL_POST_ACCN_COD, PRDMKT_COD, SCENARIO_COD, ACCN_PERIOD_COD, TRANS_DES_VC, CURRENCY_TRAN_COD, REP_ENT_COD, COST_CENTER_COD, ACCN_PERIOD_COD_1, ACCN_YEAR_COD_VC, CURR_ACCN_PERIOD_START_DT, FUNCT_AMNT_FAA_NB)
Values
(525, 1, 474094, 153383, 1, 943, 'AMEX', 525, 66013, 140103, 943, '2006', TO_DATE('02/27/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7.47);
Insert into ID_OWN_DW.ID_T_DW_MST_TIME_PER2FY
(CURRENCY_FUNC_COD, DATA_TYPE_COD, GL_POST_ACCN_COD, PRDMKT_COD, SCENARIO_COD, ACCN_PERIOD_COD, TRANS_DES_VC, CURRENCY_TRAN_COD, REP_ENT_COD, COST_CENTER_COD, ACCN_PERIOD_COD_1, ACCN_YEAR_COD_VC, CURR_ACCN_PERIOD_START_DT, FUNCT_AMNT_FAA_NB)
Values
(525, 1, 474094, 153383, 1, 943, 'AMEX', 525, 66013, 140103, 943, '2006', TO_DATE('02/27/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0.51);
Insert into ID_OWN_DW.ID_T_DW_MST_TIME_PER2FY
(CURRENCY_FUNC_COD, DATA_TYPE_COD, GL_POST_ACCN_COD, PRDMKT_COD, SCENARIO_COD, ACCN_PERIOD_COD, TRANS_DES_VC, CURRENCY_TRAN_COD, REP_ENT_COD, COST_CENTER_COD, ACCN_PERIOD_COD_1, ACCN_YEAR_COD_VC, CURR_ACCN_PERIOD_START_DT, FUNCT_AMNT_FAA_NB)
Values
(525, 1, 474094, 153383, 1, 943, 'AMEX', 525, 66013, 140103, 943, '2006', TO_DATE('02/27/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0.51);
Insert into ID_OWN_DW.ID_T_DW_MST_TIME_PER2FY
(CURRENCY_FUNC_COD, DATA_TYPE_COD, GL_POST_ACCN_COD, PRDMKT_COD, SCENARIO_COD, ACCN_PERIOD_COD, TRANS_DES_VC, CURRENCY_TRAN_COD, REP_ENT_COD, COST_CENTER_COD, ACCN_PERIOD_COD_1, ACCN_YEAR_COD_VC, CURR_ACCN_PERIOD_START_DT, FUNCT_AMNT_FAA_NB)
Values
(525, 1, 474094, 153383, 1, 943, 'AMEX', 525, 66013, 140103, 943, '2006', TO_DATE('02/27/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 43.53);
Insert into ID_OWN_DW.ID_T_DW_MST_TIME_PER2FY
(CURRENCY_FUNC_COD, DATA_TYPE_COD, GL_POST_ACCN_COD, PRDMKT_COD, SCENARIO_COD, ACCN_PERIOD_COD, TRANS_DES_VC, CURRENCY_TRAN_COD, REP_ENT_COD, COST_CENTER_COD, ACCN_PERIOD_COD_1, ACCN_YEAR_COD_VC, CURR_ACCN_PERIOD_START_DT, FUNCT_AMNT_FAA_NB)
Values
(525, 1, 474094, 153383, 1, 943, 'AMEX', 525, 66013, 140103, 943, '2006', TO_DATE('02/27/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 47.79);
Insert into ID_OWN_DW.ID_T_DW_MST_TIME_PER2FY
(CURRENCY_FUNC_COD, DATA_TYPE_COD, GL_POST_ACCN_COD, PRDMKT_COD, SCENARIO_COD, ACCN_PERIOD_COD, TRANS_DES_VC, CURRENCY_TRAN_COD, REP_ENT_COD, COST_CENTER_COD, ACCN_PERIOD_COD_1, ACCN_YEAR_COD_VC, CURR_ACCN_PERIOD_START_DT, FUNCT_AMNT_FAA_NB)
Values
(525, 1, 474094, 153383, 1, 943, 'AMEX', 525, 66013, 140103, 943, '2006', TO_DATE('02/27/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0.51);
Insert into ID_OWN_DW.ID_T_DW_MST_TIME_PER2FY
(CURRENCY_FUNC_COD, DATA_TYPE_COD, GL_POST_ACCN_COD, PRDMKT_COD, SCENARIO_COD, ACCN_PERIOD_COD, TRANS_DES_VC, CURRENCY_TRAN_COD, REP_ENT_COD, COST_CENTER_COD, ACCN_PERIOD_COD_1, ACCN_YEAR_COD_VC, CURR_ACCN_PERIOD_START_DT, FUNCT_AMNT_FAA_NB)
Values
(525, 1, 474094, 153383, 1, 943, 'AMEX', 525, 66013, 140103, 943, '2006', TO_DATE('02/27/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1.58);
Insert into ID_OWN_DW.ID_T_DW_MST_TIME_PER2FY
(CURRENCY_FUNC_COD, DATA_TYPE_COD, GL_POST_ACCN_COD, PRDMKT_COD, SCENARIO_COD, ACCN_PERIOD_COD, TRANS_DES_VC, CURRENCY_TRAN_COD, REP_ENT_COD, COST_CENTER_COD, ACCN_PERIOD_COD_1, ACCN_YEAR_COD_VC, CURR_ACCN_PERIOD_START_DT, FUNCT_AMNT_FAA_NB)
Values
(525, 1, 474094, 153383, 1, 943, 'AMEX', 525, 66013, 140103, 943, '2006', TO_DATE('02/27/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -43.53);
Insert into ID_OWN_DW.ID_T_DW_MST_TIME_PER2FY
(CURRENCY_FUNC_COD, DATA_TYPE_COD, GL_POST_ACCN_COD, PRDMKT_COD, SCENARIO_COD, ACCN_PERIOD_COD, TRANS_DES_VC, CURRENCY_TRAN_COD, REP_ENT_COD, COST_CENTER_COD, ACCN_PERIOD_COD_1, ACCN_YEAR_COD_VC, CURR_ACCN_PERIOD_START_DT, FUNCT_AMNT_FAA_NB)
Values
(525, 1, 474094, 153383, 1, 943, 'AMEX', 525, 66013, 140103, 943, '2006', TO_DATE('02/27/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7.41);
Insert into ID_OWN_DW.ID_T_DW_MST_TIME_PER2FY
(CURRENCY_FUNC_COD, DATA_TYPE_COD, GL_POST_ACCN_COD, PRDMKT_COD, SCENARIO_COD, ACCN_PERIOD_COD, TRANS_DES_VC, CURRENCY_TRAN_COD, REP_ENT_COD, COST_CENTER_COD, ACCN_PERIOD_COD_1, ACCN_YEAR_COD_VC, CURR_ACCN_PERIOD_START_DT, FUNCT_AMNT_FAA_NB)
Values
(525, 1, 474094, 153383, 1, 943, 'AMEX', 525, 66013, 140103, 943, '2006', TO_DATE('02/27/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 42.32);
Insert into ID_OWN_DW.ID_T_DW_MST_TIME_PER2FY
(CURRENCY_FUNC_COD, DATA_TYPE_COD, GL_POST_ACCN_COD, PRDMKT_COD, SCENARIO_COD, ACCN_PERIOD_COD, TRANS_DES_VC, CURRENCY_TRAN_COD, REP_ENT_COD, COST_CENTER_COD, ACCN_PERIOD_COD_1, ACCN_YEAR_COD_VC, CURR_ACCN_PERIOD_START_DT, FUNCT_AMNT_FAA_NB)
Values
(525, 1, 474094, 153383, 1, 943, 'AMEX', 525, 66013, 140103, 943, '2006', TO_DATE('02/27/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2.44);
Insert into ID_OWN_DW.ID_T_DW_MST_TIME_PER2FY
(CURRENCY_FUNC_COD, DATA_TYPE_COD, GL_POST_ACCN_COD, PRDMKT_COD, SCENARIO_COD, ACCN_PERIOD_COD, TRANS_DES_VC, CURRENCY_TRAN_COD, REP_ENT_COD, COST_CENTER_COD, ACCN_PERIOD_COD_1, ACCN_YEAR_COD_VC, CURR_ACCN_PERIOD_START_DT, FUNCT_AMNT_FAA_NB)
Values
(525, 1, 474094, 153383, 1, 943, 'AMEX', 525, 66013, 140103, 943, '2006', TO_DATE('02/27/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 13.91);
Insert into ID_OWN_DW.ID_T_DW_MST_TIME_PER2FY
(CURRENCY_FUNC_COD, DATA_TYPE_COD, GL_POST_ACCN_COD, PRDMKT_COD, SCENARIO_COD, ACCN_PERIOD_COD, TRANS_DES_VC, CURRENCY_TRAN_COD, REP_ENT_COD, COST_CENTER_COD, ACCN_PERIOD_COD_1, ACCN_YEAR_COD_VC, CURR_ACCN_PERIOD_START_DT, FUNCT_AMNT_FAA_NB)
Values
(525, 1, 474094, 153383, 1, 943, 'AMEX', 525, 66013, 140103, 943, '2006', TO_DATE('02/27/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8.36);
COMMIT;



-------------------------------------------------------------------------------------------------------------

Query used ( Example ) :
===========================

SELECT 
A.CURR, 
A.DATA_TYPE_COD, 
A.GL_POST_ACCN, 
A.PRDMKT_COD, 
A.SCENARIO_COD, 
A.ACCN_PERIOD_COD, 
A.TRANS_DES, 
A.CURRENCY_TRAN_COD, 
A.REP_ENT_COD, 
A.COST_CENTER, 
B.ACCN_PERIOD_COD, 
B.ACCN_YEAR, 
B.CURR_ACCN_START_DT, 
A.FUNC_AMNT, 
SUM(A.FUNC_AMNT) MONTH 
OVER 
( 
ORDER BY 
A.CURR, 
A.DATA_TYPE_COD, 
A.GL_POST_ACCN, 
A.PRDMKT_COD, 
A.SCENARIO_COD, 
A.ACCN_PERIOD_COD, 
A.TRANS_DES, 
A.CURRENCY_TRAN_COD, 
A.REP_ENT_COD, 
A.COST_CENTER, 
B.ACCN_PERIOD_COD, 
B.ACCN_YEAR, 
B.CURR_ACCN_START_DT, 
A.FUNC_AMNT 
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW 
) AS "YTD" 
FROM 
MASTER B, 
TRANSACTION A 
WHERE ( A.ACCN_PERIOD_COD = B.ACCN_PERIOD_COD );



-------------------------------------------------------------------------------------------------------------

Output generated for Yearly / Monthly :
===========================================

CURRENCY_FUNC_COD_SK_NB	DATA_TYPE_COD_SK_NB	GL_POST_ACCN_COD_SK_NB	PRDMKT_COD_SK_NB	SCENARIO_COD_SK_NB	ACCN_PERIOD_COD_SK_NB	TRANS_DES_VC	CURRENCY_TRAN_COD_SK_NB	REP_ENT_COD_SK_NB	COST_CENTER_COD_SK_NB	ACCN_PERIOD_COD_SK_NB_1	ACCN_YEAR_COD_VC	CURR_ACCN_PERIOD_START_DT	FUNCT_AMNT_FAA_NB	YTD
525	1	474094	153383	1	943	AMEX	525	66013	140103	943	2006	2/27/2006	-43.53	-43.53
525	1	474094	153383	1	943	AMEX	525	66013	140103	943	2006	2/27/2006	0.51	-43.02
525	1	474094	153383	1	943	AMEX	525	66013	140103	943	2006	2/27/2006	0.51	-42.51
525	1	474094	153383	1	943	AMEX	525	66013	140103	943	2006	2/27/2006	0.51	-42
525	1	474094	153383	1	943	AMEX	525	66013	140103	943	2006	2/27/2006	1.58	-40.42
525	1	474094	153383	1	943	AMEX	525	66013	140103	943	2006	2/27/2006	2.44	-37.98
525	1	474094	153383	1	943	AMEX	525	66013	140103	943	2006	2/27/2006	7.41	-30.57
525	1	474094	153383	1	943	AMEX	525	66013	140103	943	2006	2/27/2006	7.47	-23.1
525	1	474094	153383	1	943	AMEX	525	66013	140103	943	2006	2/27/2006	8.36	-14.74
525	1	474094	153383	1	943	AMEX	525	66013	140103	943	2006	2/27/2006	13.91	-0.83
525	1	474094	153383	1	943	AMEX	525	66013	140103	943	2006	2/27/2006	42.32	41.49
525	1	474094	153383	1	943	AMEX	525	66013	140103	943	2006	2/27/2006	43.53	85.02
525	1	474094	153383	1	943	AMEX	525	66013	140103	943	2006	2/27/2006	47.79	132.81


-------------------------------------------------------------------------------------------------------------