VIEW: FV.FV_EXTRACT_DETAIL_GT_LOGS#

Source

View Text - Preformatted

select EVENT_ID EVENT_ID, LINE_NUMBER LINE_NUMBER, APPLICATION_ID APPLICATION_ID, FUND_VALUE FUND_VALUE, FUND_CATEGORY FUND_CATEGORY, FUND_EXPIRED_STATUS FUND_EXPIRED_STATUS, PRIOR_YEAR_FLAG PRIOR_YEAR_FLAG, ADJUSTMENT_TYPE ADJUSTMENT_TYPE, NET_PYA_ADJ_AMT NET_PYA_ADJ_AMT, ENTERED_PYA_AMT ENTERED_PYA_AMT, ENTERED_PYA_DIFF_AMT ENTERED_PYA_DIFF_AMT, ANTICIPATION ANTICIPATION, ANTICIPATED_AMT ANTICIPATED_AMT, UNANTICIPATED_AMT UNANTICIPATED_AMT, TCF_AMT TCF_AMT, UNEXPENDED_OBLIGATION UNEXPENDED_OBLIGATION, PAID_UNEXPENDED_OBLIGATION PAID_UNEXPENDED_OBLIGATION, PAID_RECEIVED_AMT PAID_RECEIVED_AMT, UNPAID_UNEXPENDED_OBLIGATION UNPAID_UNEXPENDED_OBLIGATION, UNPAID_RECEIVED_AMT UNPAID_RECEIVED_AMT, UNPAID_OPEN_AMT UNPAID_OPEN_AMT, FUND_TIME_FRAME FUND_TIME_FRAME, RCV_PARENT_SUB_LEDGER_ID RCV_PARENT_SUB_LEDGER_ID, ACCOUNT_VALID_FLAG ACCOUNT_VALID_FLAG, ACCOUNT_RULE ACCOUNT_RULE, OLD_CCID OLD_CCID, RECEIVABLE_WITH_ADVANCE RECEIVABLE_WITH_ADVANCE, ENT_COMMITMENT_AMOUNT ENT_COMMITMENT_AMOUNT, ENT_UNPAID_OBL_AMOUNT ENT_UNPAID_OBL_AMOUNT, ACC_COMMITMENT_AMOUNT ACC_COMMITMENT_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, 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, AR_TRANSACTION_CATEGORY AR_TRANSACTION_CATEGORY, 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, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID, DIRECT_OR_REIMB DIRECT_OR_REIMB, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, FUND_TYPE FUND_TYPE, FED_NON_FED_IND FED_NON_FED_IND, ENT_REFUND_AMOUNT ENT_REFUND_AMOUNT, ACC_REFUND_AMOUNT ACC_REFUND_AMOUNT, ADVANCE_REQUIRED ADVANCE_REQUIRED from "FV"."FV_EXTRACT_DETAIL_GT_LOGS"

View Text - HTML Formatted

SELECT EVENT_ID EVENT_ID
, LINE_NUMBER LINE_NUMBER
, APPLICATION_ID APPLICATION_ID
, FUND_VALUE FUND_VALUE
, FUND_CATEGORY FUND_CATEGORY
, FUND_EXPIRED_STATUS FUND_EXPIRED_STATUS
, PRIOR_YEAR_FLAG PRIOR_YEAR_FLAG
, ADJUSTMENT_TYPE ADJUSTMENT_TYPE
, NET_PYA_ADJ_AMT NET_PYA_ADJ_AMT
, ENTERED_PYA_AMT ENTERED_PYA_AMT
, ENTERED_PYA_DIFF_AMT ENTERED_PYA_DIFF_AMT
, ANTICIPATION ANTICIPATION
, ANTICIPATED_AMT ANTICIPATED_AMT
, UNANTICIPATED_AMT UNANTICIPATED_AMT
, TCF_AMT TCF_AMT
, UNEXPENDED_OBLIGATION UNEXPENDED_OBLIGATION
, PAID_UNEXPENDED_OBLIGATION PAID_UNEXPENDED_OBLIGATION
, PAID_RECEIVED_AMT PAID_RECEIVED_AMT
, UNPAID_UNEXPENDED_OBLIGATION UNPAID_UNEXPENDED_OBLIGATION
, UNPAID_RECEIVED_AMT UNPAID_RECEIVED_AMT
, UNPAID_OPEN_AMT UNPAID_OPEN_AMT
, FUND_TIME_FRAME FUND_TIME_FRAME
, RCV_PARENT_SUB_LEDGER_ID RCV_PARENT_SUB_LEDGER_ID
, ACCOUNT_VALID_FLAG ACCOUNT_VALID_FLAG
, ACCOUNT_RULE ACCOUNT_RULE
, OLD_CCID OLD_CCID
, RECEIVABLE_WITH_ADVANCE RECEIVABLE_WITH_ADVANCE
, ENT_COMMITMENT_AMOUNT ENT_COMMITMENT_AMOUNT
, ENT_UNPAID_OBL_AMOUNT ENT_UNPAID_OBL_AMOUNT
, ACC_COMMITMENT_AMOUNT ACC_COMMITMENT_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
, 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
, AR_TRANSACTION_CATEGORY AR_TRANSACTION_CATEGORY
, 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
, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID
, DIRECT_OR_REIMB DIRECT_OR_REIMB
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, FUND_TYPE FUND_TYPE
, FED_NON_FED_IND FED_NON_FED_IND
, ENT_REFUND_AMOUNT ENT_REFUND_AMOUNT
, ACC_REFUND_AMOUNT ACC_REFUND_AMOUNT
, ADVANCE_REQUIRED ADVANCE_REQUIRED
FROM "FV"."FV_EXTRACT_DETAIL_GT_LOGS"