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

TABLE: GML.OP_TERM_MST_INT

Object Details
Object Name: OP_TERM_MST_INT
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.OP_TERM_MST_INT
Subobject Name:
Status: VALID


This table is not used in 11i and may be dropped in a future release.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TERMS_CODE VARCHAR2 (50) Yes Same as op_term_mst.
TERMS_DESC VARCHAR2 (40) Yes Same as op_term_mst
DISCOUNT_RATE NUMBER
Yes Same as op_term_mst
DISCOUNT_DAYS NUMBER (5) Yes Same as op_term_mst
NET_DAYS NUMBER (5) Yes Same as op_term_mst
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
TRANS_CNT NUMBER (10)
Not currently used
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
INVALID_IND NUMBER (5) Yes 0=Valid Data; 1= Invalid Data
DIRECTION_IND NUMBER (5) Yes 0=Data coming into GEMMS; 1=Data going out of GEMMS
Query Text

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


SELECT TERMS_CODE
,      TERMS_DESC
,      DISCOUNT_RATE
,      DISCOUNT_DAYS
,      NET_DAYS
,      DELETE_MARK
,      TEXT_CODE
,      TRANS_CNT
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      INVALID_IND
,      DIRECTION_IND
FROM GML.OP_TERM_MST_INT;

Dependencies

[top of page]

GML.OP_TERM_MST_INT does not reference any database object

GML.OP_TERM_MST_INT is referenced by following:

SchemaGML
ViewOP_TERM_MST_INT#