VIEW: JA.JAI_BOE_DETAIL_TAXES#

Source

View Text - Preformatted

select BOE_DETAIL_TAX_ID BOE_DETAIL_TAX_ID, BOE_DETAIL_ID BOE_DETAIL_ID, TAX_LINE_NO TAX_LINE_NO, TAX_ID TAX_ID, TAX_TYPE TAX_TYPE, TAX_RATE TAX_RATE, ASSESSABLE_VALUE ASSESSABLE_VALUE, TAX_AMOUNT TAX_AMOUNT, UOM UOM, APPLIED_AMOUNT APPLIED_AMOUNT, QTY_RATE QTY_RATE, PRECEDENCE_1 PRECEDENCE_1, PRECEDENCE_2 PRECEDENCE_2, PRECEDENCE_3 PRECEDENCE_3, PRECEDENCE_4 PRECEDENCE_4, PRECEDENCE_5 PRECEDENCE_5, PRECEDENCE_6 PRECEDENCE_6, PRECEDENCE_7 PRECEDENCE_7, PRECEDENCE_8 PRECEDENCE_8, PRECEDENCE_9 PRECEDENCE_9, PRECEDENCE_10 PRECEDENCE_10, BASE_TAX_AMOUNT BASE_TAX_AMOUNT, FUNC_TAX_AMOUNT FUNC_TAX_AMOUNT, INCLUSIVE_TAX_FLAG INCLUSIVE_TAX_FLAG, BOE_FLAG BOE_FLAG, 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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TAX_CATEGORY_ID TAX_CATEGORY_ID from "JA"."JAI_BOE_DETAIL_TAXES"

View Text - HTML Formatted

SELECT BOE_DETAIL_TAX_ID BOE_DETAIL_TAX_ID
, BOE_DETAIL_ID BOE_DETAIL_ID
, TAX_LINE_NO TAX_LINE_NO
, TAX_ID TAX_ID
, TAX_TYPE TAX_TYPE
, TAX_RATE TAX_RATE
, ASSESSABLE_VALUE ASSESSABLE_VALUE
, TAX_AMOUNT TAX_AMOUNT
, UOM UOM
, APPLIED_AMOUNT APPLIED_AMOUNT
, QTY_RATE QTY_RATE
, PRECEDENCE_1 PRECEDENCE_1
, PRECEDENCE_2 PRECEDENCE_2
, PRECEDENCE_3 PRECEDENCE_3
, PRECEDENCE_4 PRECEDENCE_4
, PRECEDENCE_5 PRECEDENCE_5
, PRECEDENCE_6 PRECEDENCE_6
, PRECEDENCE_7 PRECEDENCE_7
, PRECEDENCE_8 PRECEDENCE_8
, PRECEDENCE_9 PRECEDENCE_9
, PRECEDENCE_10 PRECEDENCE_10
, BASE_TAX_AMOUNT BASE_TAX_AMOUNT
, FUNC_TAX_AMOUNT FUNC_TAX_AMOUNT
, INCLUSIVE_TAX_FLAG INCLUSIVE_TAX_FLAG
, BOE_FLAG BOE_FLAG
, 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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TAX_CATEGORY_ID TAX_CATEGORY_ID
FROM "JA"."JAI_BOE_DETAIL_TAXES"