VIEW: APPS.FV_XLA_AP_REF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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