eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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, FUND_CATEGORY FEDERAL_APPORTIONMENT_CATEGORY, DIRECT_OR_REIMB 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, AR_TRANSACTION_CATEGORY FED_AR_TRANSACTION_CATEGORY, FUND_TYPE FEDERAL_FUND_TYPE, FED_NON_FED_IND FEDERAL_NON_FEDERAL_IND 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
, FUND_CATEGORY FEDERAL_APPORTIONMENT_CATEGORY
, DIRECT_OR_REIMB 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
, AR_TRANSACTION_CATEGORY FED_AR_TRANSACTION_CATEGORY
, FUND_TYPE FEDERAL_FUND_TYPE
, FED_NON_FED_IND FEDERAL_NON_FEDERAL_IND
FROM FV_EXTRACT_DETAIL_GT
WHERE APPLICATION_ID=222