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: AP.JE_IT_EXEMPT_LETTERS#

Source

View Text - Preformatted


select VENDOR_ID VENDOR_ID, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_TO EFFECTIVE_TO, YEAR YEAR, EXEMPTION_LETTER_ID EXEMPTION_LETTER_ID, PRINT_FLAG PRINT_FLAG, ISSUE_FLAG ISSUE_FLAG, CUSTOM_FLAG CUSTOM_FLAG, CLAUSE_REF CLAUSE_REF, ISSUE_DATE ISSUE_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, LETTER_TYPE LETTER_TYPE, LIMIT_AMOUNT LIMIT_AMOUNT, LEGAL_ENTITY_ID LEGAL_ENTITY_ID from "AP"."JE_IT_EXEMPT_LETTERS"

View Text - HTML Formatted

SELECT VENDOR_ID VENDOR_ID
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_TO EFFECTIVE_TO
, YEAR YEAR
, EXEMPTION_LETTER_ID EXEMPTION_LETTER_ID
, PRINT_FLAG PRINT_FLAG
, ISSUE_FLAG ISSUE_FLAG
, CUSTOM_FLAG CUSTOM_FLAG
, CLAUSE_REF CLAUSE_REF
, ISSUE_DATE ISSUE_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, LETTER_TYPE LETTER_TYPE
, LIMIT_AMOUNT LIMIT_AMOUNT
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM "AP"."JE_IT_EXEMPT_LETTERS"