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

TABLE: CZ.CZ_GRID_DEFS

Object Details
Object Name: CZ_GRID_DEFS
Object Type: TABLE
Owner: CZ
FND Design Data: TableCZ.CZ_GRID_DEFS
Subobject Name:
Status: VALID


This table is used to define explicit compatibility grids


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
GRID_ID NUMBER (9) Yes Associates an Explicity Compatibility definition with this record
DEVL_PROJECT_ID NUMBER (15) Yes Identifies the project/model associated with this record
NAME VARCHAR2 (255) Yes The name of this object
DESC_TEXT VARCHAR2 (255)
Descriptive text
CREATION_DATE DATE
Yes Standard field recording the date this record was created
LAST_UPDATE_DATE DATE
Yes Standard field recording the date/time this record was last updated
DELETED_FLAG VARCHAR2 (1) Yes Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved
EFF_FROM DATE

UNUSED
EFF_TO DATE

UNUSED
CREATED_BY NUMBER (15) Yes Standard field recording the ID of the user that created this record
LAST_UPDATED_BY NUMBER (15) Yes Standard field recording the ID of the user that last updated this record
SECURITY_MASK VARCHAR2 (40)
UNUSED
EFF_MASK VARCHAR2 (40)
UNUSED
CHECKOUT_USER VARCHAR2 (40)
UNUSED
LAST_UPDATE_LOGIN NUMBER (15)
Records the login ID under which this record was last updated
Query Text

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


SELECT GRID_ID
,      DEVL_PROJECT_ID
,      NAME
,      DESC_TEXT
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      EFF_MASK
,      CHECKOUT_USER
,      LAST_UPDATE_LOGIN
FROM CZ.CZ_GRID_DEFS;

Dependencies

[top of page]

CZ.CZ_GRID_DEFS does not reference any database object

CZ.CZ_GRID_DEFS is referenced by following:

SchemaAPPS
SynonymCZ_GRID_DEFS
TriggerCZ_GRID_DEFS_T1