View: FV_XLA_CST_REF_V

Product:	FV - Federal Financials
Description:
Implementation/DBA Data:	APPS.FV_XLA_CST_REF_V

View Text

SELECT EVENT_ID FEDERAL_EVENT_ID
, LINE_NUMBER FEDERAL_LINE_NUMBER
, FUND_VALUE FEDERAL_FUND_VALUE
, DECODE (FUND_CATEGORY
, 'A'
, 'DIRECT'
, 'B'
, 'DIRECT'
, 'C'
, 'DIRECT'
, 'R'
, 'REIMBURSABLE'
, 'S'
, 'REIMBURSABLE'
, 'T'
, 'REIMBURSABLE') FEDERAL_FUND_CATEGORY
, FUND_EXPIRED_STATUS FEDERAL_FUND_EXPIRED_STATUS
, PRIOR_YEAR_FLAG FEDERAL_PRIOR_YEAR_FLAG
, ADJUSTMENT_TYPE FEDERAL_ADJUSTMENT_TYPE
, NET_PYA_ADJ_AMT FEDERAL_NET_PYA_ADJ_AMT
, ANTICIPATION FEDERAL_ANTICIPATION
, ANTICIPATED_AMT FEDERAL_ANTICIPATED_AMT
, UNANTICIPATED_AMT FEDERAL_UNANTICIPATED_AMT
, TCF_AMT FEDERAL_TCF_AMT
, UNEXPENDED_OBLIGATION FEDERAL_UNEXP_OBG_AMT
, PAID_UNEXPENDED_OBLIGATION FEDERAL_PAID_UNEXP_OBG_AMT
, PAID_RECEIVED_AMT FEDERAL_PAID_RECEIVED_AMT
, UNPAID_UNEXPENDED_OBLIGATION FEDERAL_UNPAID_UNEXP_OBG_AMT
, UNPAID_RECEIVED_AMT FEDERAL_UNPAID_RECEIVED_AMT
, UNPAID_OPEN_AMT FEDERAL_UNPAID_OPEN_AMT
, RCV_PARENT_SUB_LEDGER_ID FEDERAL_RCV_SUB_LEDGER_ID
FROM FV_EXTRACT_DETAIL_GT
WHERE APPLICATION_ID = 707

Columns