[Home] [Help] [Dependency Information]
Object Name: | PA_PAGE_CONTENTS |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_PAGE_CONTENTS |
Subobject Name: | |
Status: | VALID |
PA_PAGE_CONTENTS stores the captured html page to be emailed
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_PAGE_CONTENTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PAGE_CONTENT_ID |
PA_PAGE_CONTENTS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
OBJECT_TYPE
PK1_VALUE PK2_VALUE |
SYS_IL0000243775C00008$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAGE_CONTENT_ID | NUMBER | (15) | Yes | System generated number that uniquely identifies page content |
OBJECT_TYPE | VARCHAR2 | (30) | Yes | Type of the object such as PA_PROJECTS |
PK1_VALUE | VARCHAR2 | (256) | Yes | Identifier of the object e.g. project_id if object_type is PA_PROJECTS |
PK2_VALUE | VARCHAR2 | (256) | Identifier of the object | |
PK3_VALUE | VARCHAR2 | (256) | Identifier of the object | |
PK4_VALUE | VARCHAR2 | (256) | Identifier of the object | |
PK5_VALUE | VARCHAR2 | (256) | Identifier of the object | |
PAGE_CONTENT | CLOB | (4000) | Html contents of email and WF notification | |
RECORD_VERSION_NUMBER | NUMBER | (15) | Record Version Number | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT PAGE_CONTENT_ID
, OBJECT_TYPE
, PK1_VALUE
, PK2_VALUE
, PK3_VALUE
, PK4_VALUE
, PK5_VALUE
, PAGE_CONTENT
, RECORD_VERSION_NUMBER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM PA.PA_PAGE_CONTENTS;
PA.PA_PAGE_CONTENTS does not reference any database object
PA.PA_PAGE_CONTENTS is referenced by following:
|
|
|