VIEW: JA.JAI_PA_DRAFT_INVOICES#

Source

View Text - Preformatted

select DRAFT_INVOICE_ID DRAFT_INVOICE_ID, PROJECT_ID PROJECT_ID, DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, EXCISE_INVOICE_NO EXCISE_INVOICE_NO, EXCISE_INVOICE_DATE EXCISE_INVOICE_DATE, VAT_INVOICE_NO VAT_INVOICE_NO, VAT_INVOICE_DATE VAT_INVOICE_DATE, 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, EXCISE_REGISTER_TYPE EXCISE_REGISTER_TYPE, EXCISE_REGISTER_ID EXCISE_REGISTER_ID, BASIC_EXCISE_AMT BASIC_EXCISE_AMT, ADDITIONAL_EXCISE_AMT ADDITIONAL_EXCISE_AMT, OTHER_EXCISE_AMT OTHER_EXCISE_AMT, EXCISE_CESS_AMT EXCISE_CESS_AMT, PROCESS_EXCISE_FLAG PROCESS_EXCISE_FLAG, PROCESS_VAT_FLAG PROCESS_VAT_FLAG, PARENT_DRAFT_INVOICE_ID PARENT_DRAFT_INVOICE_ID, EXCISE_SH_CESS_AMT EXCISE_SH_CESS_AMT from "JA"."JAI_PA_DRAFT_INVOICES"

View Text - HTML Formatted

SELECT DRAFT_INVOICE_ID DRAFT_INVOICE_ID
, PROJECT_ID PROJECT_ID
, DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, EXCISE_INVOICE_NO EXCISE_INVOICE_NO
, EXCISE_INVOICE_DATE EXCISE_INVOICE_DATE
, VAT_INVOICE_NO VAT_INVOICE_NO
, VAT_INVOICE_DATE VAT_INVOICE_DATE
, 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
, EXCISE_REGISTER_TYPE EXCISE_REGISTER_TYPE
, EXCISE_REGISTER_ID EXCISE_REGISTER_ID
, BASIC_EXCISE_AMT BASIC_EXCISE_AMT
, ADDITIONAL_EXCISE_AMT ADDITIONAL_EXCISE_AMT
, OTHER_EXCISE_AMT OTHER_EXCISE_AMT
, EXCISE_CESS_AMT EXCISE_CESS_AMT
, PROCESS_EXCISE_FLAG PROCESS_EXCISE_FLAG
, PROCESS_VAT_FLAG PROCESS_VAT_FLAG
, PARENT_DRAFT_INVOICE_ID PARENT_DRAFT_INVOICE_ID
, EXCISE_SH_CESS_AMT EXCISE_SH_CESS_AMT
FROM "JA"."JAI_PA_DRAFT_INVOICES"