FV Object Class and Program Activity
Description
Categories: BI Publisher
Application: Federal Financials
Source: Object Class and Program Activity Report
Short Name: FVOPACT
DB package:
Source: Object Class and Program Activity Report
Short Name: FVOPACT
DB package:
Run
FV Object Class and Program Activity and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |