eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CE_FC_AMTS_BANK_V

Source

View Text - Preformatted


SELECT NVL(BA.BANK_ACCOUNT_NAME,L.MEANING), BA.BANK_ACCOUNT_NUM, BA.CURRENCY_CODE, DECODE(NVL(BA.BANK_ACCOUNT_NAME,'Others'),'Others',L.MEANING, BA.BANK_ACCOUNT_NAME || ', ' || BA.BANK_ACCOUNT_NUM || ', ' || BA.CURRENCY_CODE), DECODE(NVL(BA.BANK_ACCOUNT_NAME,'Others'),'Others',1,0), NET.BANK_ACCOUNT_ID, DECODE(F.FACTOR,0,NVL(BAL.OPENING_BALANCE,0),ROUND(NVL(BAL.OPENING_BALANCE,0)/F.FACTOR)), BAL.BALANCE_DATE, DECODE(F.FACTOR,0,NVL(BAL.PRIOR_DAY_CFLOW,0),ROUND(NVL(BAL.PRIOR_DAY_CFLOW,0)/F.FACTOR)), DECODE(F.FACTOR,0,(NET.FCAMT0 + NET.FCAMT1 + NET.FCAMT2 + NET.FCAMT3 + NET.FCAMT4 + NET.FCAMT5 + NET.FCAMT6 + NET.FCAMT7 + NET.FCAMT8 + NET.FCAMT9 + NET.FCAMT10 + NET.FCAMT11 + NET.FCAMT12 + NET.FCAMT13 + NET.FCAMT14 + NET.FCAMT15 + NET.FCAMT16 + NET.FCAMT17 + NET.FCAMT18 + NET.FCAMT19 + NET.FCAMT20 + NET.FCAMT21 + NET.FCAMT22 + NET.FCAMT23 + NET.FCAMT24 + NET.FCAMT25 + NET.FCAMT26 + NET.FCAMT27 + NET.FCAMT28 + NET.FCAMT29 + NET.FCAMT30 + NET.FCAMT31 + NET.FCAMT32 + NET.FCAMT33 + NET.FCAMT34 + NET.FCAMT35 + NET.FCAMT36 + NET.FCAMT37 + NET.FCAMT38 + NET.FCAMT39 + NET.FCAMT40 + NET.FCAMT41 + NET.FCAMT42 + NET.FCAMT43 + NET.FCAMT44 + NET.FCAMT45 + NET.FCAMT46 + NET.FCAMT47 + NET.FCAMT48 + NET.FCAMT49 + NET.FCAMT50 + NET.FCAMT51 + NET.FCAMT52 + NET.FCAMT53 + NET.FCAMT54 + NET.FCAMT55 + NET.FCAMT56 + NET.FCAMT57 + NET.FCAMT58 + NET.FCAMT59 + NET.FCAMT60 + NET.FCAMT61 + NET.FCAMT62 + NET.FCAMT63 + NET.FCAMT64 + NET.FCAMT65 + NET.FCAMT66 + NET.FCAMT67 + NET.FCAMT68 + NET.FCAMT69 + NET.FCAMT70 + NET.FCAMT71 + NET.FCAMT72 + NET.FCAMT73 + NET.FCAMT74 + NET.FCAMT75 + NET.FCAMT76 + NET.FCAMT78 + NET.FCAMT79 + NET.FCAMT80), ROUND((NET.FCAMT0 + NET.FCAMT1 + NET.FCAMT2 + NET.FCAMT3 + NET.FCAMT4 + NET.FCAMT5 + NET.FCAMT6 + NET.FCAMT7 + NET.FCAMT8 + NET.FCAMT9 + NET.FCAMT10 + NET.FCAMT11 + NET.FCAMT12 + NET.FCAMT13 + NET.FCAMT14 + NET.FCAMT15 + NET.FCAMT16 + NET.FCAMT17 + NET.FCAMT18 + NET.FCAMT19 + NET.FCAMT20 + NET.FCAMT21 + NET.FCAMT22 + NET.FCAMT23 + NET.FCAMT24 + NET.FCAMT25 + NET.FCAMT26 + NET.FCAMT27 + NET.FCAMT28 + NET.FCAMT29 + NET.FCAMT30 + NET.FCAMT31 + NET.FCAMT32 + NET.FCAMT33 + NET.FCAMT34 + NET.FCAMT35 + NET.FCAMT36 + NET.FCAMT37 + NET.FCAMT38 + NET.FCAMT39 + NET.FCAMT40 + NET.FCAMT41 + NET.FCAMT42 + NET.FCAMT43 + NET.FCAMT44 + NET.FCAMT45 + NET.FCAMT46 + NET.FCAMT47 + NET.FCAMT48 + NET.FCAMT49 + NET.FCAMT50 + NET.FCAMT51 + NET.FCAMT52 + NET.FCAMT53 + NET.FCAMT54 + NET.FCAMT55 + NET.FCAMT56 + NET.FCAMT57 + NET.FCAMT58 + NET.FCAMT59 + NET.FCAMT60 + NET.FCAMT61 + NET.FCAMT62 + NET.FCAMT63 + NET.FCAMT64 + NET.FCAMT65 + NET.FCAMT66 + NET.FCAMT67 + NET.FCAMT68 + NET.FCAMT69 + NET.FCAMT70 + NET.FCAMT71 + NET.FCAMT72 + NET.FCAMT73 + NET.FCAMT74 + NET.FCAMT75 + NET.FCAMT76 + NET.FCAMT78 + NET.FCAMT79 + NET.FCAMT80)/F.FACTOR)), DECODE(F.FACTOR,0,(NVL(BAL.OPENING_BALANCE,0) + NVL(BAL.PRIOR_DAY_CFLOW,0) + NET.FCAMT0 + NET.FCAMT1 + NET.FCAMT2 + NET.FCAMT3 + NET.FCAMT4 + NET.FCAMT5 + NET.FCAMT6 + NET.FCAMT7 + NET.FCAMT8 + NET.FCAMT9 + NET.FCAMT10 + NET.FCAMT11 + NET.FCAMT12 + NET.FCAMT13 + NET.FCAMT14 + NET.FCAMT15 + NET.FCAMT16 + NET.FCAMT17 + NET.FCAMT18 + NET.FCAMT19 + NET.FCAMT20 + NET.FCAMT21 + NET.FCAMT22 + NET.FCAMT23 + NET.FCAMT24 + NET.FCAMT25 + NET.FCAMT26 + NET.FCAMT27 + NET.FCAMT28 + NET.FCAMT29 + NET.FCAMT30 + NET.FCAMT31 + NET.FCAMT32 + NET.FCAMT33 + NET.FCAMT34 + NET.FCAMT35 + NET.FCAMT36 + NET.FCAMT37 + NET.FCAMT38 + NET.FCAMT39 + NET.FCAMT40 + NET.FCAMT41 + NET.FCAMT42 + NET.FCAMT43 + NET.FCAMT44 + NET.FCAMT45 + NET.FCAMT46 + NET.FCAMT47 + NET.FCAMT48 + NET.FCAMT49 + NET.FCAMT50 + NET.FCAMT51 + NET.FCAMT52 + NET.FCAMT53 + NET.FCAMT54 + NET.FCAMT55 + NET.FCAMT56 + NET.FCAMT57 + NET.FCAMT58 + NET.FCAMT59 + NET.FCAMT60 + NET.FCAMT61 + NET.FCAMT62 + NET.FCAMT63 + NET.FCAMT64 + NET.FCAMT65 + NET.FCAMT66 + NET.FCAMT67 + NET.FCAMT68 + NET.FCAMT69 + NET.FCAMT70 + NET.FCAMT71 + NET.FCAMT72 + NET.FCAMT73 + NET.FCAMT74 + NET.FCAMT75 + NET.FCAMT76 + NET.FCAMT78 + NET.FCAMT79 + NET.FCAMT80), ROUND((NVL(BAL.OPENING_BALANCE,0) + NVL(BAL.PRIOR_DAY_CFLOW,0) + NET.FCAMT0 + NET.FCAMT1 + NET.FCAMT2 + NET.FCAMT3 + NET.FCAMT4 + NET.FCAMT5 + NET.FCAMT6 + NET.FCAMT7 + NET.FCAMT8 + NET.FCAMT9 + NET.FCAMT10 + NET.FCAMT11 + NET.FCAMT12 + NET.FCAMT13 + NET.FCAMT14 + NET.FCAMT15 + NET.FCAMT16 + NET.FCAMT17 + NET.FCAMT18 + NET.FCAMT19 + NET.FCAMT20 + NET.FCAMT21 + NET.FCAMT22 + NET.FCAMT23 + NET.FCAMT24 + NET.FCAMT25 + NET.FCAMT26 + NET.FCAMT27 + NET.FCAMT28 + NET.FCAMT29 + NET.FCAMT30 + NET.FCAMT31 + NET.FCAMT32 + NET.FCAMT33 + NET.FCAMT34 + NET.FCAMT35 + NET.FCAMT36 + NET.FCAMT37 + NET.FCAMT38 + NET.FCAMT39 + NET.FCAMT40 + NET.FCAMT41 + NET.FCAMT42 + NET.FCAMT43 + NET.FCAMT44 + NET.FCAMT45 + NET.FCAMT46 + NET.FCAMT47 + NET.FCAMT48 + NET.FCAMT49 + NET.FCAMT50 + NET.FCAMT51 + NET.FCAMT52 + NET.FCAMT53 + NET.FCAMT54 + NET.FCAMT55 + NET.FCAMT56 + NET.FCAMT57 + NET.FCAMT58 + NET.FCAMT59 + NET.FCAMT60 + NET.FCAMT61 + NET.FCAMT62 + NET.FCAMT63 + NET.FCAMT64 + NET.FCAMT65 + NET.FCAMT66 + NET.FCAMT67 + NET.FCAMT68 + NET.FCAMT69 + NET.FCAMT70 + NET.FCAMT71 + NET.FCAMT72 + NET.FCAMT73 + NET.FCAMT74 + NET.FCAMT75 + NET.FCAMT76 + NET.FCAMT78 + NET.FCAMT79 + NET.FCAMT80)/F.FACTOR)), NET.FORECAST_ID, DECODE(F.FACTOR,0,NET.FCAMT0,ROUND(NET.FCAMT0/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT1,ROUND(NET.FCAMT1/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT2,ROUND(NET.FCAMT2/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT3,ROUND(NET.FCAMT3/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT4,ROUND(NET.FCAMT4/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT5,ROUND(NET.FCAMT5/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT6,ROUND(NET.FCAMT6/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT7,ROUND(NET.FCAMT7/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT8,ROUND(NET.FCAMT8/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT9,ROUND(NET.FCAMT9/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT10,ROUND(NET.FCAMT10/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT11,ROUND(NET.FCAMT11/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT12,ROUND(NET.FCAMT12/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT13,ROUND(NET.FCAMT13/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT14,ROUND(NET.FCAMT14/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT15,ROUND(NET.FCAMT15/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT16,ROUND(NET.FCAMT16/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT17,ROUND(NET.FCAMT17/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT18,ROUND(NET.FCAMT18/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT19,ROUND(NET.FCAMT19/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT20,ROUND(NET.FCAMT20/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT21,ROUND(NET.FCAMT21/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT22,ROUND(NET.FCAMT22/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT23,ROUND(NET.FCAMT23/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT24,ROUND(NET.FCAMT24/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT25,ROUND(NET.FCAMT25/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT26,ROUND(NET.FCAMT26/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT27,ROUND(NET.FCAMT27/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT28,ROUND(NET.FCAMT28/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT29,ROUND(NET.FCAMT29/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT30,ROUND(NET.FCAMT30/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT31,ROUND(NET.FCAMT31/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT32,ROUND(NET.FCAMT32/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT33,ROUND(NET.FCAMT33/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT34,ROUND(NET.FCAMT34/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT35,ROUND(NET.FCAMT35/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT36,ROUND(NET.FCAMT36/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT37,ROUND(NET.FCAMT37/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT38,ROUND(NET.FCAMT38/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT39,ROUND(NET.FCAMT39/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT40,ROUND(NET.FCAMT40/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT41,ROUND(NET.FCAMT41/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT42,ROUND(NET.FCAMT42/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT43,ROUND(NET.FCAMT43/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT44,ROUND(NET.FCAMT44/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT45,ROUND(NET.FCAMT45/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT46,ROUND(NET.FCAMT46/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT47,ROUND(NET.FCAMT47/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT48,ROUND(NET.FCAMT48/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT49,ROUND(NET.FCAMT49/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT50,ROUND(NET.FCAMT50/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT51,ROUND(NET.FCAMT51/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT52,ROUND(NET.FCAMT52/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT53,ROUND(NET.FCAMT53/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT54,ROUND(NET.FCAMT54/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT55,ROUND(NET.FCAMT55/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT56,ROUND(NET.FCAMT56/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT57,ROUND(NET.FCAMT57/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT58,ROUND(NET.FCAMT58/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT59,ROUND(NET.FCAMT59/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT60,ROUND(NET.FCAMT60/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT61,ROUND(NET.FCAMT61/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT62,ROUND(NET.FCAMT62/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT63,ROUND(NET.FCAMT63/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT64,ROUND(NET.FCAMT64/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT65,ROUND(NET.FCAMT65/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT66,ROUND(NET.FCAMT66/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT67,ROUND(NET.FCAMT67/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT68,ROUND(NET.FCAMT68/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT69,ROUND(NET.FCAMT69/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT70,ROUND(NET.FCAMT70/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT71,ROUND(NET.FCAMT71/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT72,ROUND(NET.FCAMT72/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT73,ROUND(NET.FCAMT73/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT74,ROUND(NET.FCAMT74/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT75,ROUND(NET.FCAMT75/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT76,ROUND(NET.FCAMT76/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT77,ROUND(NET.FCAMT77/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT78,ROUND(NET.FCAMT78/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT79,ROUND(NET.FCAMT79/F.FACTOR)), DECODE(F.FACTOR,0,NET.FCAMT80,ROUND(NET.FCAMT80/F.FACTOR)), NET.XTR_USER FROM CE_FC_BANK_NETFLOW_V NET, CE_BANK_ACCOUNTS BA, CE_FORECAST_OPENING_BAL BAL, CE_FORECASTS F, CE_LOOKUPS L WHERE NET.BANK_ACCOUNT_ID = BA.BANK_ACCOUNT_ID(+) AND NET.BANK_ACCOUNT_ID = BAL.BANK_ACCOUNT_ID(+) AND L.LOOKUP_TYPE = 'FC_MISC' AND L.LOOKUP_CODE = 'OTHERS' AND NET.FORECAST_ID = BAL.FORECAST_ID(+) AND NET.FORECAST_ID = F.FORECAST_ID AND NVL(BAL.BALANCE_TYPE,'BANK') = 'BANK'

View Text - HTML Formatted

SELECT NVL(BA.BANK_ACCOUNT_NAME
, L.MEANING)
, BA.BANK_ACCOUNT_NUM
, BA.CURRENCY_CODE
, DECODE(NVL(BA.BANK_ACCOUNT_NAME
, 'OTHERS')
, 'OTHERS'
, L.MEANING
, BA.BANK_ACCOUNT_NAME || '
, ' || BA.BANK_ACCOUNT_NUM || '
, ' || BA.CURRENCY_CODE)
, DECODE(NVL(BA.BANK_ACCOUNT_NAME
, 'OTHERS')
, 'OTHERS'
, 1
, 0)
, NET.BANK_ACCOUNT_ID
, DECODE(F.FACTOR
, 0
, NVL(BAL.OPENING_BALANCE
, 0)
, ROUND(NVL(BAL.OPENING_BALANCE
, 0)/F.FACTOR))
, BAL.BALANCE_DATE
, DECODE(F.FACTOR
, 0
, NVL(BAL.PRIOR_DAY_CFLOW
, 0)
, ROUND(NVL(BAL.PRIOR_DAY_CFLOW
, 0)/F.FACTOR))
, DECODE(F.FACTOR
, 0
, (NET.FCAMT0 + NET.FCAMT1 + NET.FCAMT2 + NET.FCAMT3 + NET.FCAMT4 + NET.FCAMT5 + NET.FCAMT6 + NET.FCAMT7 + NET.FCAMT8 + NET.FCAMT9 + NET.FCAMT10 + NET.FCAMT11 + NET.FCAMT12 + NET.FCAMT13 + NET.FCAMT14 + NET.FCAMT15 + NET.FCAMT16 + NET.FCAMT17 + NET.FCAMT18 + NET.FCAMT19 + NET.FCAMT20 + NET.FCAMT21 + NET.FCAMT22 + NET.FCAMT23 + NET.FCAMT24 + NET.FCAMT25 + NET.FCAMT26 + NET.FCAMT27 + NET.FCAMT28 + NET.FCAMT29 + NET.FCAMT30 + NET.FCAMT31 + NET.FCAMT32 + NET.FCAMT33 + NET.FCAMT34 + NET.FCAMT35 + NET.FCAMT36 + NET.FCAMT37 + NET.FCAMT38 + NET.FCAMT39 + NET.FCAMT40 + NET.FCAMT41 + NET.FCAMT42 + NET.FCAMT43 + NET.FCAMT44 + NET.FCAMT45 + NET.FCAMT46 + NET.FCAMT47 + NET.FCAMT48 + NET.FCAMT49 + NET.FCAMT50 + NET.FCAMT51 + NET.FCAMT52 + NET.FCAMT53 + NET.FCAMT54 + NET.FCAMT55 + NET.FCAMT56 + NET.FCAMT57 + NET.FCAMT58 + NET.FCAMT59 + NET.FCAMT60 + NET.FCAMT61 + NET.FCAMT62 + NET.FCAMT63 + NET.FCAMT64 + NET.FCAMT65 + NET.FCAMT66 + NET.FCAMT67 + NET.FCAMT68 + NET.FCAMT69 + NET.FCAMT70 + NET.FCAMT71 + NET.FCAMT72 + NET.FCAMT73 + NET.FCAMT74 + NET.FCAMT75 + NET.FCAMT76 + NET.FCAMT78 + NET.FCAMT79 + NET.FCAMT80)
, ROUND((NET.FCAMT0 + NET.FCAMT1 + NET.FCAMT2 + NET.FCAMT3 + NET.FCAMT4 + NET.FCAMT5 + NET.FCAMT6 + NET.FCAMT7 + NET.FCAMT8 + NET.FCAMT9 + NET.FCAMT10 + NET.FCAMT11 + NET.FCAMT12 + NET.FCAMT13 + NET.FCAMT14 + NET.FCAMT15 + NET.FCAMT16 + NET.FCAMT17 + NET.FCAMT18 + NET.FCAMT19 + NET.FCAMT20 + NET.FCAMT21 + NET.FCAMT22 + NET.FCAMT23 + NET.FCAMT24 + NET.FCAMT25 + NET.FCAMT26 + NET.FCAMT27 + NET.FCAMT28 + NET.FCAMT29 + NET.FCAMT30 + NET.FCAMT31 + NET.FCAMT32 + NET.FCAMT33 + NET.FCAMT34 + NET.FCAMT35 + NET.FCAMT36 + NET.FCAMT37 + NET.FCAMT38 + NET.FCAMT39 + NET.FCAMT40 + NET.FCAMT41 + NET.FCAMT42 + NET.FCAMT43 + NET.FCAMT44 + NET.FCAMT45 + NET.FCAMT46 + NET.FCAMT47 + NET.FCAMT48 + NET.FCAMT49 + NET.FCAMT50 + NET.FCAMT51 + NET.FCAMT52 + NET.FCAMT53 + NET.FCAMT54 + NET.FCAMT55 + NET.FCAMT56 + NET.FCAMT57 + NET.FCAMT58 + NET.FCAMT59 + NET.FCAMT60 + NET.FCAMT61 + NET.FCAMT62 + NET.FCAMT63 + NET.FCAMT64 + NET.FCAMT65 + NET.FCAMT66 + NET.FCAMT67 + NET.FCAMT68 + NET.FCAMT69 + NET.FCAMT70 + NET.FCAMT71 + NET.FCAMT72 + NET.FCAMT73 + NET.FCAMT74 + NET.FCAMT75 + NET.FCAMT76 + NET.FCAMT78 + NET.FCAMT79 + NET.FCAMT80)/F.FACTOR))
, DECODE(F.FACTOR
, 0
, (NVL(BAL.OPENING_BALANCE
, 0) + NVL(BAL.PRIOR_DAY_CFLOW
, 0) + NET.FCAMT0 + NET.FCAMT1 + NET.FCAMT2 + NET.FCAMT3 + NET.FCAMT4 + NET.FCAMT5 + NET.FCAMT6 + NET.FCAMT7 + NET.FCAMT8 + NET.FCAMT9 + NET.FCAMT10 + NET.FCAMT11 + NET.FCAMT12 + NET.FCAMT13 + NET.FCAMT14 + NET.FCAMT15 + NET.FCAMT16 + NET.FCAMT17 + NET.FCAMT18 + NET.FCAMT19 + NET.FCAMT20 + NET.FCAMT21 + NET.FCAMT22 + NET.FCAMT23 + NET.FCAMT24 + NET.FCAMT25 + NET.FCAMT26 + NET.FCAMT27 + NET.FCAMT28 + NET.FCAMT29 + NET.FCAMT30 + NET.FCAMT31 + NET.FCAMT32 + NET.FCAMT33 + NET.FCAMT34 + NET.FCAMT35 + NET.FCAMT36 + NET.FCAMT37 + NET.FCAMT38 + NET.FCAMT39 + NET.FCAMT40 + NET.FCAMT41 + NET.FCAMT42 + NET.FCAMT43 + NET.FCAMT44 + NET.FCAMT45 + NET.FCAMT46 + NET.FCAMT47 + NET.FCAMT48 + NET.FCAMT49 + NET.FCAMT50 + NET.FCAMT51 + NET.FCAMT52 + NET.FCAMT53 + NET.FCAMT54 + NET.FCAMT55 + NET.FCAMT56 + NET.FCAMT57 + NET.FCAMT58 + NET.FCAMT59 + NET.FCAMT60 + NET.FCAMT61 + NET.FCAMT62 + NET.FCAMT63 + NET.FCAMT64 + NET.FCAMT65 + NET.FCAMT66 + NET.FCAMT67 + NET.FCAMT68 + NET.FCAMT69 + NET.FCAMT70 + NET.FCAMT71 + NET.FCAMT72 + NET.FCAMT73 + NET.FCAMT74 + NET.FCAMT75 + NET.FCAMT76 + NET.FCAMT78 + NET.FCAMT79 + NET.FCAMT80)
, ROUND((NVL(BAL.OPENING_BALANCE
, 0) + NVL(BAL.PRIOR_DAY_CFLOW
, 0) + NET.FCAMT0 + NET.FCAMT1 + NET.FCAMT2 + NET.FCAMT3 + NET.FCAMT4 + NET.FCAMT5 + NET.FCAMT6 + NET.FCAMT7 + NET.FCAMT8 + NET.FCAMT9 + NET.FCAMT10 + NET.FCAMT11 + NET.FCAMT12 + NET.FCAMT13 + NET.FCAMT14 + NET.FCAMT15 + NET.FCAMT16 + NET.FCAMT17 + NET.FCAMT18 + NET.FCAMT19 + NET.FCAMT20 + NET.FCAMT21 + NET.FCAMT22 + NET.FCAMT23 + NET.FCAMT24 + NET.FCAMT25 + NET.FCAMT26 + NET.FCAMT27 + NET.FCAMT28 + NET.FCAMT29 + NET.FCAMT30 + NET.FCAMT31 + NET.FCAMT32 + NET.FCAMT33 + NET.FCAMT34 + NET.FCAMT35 + NET.FCAMT36 + NET.FCAMT37 + NET.FCAMT38 + NET.FCAMT39 + NET.FCAMT40 + NET.FCAMT41 + NET.FCAMT42 + NET.FCAMT43 + NET.FCAMT44 + NET.FCAMT45 + NET.FCAMT46 + NET.FCAMT47 + NET.FCAMT48 + NET.FCAMT49 + NET.FCAMT50 + NET.FCAMT51 + NET.FCAMT52 + NET.FCAMT53 + NET.FCAMT54 + NET.FCAMT55 + NET.FCAMT56 + NET.FCAMT57 + NET.FCAMT58 + NET.FCAMT59 + NET.FCAMT60 + NET.FCAMT61 + NET.FCAMT62 + NET.FCAMT63 + NET.FCAMT64 + NET.FCAMT65 + NET.FCAMT66 + NET.FCAMT67 + NET.FCAMT68 + NET.FCAMT69 + NET.FCAMT70 + NET.FCAMT71 + NET.FCAMT72 + NET.FCAMT73 + NET.FCAMT74 + NET.FCAMT75 + NET.FCAMT76 + NET.FCAMT78 + NET.FCAMT79 + NET.FCAMT80)/F.FACTOR))
, NET.FORECAST_ID
, DECODE(F.FACTOR
, 0
, NET.FCAMT0
, ROUND(NET.FCAMT0/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT1
, ROUND(NET.FCAMT1/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT2
, ROUND(NET.FCAMT2/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT3
, ROUND(NET.FCAMT3/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT4
, ROUND(NET.FCAMT4/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT5
, ROUND(NET.FCAMT5/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT6
, ROUND(NET.FCAMT6/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT7
, ROUND(NET.FCAMT7/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT8
, ROUND(NET.FCAMT8/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT9
, ROUND(NET.FCAMT9/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT10
, ROUND(NET.FCAMT10/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT11
, ROUND(NET.FCAMT11/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT12
, ROUND(NET.FCAMT12/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT13
, ROUND(NET.FCAMT13/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT14
, ROUND(NET.FCAMT14/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT15
, ROUND(NET.FCAMT15/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT16
, ROUND(NET.FCAMT16/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT17
, ROUND(NET.FCAMT17/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT18
, ROUND(NET.FCAMT18/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT19
, ROUND(NET.FCAMT19/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT20
, ROUND(NET.FCAMT20/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT21
, ROUND(NET.FCAMT21/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT22
, ROUND(NET.FCAMT22/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT23
, ROUND(NET.FCAMT23/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT24
, ROUND(NET.FCAMT24/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT25
, ROUND(NET.FCAMT25/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT26
, ROUND(NET.FCAMT26/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT27
, ROUND(NET.FCAMT27/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT28
, ROUND(NET.FCAMT28/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT29
, ROUND(NET.FCAMT29/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT30
, ROUND(NET.FCAMT30/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT31
, ROUND(NET.FCAMT31/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT32
, ROUND(NET.FCAMT32/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT33
, ROUND(NET.FCAMT33/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT34
, ROUND(NET.FCAMT34/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT35
, ROUND(NET.FCAMT35/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT36
, ROUND(NET.FCAMT36/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT37
, ROUND(NET.FCAMT37/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT38
, ROUND(NET.FCAMT38/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT39
, ROUND(NET.FCAMT39/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT40
, ROUND(NET.FCAMT40/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT41
, ROUND(NET.FCAMT41/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT42
, ROUND(NET.FCAMT42/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT43
, ROUND(NET.FCAMT43/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT44
, ROUND(NET.FCAMT44/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT45
, ROUND(NET.FCAMT45/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT46
, ROUND(NET.FCAMT46/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT47
, ROUND(NET.FCAMT47/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT48
, ROUND(NET.FCAMT48/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT49
, ROUND(NET.FCAMT49/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT50
, ROUND(NET.FCAMT50/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT51
, ROUND(NET.FCAMT51/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT52
, ROUND(NET.FCAMT52/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT53
, ROUND(NET.FCAMT53/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT54
, ROUND(NET.FCAMT54/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT55
, ROUND(NET.FCAMT55/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT56
, ROUND(NET.FCAMT56/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT57
, ROUND(NET.FCAMT57/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT58
, ROUND(NET.FCAMT58/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT59
, ROUND(NET.FCAMT59/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT60
, ROUND(NET.FCAMT60/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT61
, ROUND(NET.FCAMT61/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT62
, ROUND(NET.FCAMT62/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT63
, ROUND(NET.FCAMT63/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT64
, ROUND(NET.FCAMT64/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT65
, ROUND(NET.FCAMT65/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT66
, ROUND(NET.FCAMT66/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT67
, ROUND(NET.FCAMT67/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT68
, ROUND(NET.FCAMT68/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT69
, ROUND(NET.FCAMT69/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT70
, ROUND(NET.FCAMT70/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT71
, ROUND(NET.FCAMT71/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT72
, ROUND(NET.FCAMT72/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT73
, ROUND(NET.FCAMT73/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT74
, ROUND(NET.FCAMT74/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT75
, ROUND(NET.FCAMT75/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT76
, ROUND(NET.FCAMT76/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT77
, ROUND(NET.FCAMT77/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT78
, ROUND(NET.FCAMT78/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT79
, ROUND(NET.FCAMT79/F.FACTOR))
, DECODE(F.FACTOR
, 0
, NET.FCAMT80
, ROUND(NET.FCAMT80/F.FACTOR))
, NET.XTR_USER
FROM CE_FC_BANK_NETFLOW_V NET
, CE_BANK_ACCOUNTS BA
, CE_FORECAST_OPENING_BAL BAL
, CE_FORECASTS F
, CE_LOOKUPS L
WHERE NET.BANK_ACCOUNT_ID = BA.BANK_ACCOUNT_ID(+)
AND NET.BANK_ACCOUNT_ID = BAL.BANK_ACCOUNT_ID(+)
AND L.LOOKUP_TYPE = 'FC_MISC'
AND L.LOOKUP_CODE = 'OTHERS'
AND NET.FORECAST_ID = BAL.FORECAST_ID(+)
AND NET.FORECAST_ID = F.FORECAST_ID
AND NVL(BAL.BALANCE_TYPE
, 'BANK') = 'BANK'