VIEW: JA.JAI_CMN_RG_ROUND_HDRS#

Source

View Text - Preformatted

select ROUNDING_ID ROUNDING_ID, SOURCE_HEADER_ID SOURCE_HEADER_ID, EXCISE_INVOICE_NO EXCISE_INVOICE_NO, EXCISE_INVOICE_DATE EXCISE_INVOICE_DATE, EXCISE_AMT_BEFORE_ROUNDING EXCISE_AMT_BEFORE_ROUNDING, EXCISE_AMT_AFTER_ROUNDING EXCISE_AMT_AFTER_ROUNDING, REGISTER_ID REGISTER_ID, SOURCE SOURCE, SRC_TRANSACTION_TYPE SRC_TRANSACTION_TYPE, 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, BASIC_ED BASIC_ED, ROUNDED_BASIC_ED ROUNDED_BASIC_ED, ADDITIONAL_ED ADDITIONAL_ED, ROUNDED_ADDITIONAL_ED ROUNDED_ADDITIONAL_ED, OTHER_ED OTHER_ED, ROUNDED_OTHER_ED ROUNDED_OTHER_ED, EXCISE_EDU_CESS EXCISE_EDU_CESS, ROUNDED_EXCISE_EDU_CESS ROUNDED_EXCISE_EDU_CESS, CVD_EDU_CESS CVD_EDU_CESS, ROUNDED_CVD_EDU_CESS ROUNDED_CVD_EDU_CESS, REGISTER REGISTER, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ADDITIONAL_CVD ADDITIONAL_CVD, ROUNDED_ADDITIONAL_CVD ROUNDED_ADDITIONAL_CVD, ROUNDED_SH_CVD_EDU_CESS ROUNDED_SH_CVD_EDU_CESS, ROUNDED_SH_EXCISE_EDU_CESS ROUNDED_SH_EXCISE_EDU_CESS, SH_CVD_EDU_CESS SH_CVD_EDU_CESS, SH_EXCISE_EDU_CESS SH_EXCISE_EDU_CESS from "JA"."JAI_CMN_RG_ROUND_HDRS"

View Text - HTML Formatted

SELECT ROUNDING_ID ROUNDING_ID
, SOURCE_HEADER_ID SOURCE_HEADER_ID
, EXCISE_INVOICE_NO EXCISE_INVOICE_NO
, EXCISE_INVOICE_DATE EXCISE_INVOICE_DATE
, EXCISE_AMT_BEFORE_ROUNDING EXCISE_AMT_BEFORE_ROUNDING
, EXCISE_AMT_AFTER_ROUNDING EXCISE_AMT_AFTER_ROUNDING
, REGISTER_ID REGISTER_ID
, SOURCE SOURCE
, SRC_TRANSACTION_TYPE SRC_TRANSACTION_TYPE
, 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
, BASIC_ED BASIC_ED
, ROUNDED_BASIC_ED ROUNDED_BASIC_ED
, ADDITIONAL_ED ADDITIONAL_ED
, ROUNDED_ADDITIONAL_ED ROUNDED_ADDITIONAL_ED
, OTHER_ED OTHER_ED
, ROUNDED_OTHER_ED ROUNDED_OTHER_ED
, EXCISE_EDU_CESS EXCISE_EDU_CESS
, ROUNDED_EXCISE_EDU_CESS ROUNDED_EXCISE_EDU_CESS
, CVD_EDU_CESS CVD_EDU_CESS
, ROUNDED_CVD_EDU_CESS ROUNDED_CVD_EDU_CESS
, REGISTER REGISTER
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ADDITIONAL_CVD ADDITIONAL_CVD
, ROUNDED_ADDITIONAL_CVD ROUNDED_ADDITIONAL_CVD
, ROUNDED_SH_CVD_EDU_CESS ROUNDED_SH_CVD_EDU_CESS
, ROUNDED_SH_EXCISE_EDU_CESS ROUNDED_SH_EXCISE_EDU_CESS
, SH_CVD_EDU_CESS SH_CVD_EDU_CESS
, SH_EXCISE_EDU_CESS SH_EXCISE_EDU_CESS
FROM "JA"."JAI_CMN_RG_ROUND_HDRS"