ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF943869E053B46B63588994Y WITH filec_grp AS (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,DECODE(:P_INCL_PROGACT,'Y',B.PROGRAM_ACTIVITY_RPT_CODE,'N',1) PARC,DECODE(:P_INCL_PROGACT,'Y',B.PROGRAM_ACTIVITY_RPT_DESC,'N',1) PARD,B.PROGRAM_OBJECT_CLASS,B.REIMB_INDICATOR, B.PIID, B.PARENT_AWARD_ID,B.FAIN,B.URI 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_FILEC_TEMP TB WHERE TB.LEDGER_ID = :P_LEDGER_ID AND TB.TREASURY_SYMBOL_ID IS NOT NULL 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_FILEC_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,DECODE(:P_INCL_PROGACT,'Y',B.PROGRAM_ACTIVITY_RPT_CODE,'N',1),DECODE(:P_INCL_PROGACT,'Y',B.PROGRAM_ACTIVITY_RPT_DESC,'N',1),B.PROGRAM_OBJECT_CLASS,B.REIMB_INDICATOR,B.PIID, B.PARENT_AWARD_ID,B.FAIN,B.URI ORDER 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.PIID, B.PARENT_AWARD_ID,B.FAIN,B.URI,DECODE(:P_INCL_PROGACT,'Y',B.PROGRAM_ACTIVITY_RPT_CODE,'N',1),DECODE(:P_INCL_PROGACT,'Y',B.PROGRAM_ACTIVITY_RPT_DESC,'N',1),B.PROGRAM_OBJECT_CLASS,B.REIMB_INDICATOR) 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,DECODE(:P_INCL_PROGACT,'Y',C.PARC,'N',1) PARC,DECODE(:P_INCL_PROGACT,'Y',C.PARD,'N',1) PARD, C.PROGRAM_OBJECT_CLASS POC,C.REIMB_INDICATOR RI,C.PIID PIID, C.PARENT_AWARD_ID PARENT_AWARD_ID,C.FAIN FAIN,C.URI URI,D.AMOUNT_NUMBER AN,D.AMOUNT_LABEL AL,SUM(D.AMOUNT) AMOUNT FROM filec_grp C , FV_DACT_FILEC_TEMP D where C.TREASURY_SYMBOL_ID = D.TREASURY_SYMBOL_ID and DECODE(:P_INCL_PROGACT,'Y',C.PARC,'N',1) = DECODE(:P_INCL_PROGACT,'Y',D.PROGRAM_ACTIVITY_RPT_CODE,'N',1) and DECODE(:P_INCL_PROGACT,'Y',C.PARD,'N',1) = DECODE(:P_INCL_PROGACT,'Y',D.PROGRAM_ACTIVITY_RPT_DESC,'N',1) and c.PROGRAM_OBJECT_CLASS = d.PROGRAM_OBJECT_CLASS and c.REIMB_INDICATOR = d.REIMB_INDICATOR AND NVL(C.PIID,'Y')=NVL(D.PIID,'Y') AND NVL(C.PARENT_AWARD_ID,'Y')=NVL(D.PARENT_AWARD_ID,'Y') AND NVL(C.FAIN,'Y')=NVL(D.FAIN,'Y') AND NVL(C.URI,'Y')=NVL(D.URI,'Y') 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,DECODE(:P_INCL_PROGACT,'Y',C.PARC,'N',1), DECODE(:P_INCL_PROGACT,'Y',C.PARD,'N',1), C.PROGRAM_OBJECT_CLASS,C.REIMB_INDICATOR,C.PIID, C.PARENT_AWARD_ID,C.FAIN,C.URI,D.AMOUNT_NUMBER,D.AMOUNT_LABEL,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.PIID, C.PARENT_AWARD_ID,C.FAIN,C.URI,DECODE(:P_INCL_PROGACT,'Y',C.PARC,'N',1), DECODE(:P_INCL_PROGACT,'Y',C.PARD,'N',1), C.PROGRAM_OBJECT_CLASS,C.REIMB_INDICATOR,D.SEQ_NUM FV FVDACTAFB US FV Data Act File C Balances Application: Federal Financials Source: Data Act File C Balances Report Short Name: FVDACTAFB DB package: BI Publisher :p_incl_progact :p_ledger_id 1 10 :p_ledger_id LOV Oracle FV_SRS_LEDGER_NAME Y select l.ledger_id id, l.name value, l.description description from gl_access_set_ledgers ac,gl_ledgers_public_v l where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and l.ledger_id=ac.ledger_id and l.ledger_category_code='PRIMARY' order by name US Ledger ID 2 20 :p_period_name LOV Oracle FV_GTAS_ACT_TO_PERIOD Y select period_name id, period_name value, null description from gl_period_statuses where set_of_books_id=:$flex$.fv_srs_ledger_name and application_id=101 and closing_status in ('O','C') and period_year in (select distinct fiscal_year from fv_gtas_run where set_of_books_id=:$flex$.fv_srs_ledger_name) order by value,description US Period 3 30 :p_period_year Number US Period Year 4 40 :p_period_num Number US Period Num 5 50 :p_run_mode Char US Run Mode 6 60 :p_incl_progact Char US File C Prog Activity