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: IGI.IGI_ITR_CHARGE_LINES_AUDIT_TM#

Source

View Text - Preformatted


select IT_HEADER_ID IT_HEADER_ID, IT_LINE_NUM IT_LINE_NUM, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, RECEIVING_CODE_COMBINATION_ID RECEIVING_CODE_COMBINATION_ID, CHARGE_CENTER_ID CHARGE_CENTER_ID, EFFECTIVE_DATE EFFECTIVE_DATE, ENTERED_DR ENTERED_DR, ENTERED_CR ENTERED_CR, DESCRIPTION DESCRIPTION, STATUS_FLAG STATUS_FLAG, POSTING_FLAG POSTING_FLAG, SUBMIT_DATE SUBMIT_DATE, SUGGESTED_AMOUNT SUGGESTED_AMOUNT, REJECTION_NOTE REJECTION_NOTE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, IT_SERVICE_LINE_ID IT_SERVICE_LINE_ID, CREATION_CODE_COMBINATION_ID CREATION_CODE_COMBINATION_ID, CHARGE_SERVICE_ID CHARGE_SERVICE_ID, PACKET_ID PACKET_ID, FAILED_FUNDS_LOOKUP_CODE FAILED_FUNDS_LOOKUP_CODE, ENCUMBRANCE_FLAG ENCUMBRANCE_FLAG, ENCUMBERED_AMOUNT ENCUMBERED_AMOUNT, UNENCUMBERED_AMOUNT UNENCUMBERED_AMOUNT, GL_ENCUMBERED_DATE GL_ENCUMBERED_DATE, GL_ENCUMBERED_PERIOD_NAME GL_ENCUMBERED_PERIOD_NAME, GL_CANCELLED_DATE GL_CANCELLED_DATE, PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG, JE_HEADER_ID JE_HEADER_ID, REVERSAL_FLAG REVERSAL_FLAG, LINK_REFERENCE_NUM LINK_REFERENCE_NUM, ITR_AUDIT_LINE_ID ITR_AUDIT_LINE_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID from "IGI"."IGI_ITR_CHARGE_LINES_AUDIT_TMP"

View Text - HTML Formatted

SELECT IT_HEADER_ID IT_HEADER_ID
, IT_LINE_NUM IT_LINE_NUM
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, RECEIVING_CODE_COMBINATION_ID RECEIVING_CODE_COMBINATION_ID
, CHARGE_CENTER_ID CHARGE_CENTER_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
, DESCRIPTION DESCRIPTION
, STATUS_FLAG STATUS_FLAG
, POSTING_FLAG POSTING_FLAG
, SUBMIT_DATE SUBMIT_DATE
, SUGGESTED_AMOUNT SUGGESTED_AMOUNT
, REJECTION_NOTE REJECTION_NOTE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, IT_SERVICE_LINE_ID IT_SERVICE_LINE_ID
, CREATION_CODE_COMBINATION_ID CREATION_CODE_COMBINATION_ID
, CHARGE_SERVICE_ID CHARGE_SERVICE_ID
, PACKET_ID PACKET_ID
, FAILED_FUNDS_LOOKUP_CODE FAILED_FUNDS_LOOKUP_CODE
, ENCUMBRANCE_FLAG ENCUMBRANCE_FLAG
, ENCUMBERED_AMOUNT ENCUMBERED_AMOUNT
, UNENCUMBERED_AMOUNT UNENCUMBERED_AMOUNT
, GL_ENCUMBERED_DATE GL_ENCUMBERED_DATE
, GL_ENCUMBERED_PERIOD_NAME GL_ENCUMBERED_PERIOD_NAME
, GL_CANCELLED_DATE GL_CANCELLED_DATE
, PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG
, JE_HEADER_ID JE_HEADER_ID
, REVERSAL_FLAG REVERSAL_FLAG
, LINK_REFERENCE_NUM LINK_REFERENCE_NUM
, ITR_AUDIT_LINE_ID ITR_AUDIT_LINE_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
FROM "IGI"."IGI_ITR_CHARGE_LINES_AUDIT_TMP"