VIEW: JA.JAI_RGM_INVOICE_GEN_T#

Source

View Text - Preformatted

select REGIME_ID REGIME_ID, DELIVERY_ID DELIVERY_ID, DELIVERY_DATE DELIVERY_DATE, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, TRX_DATE TRX_DATE, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, REGISTRATION_NUM REGISTRATION_NUM, VAT_INVOICE_NO VAT_INVOICE_NO, VAT_INV_GEN_STATUS VAT_INV_GEN_STATUS, VAT_INV_GEN_ERR_MESSAGE VAT_INV_GEN_ERR_MESSAGE, VAT_ACCT_STATUS VAT_ACCT_STATUS, VAT_ACCT_ERR_MESSAGE VAT_ACCT_ERR_MESSAGE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PARTY_ID PARTY_ID, PARTY_SITE_ID PARTY_SITE_ID, PARTY_TYPE PARTY_TYPE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, ORDER_LINE_ID ORDER_LINE_ID, ORDER_NUMBER ORDER_NUMBER from "JA"."JAI_RGM_INVOICE_GEN_T"

View Text - HTML Formatted

SELECT REGIME_ID REGIME_ID
, DELIVERY_ID DELIVERY_ID
, DELIVERY_DATE DELIVERY_DATE
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, TRX_DATE TRX_DATE
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, REGISTRATION_NUM REGISTRATION_NUM
, VAT_INVOICE_NO VAT_INVOICE_NO
, VAT_INV_GEN_STATUS VAT_INV_GEN_STATUS
, VAT_INV_GEN_ERR_MESSAGE VAT_INV_GEN_ERR_MESSAGE
, VAT_ACCT_STATUS VAT_ACCT_STATUS
, VAT_ACCT_ERR_MESSAGE VAT_ACCT_ERR_MESSAGE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PARTY_ID PARTY_ID
, PARTY_SITE_ID PARTY_SITE_ID
, PARTY_TYPE PARTY_TYPE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, ORDER_LINE_ID ORDER_LINE_ID
, ORDER_NUMBER ORDER_NUMBER
FROM "JA"."JAI_RGM_INVOICE_GEN_T"