VIEW: JA.JAI_AR_SUP_HDRS_ALL#

Source

View Text - Preformatted

select CUSTOMER_TRX_ID CUSTOMER_TRX_ID, CUSTOMER_ID CUSTOMER_ID, TRX_DATE TRX_DATE, SUPP_INV_DATE SUPP_INV_DATE, SUPP_INV_RAISED_IND SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS CHOSEN_FOR_PROCESS, PROCESS_DATE PROCESS_DATE, SUPP_INV_TYPE SUPP_INV_TYPE, EXIST_NET_SALES_AMT EXIST_NET_SALES_AMT, EXIST_EXCISE_AMT EXIST_EXCISE_AMT, EXIST_OTHER_AMT EXIST_OTHER_AMT, NEW_NET_SALES_AMT NEW_NET_SALES_AMT, NEW_EXCISE_AMT NEW_EXCISE_AMT, NEW_OTHER_AMT NEW_OTHER_AMT, EXCISE_DIFF_AMT EXCISE_DIFF_AMT, OTHER_DIFF_AMT OTHER_DIFF_AMT, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CUSTOMER_SITE CUSTOMER_SITE, ORG_ID ORG_ID, BATCH_ID BATCH_ID, SUP_HDR_ID SUP_HDR_ID, SUPPLEMENTARY_NUM SUPPLEMENTARY_NUM, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JA"."JAI_AR_SUP_HDRS_ALL"

View Text - HTML Formatted

SELECT CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, CUSTOMER_ID CUSTOMER_ID
, TRX_DATE TRX_DATE
, SUPP_INV_DATE SUPP_INV_DATE
, SUPP_INV_RAISED_IND SUPP_INV_RAISED_IND
, CHOSEN_FOR_PROCESS CHOSEN_FOR_PROCESS
, PROCESS_DATE PROCESS_DATE
, SUPP_INV_TYPE SUPP_INV_TYPE
, EXIST_NET_SALES_AMT EXIST_NET_SALES_AMT
, EXIST_EXCISE_AMT EXIST_EXCISE_AMT
, EXIST_OTHER_AMT EXIST_OTHER_AMT
, NEW_NET_SALES_AMT NEW_NET_SALES_AMT
, NEW_EXCISE_AMT NEW_EXCISE_AMT
, NEW_OTHER_AMT NEW_OTHER_AMT
, EXCISE_DIFF_AMT EXCISE_DIFF_AMT
, OTHER_DIFF_AMT OTHER_DIFF_AMT
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CUSTOMER_SITE CUSTOMER_SITE
, ORG_ID ORG_ID
, BATCH_ID BATCH_ID
, SUP_HDR_ID SUP_HDR_ID
, SUPPLEMENTARY_NUM SUPPLEMENTARY_NUM
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JA"."JAI_AR_SUP_HDRS_ALL"