DBA Data[Home] [Help]

VIEW: JA.JAI_RGM_GST_INVOICE_GEN_T#

Source

View Text - Preformatted

select DELIVERY_ID DELIVERY_ID, DELIVERY_DATE DELIVERY_DATE, ORDER_LINE_ID ORDER_LINE_ID, ORDER_NUMBER ORDER_NUMBER, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, TRX_DATE TRX_DATE, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, 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, GST_INVOICE_NO GST_INVOICE_NO, GST_INV_GEN_STATUS GST_INV_GEN_STATUS, GST_INV_GEN_ERR_MESSAGE GST_INV_GEN_ERR_MESSAGE, GST_ACCT_STATUS GST_ACCT_STATUS, GST_ACCT_ERR_MESSAGE GST_ACCT_ERR_MESSAGE, 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 from "JA"."JAI_RGM_GST_INVOICE_GEN_T"
View Text - HTML Formatted

SELECT DELIVERY_ID DELIVERY_ID
, DELIVERY_DATE DELIVERY_DATE
, ORDER_LINE_ID ORDER_LINE_ID
, ORDER_NUMBER ORDER_NUMBER
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, TRX_DATE TRX_DATE
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, 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
, GST_INVOICE_NO GST_INVOICE_NO
, GST_INV_GEN_STATUS GST_INV_GEN_STATUS
, GST_INV_GEN_ERR_MESSAGE GST_INV_GEN_ERR_MESSAGE
, GST_ACCT_STATUS GST_ACCT_STATUS
, GST_ACCT_ERR_MESSAGE GST_ACCT_ERR_MESSAGE
, 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
FROM "JA"."JAI_RGM_GST_INVOICE_GEN_T"