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


TABLE: CZ.CZ_PB_CLIENT_APPS

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


This table is used to associate client applications with a particular Publication.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Primary Key: CZ_PB_CLIENT_APPS_PK
  1. ColumnPUBLICATION_ID
  2. ColumnFND_APPLICATION_ID
Indexes
Index Type Uniqueness Tablespace Column
CZ_PB_CLIENT_APPS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnPUBLICATION_ID
ColumnFND_APPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
PUBLICATION_ID NUMBER (9) Yes Identifies a publication for this record
FND_APPLICATION_ID NUMBER (9) Yes Associates an application with the publication
APPLICATION_SHORT_NAME VARCHAR2 (50) Yes Brief name for the application (denormalized from FND_APPLICATION)
NOTES VARCHAR2 (255)
Note text
Query Text

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


SELECT PUBLICATION_ID
,      FND_APPLICATION_ID
,      APPLICATION_SHORT_NAME
,      NOTES
FROM CZ.CZ_PB_CLIENT_APPS;

Dependencies

[top of page]

CZ.CZ_PB_CLIENT_APPS does not reference any database object

CZ.CZ_PB_CLIENT_APPS is referenced by following:

SchemaAPPS
SynonymCZ_PB_CLIENT_APPS