Skip to content

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

TABLE: GMS.GMS_TERMS_CONDITIONS

Object Details
Object Name: GMS_TERMS_CONDITIONS
Object Type: TABLE
Owner: GMS
FND Design Data: TableGMS.GMS_TERMS_CONDITIONS
Subobject Name:
Status: VALID


GMS_TERMS_CONDITIONS stores the terms and conditions used by the award. The user defines both the categories and the terms and conditions as determined by the award.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMS_TERMS_CONDITIONS_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCATEGORY_ID
ColumnNAME
GMS_TERMS_CONDITIONS_U3 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnNAME
ColumnTERM_ID
GMS_TERMS_CONDITIONS_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnTERM_ID
Columns
Name Datatype Length Mandatory Comments
TERM_ID NUMBER (15) Yes Term identifier
CATEGORY_ID NUMBER (15)
Category identifier
NAME VARCHAR2 (30) Yes Terms and conditions name
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
DESCRIPTION VARCHAR2 (240)
Description
START_DATE_ACTIVE DATE

First effective date of terms and conditions
END_DATE_ACTIVE DATE

Last effective date of terms and conditions
Query Text

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


SELECT TERM_ID
,      CATEGORY_ID
,      NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
FROM GMS.GMS_TERMS_CONDITIONS;

Dependencies

[top of page]

GMS.GMS_TERMS_CONDITIONS does not reference any database object

GMS.GMS_TERMS_CONDITIONS is referenced by following:

SchemaGMS
ViewGMS_TERMS_CONDITIONS#