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_PO_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, ENTERED_PYA_AMT FEDERAL_PYA_AMT, ENTERED_PYA_DIFF_AMT FEDERAL_PYA_DIFF_AMT, 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, OLD_CCID FEDERAL_OLD_CCID, ENT_COMMITMENT_AMOUNT ENT_COMMITMENT_AMOUNT, ACC_COMMITMENT_AMOUNT ACC_COMMITMENT_AMOUNT, ENT_UNPAID_OBL_AMOUNT ENT_UNPAID_OBL_AMOUNT, ACC_UNPAID_OBL_AMOUNT ACC_UNPAID_OBL_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, ENT_UNRESERVED_BUDGET_AMOUNT ENT_UNRESERVED_BUDGET_AMOUNT, ACC_UNRESERVED_BUDGET_AMOUNT ACC_UNRESERVED_BUDGET_AMOUNT FROM FV_EXTRACT_DETAIL_GT WHERE APPLICATION_ID = 201

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
, ENTERED_PYA_AMT FEDERAL_PYA_AMT
, ENTERED_PYA_DIFF_AMT FEDERAL_PYA_DIFF_AMT
, 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
, OLD_CCID FEDERAL_OLD_CCID
, ENT_COMMITMENT_AMOUNT ENT_COMMITMENT_AMOUNT
, ACC_COMMITMENT_AMOUNT ACC_COMMITMENT_AMOUNT
, ENT_UNPAID_OBL_AMOUNT ENT_UNPAID_OBL_AMOUNT
, ACC_UNPAID_OBL_AMOUNT ACC_UNPAID_OBL_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
, ENT_UNRESERVED_BUDGET_AMOUNT ENT_UNRESERVED_BUDGET_AMOUNT
, ACC_UNRESERVED_BUDGET_AMOUNT ACC_UNRESERVED_BUDGET_AMOUNT
FROM FV_EXTRACT_DETAIL_GT
WHERE APPLICATION_ID = 201