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

TABLE: GML.OP_CHRG_CLS

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


Ancillary charge tax classes are defined in this table. These classes are assigned to charges and used when defining tax rates. Tax rates (in the OPM Tax Application) are defined for either an item or charge class.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OP_CHRG_CLS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHGTAX_CLASS
Columns
Name Datatype Length Mandatory Comments
CHGTAX_CLASS VARCHAR2 (8) Yes Primary key user entered.
CHGTAX_DESC VARCHAR2 (70) Yes User entered description for class
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
TRANS_CNT NUMBER (10)
Not currently used
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
Query Text

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


SELECT CHGTAX_CLASS
,      CHGTAX_DESC
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
FROM GML.OP_CHRG_CLS;

Dependencies

[top of page]

GML.OP_CHRG_CLS does not reference any database object

GML.OP_CHRG_CLS is referenced by following:

SchemaAPPS
SynonymOP_CHRG_CLS