ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF953869E053B46B63588994Y SELECT A.AID,A.ATA,A.AV,A.BPOA,A.EPOA,A.MAIN,A.SUB,B.AMOUNT_LABEL AL,B.AMOUNT_NUMBER AN, SUM(B.AMOUNT) AMOUNT FROM ( SELECT TB.DEPARTMENT_ID AID ,TB.DEPT_TRANSFER ATA ,TB.AVAILABILITY_TYPE_CODE AV ,TB.ESTABLISHED_FISCAL_YR BPOA ,TB.END_YEAR_AVAIL EPOA ,TB.MAIN_ACCOUNT_CODE MAIN ,TB.SUB_ACCOUNT_CODE SUB,TB.TREASURY_SYMBOL_ID FROM FV_DACT_FILEA_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_FILEA_TEMP B WHERE A.TREASURY_SYMBOL_ID = B.TREASURY_SYMBOL_ID GROUP BY A.AID,A.ATA,A.AV,A.BPOA,A.EPOA,A.MAIN,A.SUB,B.AMOUNT_LABEL,B.AMOUNT_NUMBER,B.SEQ_NUM ORDER BY A.AID,A.ATA,A.AV,A.BPOA,A.EPOA,A.MAIN,A.SUB,B.SEQ_NUM FV FVDACTAP US FV Data Act File A Application: Federal Financials Source: Data Act File A Report Short Name: FVDACTAP DB package: BI Publisher :p_ledger_id :p_period_year 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