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

VIEW: JA.JAI_CMN_ST_FORM_DTLS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ST_HDR_ID NUMBER (38) Yes
ST_DTL_ID NUMBER (38) Yes
HEADER_ID NUMBER (15)
LINE_ID NUMBER (15)
LOCATION_ID NUMBER (15)
ORGANIZATION_ID NUMBER (15)
TAX_ID NUMBER (15)
TAX_LINE_NO NUMBER (15)
INVOICE_ID NUMBER

ISSUE_RECEIPT_FLAG VARCHAR2 (1)
TAX_TARGET_AMOUNT NUMBER

MATCHED_AMOUNT NUMBER

PO_NUM VARCHAR2 (20)
DOC_TYPE VARCHAR2 (30)
PO_LINE_LOCATION_ID NUMBER (15)
RCV_TRANSACTION_ID NUMBER (15)
INVOICE_DISTRIBUTION_ID NUMBER (15)
ORDER_FLAG VARCHAR2 (1)
ORDER_NUMBER NUMBER

TRX_TYPE_ID NUMBER

TRX_NUMBER VARCHAR2 (40)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
MIGRATED_HDR NUMBER (15)
MIGRATED_DTL NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER

INVOICE_LINE_NUMBER NUMBER (15)
Query Text

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


SELECT ST_HDR_ID
,      ST_DTL_ID
,      HEADER_ID
,      LINE_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      TAX_ID
,      TAX_LINE_NO
,      INVOICE_ID
,      ISSUE_RECEIPT_FLAG
,      TAX_TARGET_AMOUNT
,      MATCHED_AMOUNT
,      PO_NUM
,      DOC_TYPE
,      PO_LINE_LOCATION_ID
,      RCV_TRANSACTION_ID
,      INVOICE_DISTRIBUTION_ID
,      ORDER_FLAG
,      ORDER_NUMBER
,      TRX_TYPE_ID
,      TRX_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      MIGRATED_HDR
,      MIGRATED_DTL
,      OBJECT_VERSION_NUMBER
,      INVOICE_LINE_NUMBER
FROM JA.JAI_CMN_ST_FORM_DTLS#;

Dependencies

[top of page]

JA.JAI_CMN_ST_FORM_DTLS# references the following:

SchemaJA
TableJAI_CMN_ST_FORM_DTLS
JA.JAI_CMN_ST_FORM_DTLS# is referenced by following:

SchemaAPPS
SynonymJAI_CMN_ST_FORM_DTLS