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: JA.JAI_OM_OE_SO_TAXES#

Source

View Text - Preformatted


select TAX_LINE_NO TAX_LINE_NO, LINE_ID LINE_ID, HEADER_ID HEADER_ID, PRECEDENCE_1 PRECEDENCE_1, PRECEDENCE_2 PRECEDENCE_2, PRECEDENCE_3 PRECEDENCE_3, PRECEDENCE_4 PRECEDENCE_4, PRECEDENCE_5 PRECEDENCE_5, TAX_ID TAX_ID, TAX_RATE TAX_RATE, QTY_RATE QTY_RATE, UOM UOM, TAX_AMOUNT TAX_AMOUNT, BASE_TAX_AMOUNT BASE_TAX_AMOUNT, FUNC_TAX_AMOUNT FUNC_TAX_AMOUNT, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TAX_CATEGORY_ID TAX_CATEGORY_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PRECEDENCE_6 PRECEDENCE_6, PRECEDENCE_7 PRECEDENCE_7, PRECEDENCE_8 PRECEDENCE_8, PRECEDENCE_9 PRECEDENCE_9, PRECEDENCE_10 PRECEDENCE_10 from "JA"."JAI_OM_OE_SO_TAXES"

View Text - HTML Formatted

SELECT TAX_LINE_NO TAX_LINE_NO
, LINE_ID LINE_ID
, HEADER_ID HEADER_ID
, PRECEDENCE_1 PRECEDENCE_1
, PRECEDENCE_2 PRECEDENCE_2
, PRECEDENCE_3 PRECEDENCE_3
, PRECEDENCE_4 PRECEDENCE_4
, PRECEDENCE_5 PRECEDENCE_5
, TAX_ID TAX_ID
, TAX_RATE TAX_RATE
, QTY_RATE QTY_RATE
, UOM UOM
, TAX_AMOUNT TAX_AMOUNT
, BASE_TAX_AMOUNT BASE_TAX_AMOUNT
, FUNC_TAX_AMOUNT FUNC_TAX_AMOUNT
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAX_CATEGORY_ID TAX_CATEGORY_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PRECEDENCE_6 PRECEDENCE_6
, PRECEDENCE_7 PRECEDENCE_7
, PRECEDENCE_8 PRECEDENCE_8
, PRECEDENCE_9 PRECEDENCE_9
, PRECEDENCE_10 PRECEDENCE_10
FROM "JA"."JAI_OM_OE_SO_TAXES"