FV Data Act File B

Description
Categories: BI Publisher, Financials
Application: Federal Financials
Source: Data Act File B Report
Short Name: FVDACTBOP
DB package:
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
Parameter NameSQL textValidation
P_RUN_MODE
 
P_PERIOD_NUM
 
Number
P_PERIOD_YEAR
 
Number
P_PERIOD_NAME
 
SOB_ID
 
Number