DBA Data[Home] [Help] [Dependency Information]

VIEW: JA.JAI_RGM_GST_INVOICE_GEN_T#

Object Details
Object Name: JAI_RGM_GST_INVOICE_GEN_T#
Object Type: VIEW
Owner: JA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DELIVERY_ID NUMBER

DELIVERY_DATE DATE

ORDER_LINE_ID NUMBER

ORDER_NUMBER NUMBER

CUSTOMER_TRX_ID NUMBER

TRX_DATE DATE

ORGANIZATION_ID NUMBER

LOCATION_ID NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

PARTY_ID NUMBER

PARTY_SITE_ID NUMBER

PARTY_TYPE VARCHAR2 (2)
GST_INVOICE_NO VARCHAR2 (150)
GST_INV_GEN_STATUS VARCHAR2 (30)
GST_INV_GEN_ERR_MESSAGE VARCHAR2 (2000)
GST_ACCT_STATUS VARCHAR2 (30)
GST_ACCT_ERR_MESSAGE VARCHAR2 (2000)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
LAST_UPDATED_BY NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER

PROGRAM_LOGIN_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DELIVERY_ID
,      DELIVERY_DATE
,      ORDER_LINE_ID
,      ORDER_NUMBER
,      CUSTOMER_TRX_ID
,      TRX_DATE
,      ORGANIZATION_ID
,      LOCATION_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PARTY_ID
,      PARTY_SITE_ID
,      PARTY_TYPE
,      GST_INVOICE_NO
,      GST_INV_GEN_STATUS
,      GST_INV_GEN_ERR_MESSAGE
,      GST_ACCT_STATUS
,      GST_ACCT_ERR_MESSAGE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      OBJECT_VERSION_NUMBER
,      PROGRAM_LOGIN_ID
FROM JA.JAI_RGM_GST_INVOICE_GEN_T#;

Dependencies

[top of page]

JA.JAI_RGM_GST_INVOICE_GEN_T# references the following:

SchemaJA
TableJAI_RGM_GST_INVOICE_GEN_T
JA.JAI_RGM_GST_INVOICE_GEN_T# is referenced by following:

SchemaAPPS
SynonymJAI_RGM_GST_INVOICE_GEN_T