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

TABLE: GMD.GMD_ACTIVITIES_B

Object Details
Object Name: GMD_ACTIVITIES_B
Object Type: TABLE
Owner: GMD
FND Design Data: TableGMD.GMD_ACTIVITIES_B
Subobject Name:
Status: VALID


Activities base table. Defines activities which are performed in
operations.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMD_ACTIVITIES_B_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTIVITY
Columns
Name Datatype Length Mandatory Comments
ACTIVITY VARCHAR2 (16) Yes Code for the activity.
ACTIVITY_DESC VARCHAR2 (40)
Description of the activity.
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
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
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
COST_ANALYSIS_CODE#1 VARCHAR2 (32) Yes The cost analysis code for this activity, for example, is this a value added or non-value added activity.
Query Text

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


SELECT ACTIVITY
,      ACTIVITY_DESC
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      DELETE_MARK
,      TEXT_CODE
,      TRANS_CNT
,      LAST_UPDATE_LOGIN
,      COST_ANALYSIS_CODE#1
FROM GMD.GMD_ACTIVITIES_B;

Dependencies

[top of page]

GMD.GMD_ACTIVITIES_B does not reference any database object

GMD.GMD_ACTIVITIES_B is referenced by following:

SchemaGMD
ViewGMD_ACTIVITIES_B#