VIEW: APPS.FV_XLA_AR_REF_V

Source

View Text - Preformatted

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, RECEIVABLE_WITH_ADVANCE FED_RECEIVABLE_WITH_ADVANCE FROM FV_EXTRACT_DETAIL_GT WHERE APPLICATION_ID=222

View Text - HTML Formatted

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
, RECEIVABLE_WITH_ADVANCE FED_RECEIVABLE_WITH_ADVANCE
FROM FV_EXTRACT_DETAIL_GT
WHERE APPLICATION_ID=222