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

TABLE: GML.OP_CPRC_CLS

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


This table contains the definition for Customer Price Classes. These classes are assigned to customers for use in grouping customers for pricing purposes, such as assignment of price lists and charges.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OP_CPRC_CLS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCUSTPRICE_CLASS
Columns
Name Datatype Length Mandatory Comments
CUSTPRICE_CLASS VARCHAR2 (8) Yes Class to group customers for pricing purposes. Used in pricing tables.
CUSTPRICE_DESC VARCHAR2 (70) Yes Description of customer price class.
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
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
Query Text

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


SELECT CUSTPRICE_CLASS
,      CUSTPRICE_DESC
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
,      TEXT_CODE
,      TRANS_CNT
FROM GML.OP_CPRC_CLS;

Dependencies

[top of page]

GML.OP_CPRC_CLS does not reference any database object

GML.OP_CPRC_CLS is referenced by following:

SchemaAPPS
SynonymOP_CPRC_CLS