Product: | FV - Federal Financials |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FV_XLA_AR_REF_V |
SELECT EVENT_ID FEDERAL_EVENT_ID
, LINE_NUMBER FEDERAL_LINE_NUMBER
, FUND_TIME_FRAME FEDERAL_FUND_TIME_FRAME
, FUND_EXPIRED_STATUS FEDERAL_FUND_EXPIRED_STATUS
, DECODE (FUND_CATEGORY
, 'A'
, 'A'
, 'B'
, 'B'
, 'C'
, 'C'
, 'R'
, 'A'
, 'S'
, 'B'
, 'T'
, 'C' ) FEDERAL_APPORTIONMENT_CATEGORY
, DECODE (FUND_CATEGORY
, 'A'
, 'DIRECT'
, 'B'
, 'DIRECT'
, 'C'
, 'DIRECT'
, 'R'
, 'REIMBURSABLE'
, 'S'
, 'REIMBURSABLE'
, 'T'
, 'REIMBURSABLE' ) FEDERAL_FUND_CATEGORY
, PRIOR_YEAR_FLAG FEDERAL_PRIOR_YEAR_FLAG
, ACCOUNT_VALID_FLAG FEDERAL_ACCOUNT_VALID_FLAG
, ACCOUNT_RULE FEDERAL_ACCOUNT_RULE
FROM FV_EXTRACT_DETAIL_GT
WHERE APPLICATION_ID=222