Product: | FV - Federal Financials |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FV_XLA_AP_REF_V |
SELECT EVENT_ID FEDERAL_EVENT_ID
, LINE_NUMBER FEDERAL_LINE_NUMBER
, FUND_VALUE FEDERAL_FUND_VALUE
, FUND_CATEGORY FEDERAL_FUND_CATEGORY
, FUND_EXPIRED_STATUS FEDERAL_FUND_EXPIRED_STATUS
, DECODE (FUND_CATEGORY
, 'A'
, 'DIRECT'
, 'B'
, 'DIRECT'
, 'C'
, 'DIRECT'
, 'R'
, 'REIMBURSABLE'
, 'S'
, 'REIMBURSABLE'
, 'T'
, 'REIMBURSABLE') FEDERAL_FUND_CAT_DESC
, ADJUSTMENT_TYPE FEDERAL_ADJUSTMENT_TYPE
, PRIOR_YEAR_FLAG FEDERAL_PRIOR_YEAR_FLAG
, ANTICIPATION FEDERAL_ANTICIPATION
, ANTICIPATED_AMT FEDERAL_ANTICIPATED_AMT
, UNANTICIPATED_AMT FEDERAL_UNANTICIPATED_AMT
, TCF_AMT FEDERAL_TCF_AMT
, PAID_RECEIVED_AMT FEDERAL_PAID_RECEIVED_AMT
, PAID_UNEXPENDED_OBLIGATION FEDERAL_PAID_UNEXP_OBG_AMT
, UNPAID_UNEXPENDED_OBLIGATION FEDERAL_UNPAID_UNEXP_OBG_AMT
, UNPAID_RECEIVED_AMT FEDERAL_UNPAID_RECEIVED_AMT
, UNPAID_OPEN_AMT FEDERAL_UNPAID_OPEN_AMT
FROM FV_EXTRACT_DETAIL_GT
WHERE APPLICATION_ID = 200