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.

[Home] [Help]

VIEW: JL.JL_CL_AP_AWT_CERT#

Source

View Text - Preformatted


select CERTIFICATE_ID CERTIFICATE_ID, CERTIFICATE_NUMBER CERTIFICATE_NUMBER, CERTIFICATE_YEAR CERTIFICATE_YEAR, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ORG_ID ORG_ID, VENDOR_ID VENDOR_ID, PRICE_INDEX_ID PRICE_INDEX_ID, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, STATUS STATUS, PARTICIPATION_FLAG PARTICIPATION_FLAG, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, TAXPAYER_ID_NUMBER TAXPAYER_ID_NUMBER, REPRINT_DATE REPRINT_DATE, SERVICE_AMOUNT SERVICE_AMOUNT, PARTICIPATION_AMOUNT PARTICIPATION_AMOUNT, TAX_AMOUNT TAX_AMOUNT, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LEGAL_ENTITY_ID LEGAL_ENTITY_ID from "JL"."JL_CL_AP_AWT_CERT"

View Text - HTML Formatted

SELECT CERTIFICATE_ID CERTIFICATE_ID
, CERTIFICATE_NUMBER CERTIFICATE_NUMBER
, CERTIFICATE_YEAR CERTIFICATE_YEAR
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ORG_ID ORG_ID
, VENDOR_ID VENDOR_ID
, PRICE_INDEX_ID PRICE_INDEX_ID
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, STATUS STATUS
, PARTICIPATION_FLAG PARTICIPATION_FLAG
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAXPAYER_ID_NUMBER TAXPAYER_ID_NUMBER
, REPRINT_DATE REPRINT_DATE
, SERVICE_AMOUNT SERVICE_AMOUNT
, PARTICIPATION_AMOUNT PARTICIPATION_AMOUNT
, TAX_AMOUNT TAX_AMOUNT
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM "JL"."JL_CL_AP_AWT_CERT"