ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF963869E053B46B63588994 SELECT C.DEPARTMENT_ID AID,C.DEPT_TRANSFER ATA,C.AVAILABILITY_TYPE_CODE AV, C.ESTABLISHED_FISCAL_YR BPOA,C.END_YEAR_AVAIL EPOA,C.MAIN_ACCOUNT_CODE MAIN,C.SUB_ACCOUNT_CODE SUB,C.TREASURY_SYMBOL_ID,C.PROGRAM_ACTIVITY_RPT_CODE PARC,C.PROGRAM_ACTIVITY_RPT_DESC PARD, C.PROGRAM_OBJECT_CLASS POC,C.REIMB_INDICATOR RI,D.AMOUNT_LABEL AL,D.AMOUNT_NUMBER AN,SUM(D.AMOUNT) AMOUNT FROM ( SELECT A.DEPARTMENT_ID,A.DEPT_TRANSFER,A.AVAILABILITY_TYPE_CODE,A.ESTABLISHED_FISCAL_YR, A.END_YEAR_AVAIL,A.MAIN_ACCOUNT_CODE,A.SUB_ACCOUNT_CODE,A.TREASURY_SYMBOL_ID,B.PROGRAM_ACTIVITY_RPT_CODE,B.PROGRAM_ACTIVITY_RPT_DESC,B.PROGRAM_OBJECT_CLASS,B.REIMB_INDICATOR FROM ( SELECT TB.DEPARTMENT_ID ,TB.DEPT_TRANSFER ,TB.AVAILABILITY_TYPE_CODE ,TB.ESTABLISHED_FISCAL_YR ,TB.END_YEAR_AVAIL ,TB.MAIN_ACCOUNT_CODE ,TB.SUB_ACCOUNT_CODE,TB.TREASURY_SYMBOL_ID FROM FV_DACT_FILEB_TEMP TB WHERE TB.LEDGER_ID = :P_LEDGER_ID AND TB.TREASURY_SYMBOL_ID IS NOT NULL AND TB.REPORTING_PERIOD = :P_PERIOD_YEAR GROUP BY TB.DEPT_TRANSFER, TB.DEPARTMENT_ID, TB.ESTABLISHED_FISCAL_YR, TB.END_YEAR_AVAIL, TB.AVAILABILITY_TYPE_CODE,TB.MAIN_ACCOUNT_CODE, TB.SUB_ACCOUNT_CODE,TB.TREASURY_SYMBOL_ID) A, FV_DACT_FILEB_TEMP B WHERE A.TREASURY_SYMBOL_ID = B.TREASURY_SYMBOL_ID GROUP BY A.DEPARTMENT_ID,A.DEPT_TRANSFER,A.AVAILABILITY_TYPE_CODE,A.ESTABLISHED_FISCAL_YR, A.MAIN_ACCOUNT_CODE,A.END_YEAR_AVAIL,A.SUB_ACCOUNT_CODE,A.TREASURY_SYMBOL_ID,B.PROGRAM_ACTIVITY_RPT_CODE,B.PROGRAM_ACTIVITY_RPT_DESC,B.PROGRAM_OBJECT_CLASS,B.REIMB_INDICATOR) C , FV_DACT_FILEB_TEMP D where C.TREASURY_SYMBOL_ID = D.TREASURY_SYMBOL_ID and C.PROGRAM_ACTIVITY_RPT_CODE = D.PROGRAM_ACTIVITY_RPT_CODE and C.PROGRAM_ACTIVITY_RPT_DESC =D.PROGRAM_ACTIVITY_RPT_DESC and c.PROGRAM_OBJECT_CLASS = d.PROGRAM_OBJECT_CLASS and c.REIMB_INDICATOR = d.REIMB_INDICATOR group by C.DEPARTMENT_ID,C.DEPT_TRANSFER,C.AVAILABILITY_TYPE_CODE, C.ESTABLISHED_FISCAL_YR,C.END_YEAR_AVAIL,C.MAIN_ACCOUNT_CODE,C.SUB_ACCOUNT_CODE,C.TREASURY_SYMBOL_ID,C.PROGRAM_ACTIVITY_RPT_CODE, C.PROGRAM_ACTIVITY_RPT_DESC, C.PROGRAM_OBJECT_CLASS,C.REIMB_INDICATOR,D.AMOUNT_LABEL,D.AMOUNT_NUMBER,D.SEQ_NUM ORDER BY C.DEPARTMENT_ID,C.DEPT_TRANSFER,C.AVAILABILITY_TYPE_CODE, C.ESTABLISHED_FISCAL_YR,C.END_YEAR_AVAIL,C.MAIN_ACCOUNT_CODE,C.SUB_ACCOUNT_CODE,C.TREASURY_SYMBOL_ID,C.PROGRAM_ACTIVITY_RPT_CODE, C.PROGRAM_ACTIVITY_RPT_DESC, C.PROGRAM_OBJECT_CLASS,C.REIMB_INDICATOR,D.SEQ_NUM Y FV FVDACTBOP US FV Data Act File B Application: Federal Financials Source: Data Act File B Report Short Name: FVDACTBOP DB package: BI Publisher :p_ledger_id :p_period_year 1 10 :p_ledger_id Number US SOB_ID 2 20 :p_period_name Char US P_PERIOD_NAME 3 30 :p_period_year Number US P_PERIOD_YEAR 4 40 :p_period_num Number US P_PERIOD_NUM 5 50 :p_run_mode Char US P_RUN_MODE