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

TABLE: JA.JAI_CMN_ST_FORMS

Object Details
Object Name: JAI_CMN_ST_FORMS
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_CMN_ST_FORMS
Subobject Name:
Status: VALID


Stores information pertaining to the ST Forms


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_CMN_ST_FORMS NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORM_ID
Columns
Name Datatype Length Mandatory Comments
FORM_ID NUMBER (38) Yes Link to ja_in_st_forms table
ST_HDR_ID NUMBER (38) Yes Link to ja_in_st_forms_hdr table
FORM_NUMBER VARCHAR2 (25)
Indicates the form number Issued/Received
FIN_YEAR NUMBER (9)
Indicates the financial year in which the form is to be issue/received.
FORM_DATE DATE

Indicates the date on which the form was issued/received
TRANSACTION_DATE DATE

Indicates the date on which the form was used for matching.
FORM_AMOUNT NUMBER

Indicates the form amount matched against the form
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
Query Text

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


SELECT FORM_ID
,      ST_HDR_ID
,      FORM_NUMBER
,      FIN_YEAR
,      FORM_DATE
,      TRANSACTION_DATE
,      FORM_AMOUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_CMN_ST_FORMS;

Dependencies

[top of page]

JA.JAI_CMN_ST_FORMS does not reference any database object

JA.JAI_CMN_ST_FORMS is referenced by following:

SchemaAPPS
SynonymJAI_CMN_ST_FORMS