FV Object Class and Program Activity

Description
Categories: BI Publisher, Financials
Application: Federal Financials
Source: Object Class and Program Activity Report
Short Name: FVOPACT
DB package:
SELECT       	 AGENCY_IDENTIFIER		AID
			,ALLOC_XFER_AGENCY	ATA
			,AVAIL_INDICATOR	AV
			,BALANCE_INDICATOR	BE
			,BEGIN_PERIOD_AVAIL	BPOA
			,END_PERIOD_AVAIL	EPOA
			,MAIN_ACCOUNT_CODE	MAIN
			,OBJECT_CLASS_CODE	OBJECT
			,PROG_REPORTING_CODE	ACTCODE
			,PROG_REPORTING_DESC	ACTDESC
			,REIMB_INDICATOR	DRC
			,SUB_ACCOUNT_CODE	SUB
 			,USSGL_ACCOUNT		SGLACCT
			,ABS(END_BALANCE)		AMOUNT
      		,CASE WHEN END_BALANCE < 0 THEN 'C'
           	WHEN END_BALANCE < 0 THEN 'D'
      		END  DC
FROM 	FV_OPA_BALANCE_TEMP 	TB
WHERE 	TB.LEDGER_ID = :P_LEDGER_ID
AND    rollup_flag = 'Y'
ORDER BY ALLOC_XFER_AGENCY, AGENCY_IDENTIFIER,
      BEGIN_PERIOD_AVAIL, END_PERIOD_AVAIL,
      AVAIL_INDICATOR,MAIN_ACCOUNT_CODE,
      SUB_ACCOUNT_CODE, USSGL_ACCOUNT,
      BALANCE_INDICATOR, REIMB_INDICATOR,
      OBJECT_CLASS_CODE, PROG_REPORTING_CODE