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_CST_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, 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, ENT_CHARGE_AMOUNT ENT_CHARGE_AMOUNT, ACC_CHARGE_AMOUNT ACC_CHARGE_AMOUNT, ENT_UNPAID_OBL_AMOUNT ENT_UNPAID_OBL_AMOUNT, ACC_UNPAID_OBL_AMOUNT ACC_UNPAID_OBL_AMOUNT, ENT_UNPAID_EXP_AMOUNT ENT_UNPAID_EXP_AMOUNT, ACC_UNPAID_EXP_AMOUNT ACC_UNPAID_EXP_AMOUNT, ENT_PAID_EXP_AMOUNT ENT_PAID_EXP_AMOUNT, ACC_PAID_EXP_AMOUNT ACC_PAID_EXP_AMOUNT, ENT_UNPAID_OBL_PYA_AMOUNT ENT_UNPAID_OBL_PYA_AMOUNT, ACC_UNPAID_OBL_PYA_AMOUNT ACC_UNPAID_OBL_PYA_AMOUNT, ENT_UNPAID_OBL_PYA_OFF_AMOUNT ENT_UNPAID_OBL_PYA_OFF_AMOUNT, ACC_UNPAID_OBL_PYA_OFF_AMOUNT ACC_UNPAID_OBL_PYA_OFF_AMOUNT, ENT_ANTICIPATED_BUDGET_AMOUNT ENT_ANTICIPATED_BUDGET_AMOUNT, ACC_ANTICIPATED_BUDGET_AMOUNT ACC_ANTICIPATED_BUDGET_AMOUNT, ENT_UNANTICIPATED_BUD_AMOUNT ENT_UNANTICIPATED_BUD_AMOUNT, ACC_UNANTICIPATED_BUD_AMOUNT ACC_UNANTICIPATED_BUD_AMOUNT, DIRECT_OR_REIMB FEDERAL_DIRECT_OR_REIMB, FUND_TYPE FEDERAL_FUND_TYPE, ACC_UNPAID_EXP_PYA_AMOUNT ACC_UNPAID_EXP_PYA_AMOUNT, ENT_UNPAID_EXP_PYA_AMOUNT ENT_UNPAID_EXP_PYA_AMOUNT FROM FV_EXTRACT_DETAIL_GT WHERE APPLICATION_ID = 707

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
, 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
, ENT_CHARGE_AMOUNT ENT_CHARGE_AMOUNT
, ACC_CHARGE_AMOUNT ACC_CHARGE_AMOUNT
, ENT_UNPAID_OBL_AMOUNT ENT_UNPAID_OBL_AMOUNT
, ACC_UNPAID_OBL_AMOUNT ACC_UNPAID_OBL_AMOUNT
, ENT_UNPAID_EXP_AMOUNT ENT_UNPAID_EXP_AMOUNT
, ACC_UNPAID_EXP_AMOUNT ACC_UNPAID_EXP_AMOUNT
, ENT_PAID_EXP_AMOUNT ENT_PAID_EXP_AMOUNT
, ACC_PAID_EXP_AMOUNT ACC_PAID_EXP_AMOUNT
, ENT_UNPAID_OBL_PYA_AMOUNT ENT_UNPAID_OBL_PYA_AMOUNT
, ACC_UNPAID_OBL_PYA_AMOUNT ACC_UNPAID_OBL_PYA_AMOUNT
, ENT_UNPAID_OBL_PYA_OFF_AMOUNT ENT_UNPAID_OBL_PYA_OFF_AMOUNT
, ACC_UNPAID_OBL_PYA_OFF_AMOUNT ACC_UNPAID_OBL_PYA_OFF_AMOUNT
, ENT_ANTICIPATED_BUDGET_AMOUNT ENT_ANTICIPATED_BUDGET_AMOUNT
, ACC_ANTICIPATED_BUDGET_AMOUNT ACC_ANTICIPATED_BUDGET_AMOUNT
, ENT_UNANTICIPATED_BUD_AMOUNT ENT_UNANTICIPATED_BUD_AMOUNT
, ACC_UNANTICIPATED_BUD_AMOUNT ACC_UNANTICIPATED_BUD_AMOUNT
, DIRECT_OR_REIMB FEDERAL_DIRECT_OR_REIMB
, FUND_TYPE FEDERAL_FUND_TYPE
, ACC_UNPAID_EXP_PYA_AMOUNT ACC_UNPAID_EXP_PYA_AMOUNT
, ENT_UNPAID_EXP_PYA_AMOUNT ENT_UNPAID_EXP_PYA_AMOUNT
FROM FV_EXTRACT_DETAIL_GT
WHERE APPLICATION_ID = 707