VIEW: JA.JAI_CMN_BOE_DTLS#

Source

View Text - Preformatted

select BOE_ID BOE_ID, LINE_NUMBER LINE_NUMBER, PKG_NUMBER PKG_NUMBER, PKG_DESCRIPTION PKG_DESCRIPTION, SERIAL_NUMBER SERIAL_NUMBER, QUANTITY QUANTITY, UOM_CODE UOM_CODE, ITEM_NUMBER ITEM_NUMBER, CUSTOMS_TARIFF CUSTOMS_TARIFF, DUTY_CODE DUTY_CODE, ACCESSIBLE_VALUE ACCESSIBLE_VALUE, BASIC_DUTY_RATE BASIC_DUTY_RATE, BASIC_DUTY_AMOUNT BASIC_DUTY_AMOUNT, EXEMPTION_NUM EXEMPTION_NUM, TOTAL_VALUE TOTAL_VALUE, ADDL_DUTY_RATE ADDL_DUTY_RATE, ADDL_DUTY_AMOUNT ADDL_DUTY_AMOUNT, CUMM_DUTY_AMOUNT CUMM_DUTY_AMOUNT, SURCH_DUTY_RATE SURCH_DUTY_RATE, SURCH_DUTY_AMOUNT SURCH_DUTY_AMOUNT, TOTAL_DUTY_AMOUNT TOTAL_DUTY_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, EDU_CESS_CVD_RATE EDU_CESS_CVD_RATE, EDU_CESS_CVD_AMOUNT EDU_CESS_CVD_AMOUNT, EDU_CESS_CVD_BASIS EDU_CESS_CVD_BASIS, EDU_CESS_CUSTOMS_RATE EDU_CESS_CUSTOMS_RATE, EDU_CESS_CUSTOMS_AMOUNT EDU_CESS_CUSTOMS_AMOUNT, EDU_CESS_CUSTOMS_BASIS EDU_CESS_CUSTOMS_BASIS, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ADDITIONAL_CVD_RATE ADDITIONAL_CVD_RATE, ADDITIONAL_CVD_AMT ADDITIONAL_CVD_AMT, ADDITIONAL_CVD_BASIS ADDITIONAL_CVD_BASIS, SH_CUSTOMS_CESS_AMOUNT SH_CUSTOMS_CESS_AMOUNT, SH_CUSTOMS_CESS_BASIS SH_CUSTOMS_CESS_BASIS, SH_CUSTOMS_CESS_RATE SH_CUSTOMS_CESS_RATE, SH_CVD_CESS_AMOUNT SH_CVD_CESS_AMOUNT, SH_CVD_CESS_BASIS SH_CVD_CESS_BASIS, SH_CVD_CESS_RATE SH_CVD_CESS_RATE, SH_EDU_CESS_AMOUNT SH_EDU_CESS_AMOUNT, SH_EDU_CESS_BASIS SH_EDU_CESS_BASIS, SH_EDU_CESS_RATE SH_EDU_CESS_RATE from "JA"."JAI_CMN_BOE_DTLS"

View Text - HTML Formatted

SELECT BOE_ID BOE_ID
, LINE_NUMBER LINE_NUMBER
, PKG_NUMBER PKG_NUMBER
, PKG_DESCRIPTION PKG_DESCRIPTION
, SERIAL_NUMBER SERIAL_NUMBER
, QUANTITY QUANTITY
, UOM_CODE UOM_CODE
, ITEM_NUMBER ITEM_NUMBER
, CUSTOMS_TARIFF CUSTOMS_TARIFF
, DUTY_CODE DUTY_CODE
, ACCESSIBLE_VALUE ACCESSIBLE_VALUE
, BASIC_DUTY_RATE BASIC_DUTY_RATE
, BASIC_DUTY_AMOUNT BASIC_DUTY_AMOUNT
, EXEMPTION_NUM EXEMPTION_NUM
, TOTAL_VALUE TOTAL_VALUE
, ADDL_DUTY_RATE ADDL_DUTY_RATE
, ADDL_DUTY_AMOUNT ADDL_DUTY_AMOUNT
, CUMM_DUTY_AMOUNT CUMM_DUTY_AMOUNT
, SURCH_DUTY_RATE SURCH_DUTY_RATE
, SURCH_DUTY_AMOUNT SURCH_DUTY_AMOUNT
, TOTAL_DUTY_AMOUNT TOTAL_DUTY_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
, EDU_CESS_CVD_RATE EDU_CESS_CVD_RATE
, EDU_CESS_CVD_AMOUNT EDU_CESS_CVD_AMOUNT
, EDU_CESS_CVD_BASIS EDU_CESS_CVD_BASIS
, EDU_CESS_CUSTOMS_RATE EDU_CESS_CUSTOMS_RATE
, EDU_CESS_CUSTOMS_AMOUNT EDU_CESS_CUSTOMS_AMOUNT
, EDU_CESS_CUSTOMS_BASIS EDU_CESS_CUSTOMS_BASIS
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ADDITIONAL_CVD_RATE ADDITIONAL_CVD_RATE
, ADDITIONAL_CVD_AMT ADDITIONAL_CVD_AMT
, ADDITIONAL_CVD_BASIS ADDITIONAL_CVD_BASIS
, SH_CUSTOMS_CESS_AMOUNT SH_CUSTOMS_CESS_AMOUNT
, SH_CUSTOMS_CESS_BASIS SH_CUSTOMS_CESS_BASIS
, SH_CUSTOMS_CESS_RATE SH_CUSTOMS_CESS_RATE
, SH_CVD_CESS_AMOUNT SH_CVD_CESS_AMOUNT
, SH_CVD_CESS_BASIS SH_CVD_CESS_BASIS
, SH_CVD_CESS_RATE SH_CVD_CESS_RATE
, SH_EDU_CESS_AMOUNT SH_EDU_CESS_AMOUNT
, SH_EDU_CESS_BASIS SH_EDU_CESS_BASIS
, SH_EDU_CESS_RATE SH_EDU_CESS_RATE
FROM "JA"."JAI_CMN_BOE_DTLS"