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_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, 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_CHARGE_AMOUNT ENT_CHARGE_AMOUNT, ACC_CHARGE_AMOUNT ACC_CHARGE_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_PAID_OBL_AMOUNT ENT_PAID_OBL_AMOUNT, ACC_PAID_OBL_AMOUNT ACC_PAID_OBL_AMOUNT, ENT_UNPAID_EXP_PYA_AMOUNT ENT_UNPAID_EXP_PYA_AMOUNT, ACC_UNPAID_EXP_PYA_AMOUNT ACC_UNPAID_EXP_PYA_AMOUNT, ENT_UNPAID_EXP_PYA_OFF_AMOUNT ENT_UNPAID_EXP_PYA_OFF_AMOUNT, ACC_UNPAID_EXP_PYA_OFF_AMOUNT ACC_UNPAID_EXP_PYA_OFF_AMOUNT, ACC_EXPENDED_APPROP_AMOUNT ACC_EXPENDED_APPROP_AMOUNT , ENT_EXPENDED_APPROP_AMOUNT ENT_EXPENDED_APPROP_AMOUNT , ENT_PAID_EXP_PYA_AMOUNT ENT_PAID_EXP_PYA_AMOUNT, ACC_PAID_EXP_PYA_AMOUNT ACC_PAID_EXP_PYA_AMOUNT, ENT_PAID_EXP_PYA_OFF_AMOUNT ENT_PAID_EXP_PYA_OFF_AMOUNT, ACC_PAID_EXP_PYA_OFF_AMOUNT ACC_PAID_EXP_PYA_OFF_AMOUNT, DIRECT_OR_REIMB FEDERAL_DIRECT_OR_REIMB, FUND_TYPE FEDERAL_FUND_TYPE, AR_TRANSACTION_CATEGORY FED_AR_TRANSACTION_CATEGORY, FED_NON_FED_IND FEDERAL_NON_FEDERAL_IND, ENT_REFUND_AMOUNT ENT_REFUND_AMOUNT, ACC_REFUND_AMOUNT ACC_REFUND_AMOUNT, ADVANCE_REQUIRED FEDERAL_ADVANCE_REQUIRED 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
, 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_CHARGE_AMOUNT ENT_CHARGE_AMOUNT
, ACC_CHARGE_AMOUNT ACC_CHARGE_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_PAID_OBL_AMOUNT ENT_PAID_OBL_AMOUNT
, ACC_PAID_OBL_AMOUNT ACC_PAID_OBL_AMOUNT
, ENT_UNPAID_EXP_PYA_AMOUNT ENT_UNPAID_EXP_PYA_AMOUNT
, ACC_UNPAID_EXP_PYA_AMOUNT ACC_UNPAID_EXP_PYA_AMOUNT
, ENT_UNPAID_EXP_PYA_OFF_AMOUNT ENT_UNPAID_EXP_PYA_OFF_AMOUNT
, ACC_UNPAID_EXP_PYA_OFF_AMOUNT ACC_UNPAID_EXP_PYA_OFF_AMOUNT
, ACC_EXPENDED_APPROP_AMOUNT ACC_EXPENDED_APPROP_AMOUNT
, ENT_EXPENDED_APPROP_AMOUNT ENT_EXPENDED_APPROP_AMOUNT
, ENT_PAID_EXP_PYA_AMOUNT ENT_PAID_EXP_PYA_AMOUNT
, ACC_PAID_EXP_PYA_AMOUNT ACC_PAID_EXP_PYA_AMOUNT
, ENT_PAID_EXP_PYA_OFF_AMOUNT ENT_PAID_EXP_PYA_OFF_AMOUNT
, ACC_PAID_EXP_PYA_OFF_AMOUNT ACC_PAID_EXP_PYA_OFF_AMOUNT
, DIRECT_OR_REIMB FEDERAL_DIRECT_OR_REIMB
, FUND_TYPE FEDERAL_FUND_TYPE
, AR_TRANSACTION_CATEGORY FED_AR_TRANSACTION_CATEGORY
, FED_NON_FED_IND FEDERAL_NON_FEDERAL_IND
, ENT_REFUND_AMOUNT ENT_REFUND_AMOUNT
, ACC_REFUND_AMOUNT ACC_REFUND_AMOUNT
, ADVANCE_REQUIRED FEDERAL_ADVANCE_REQUIRED
FROM FV_EXTRACT_DETAIL_GT
WHERE APPLICATION_ID = 200