[Home] [Help] [Dependency Information]
Object Name: | CZ_UI_PAGE_ELEMENTS |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_UI_PAGE_ELEMENTS |
Subobject Name: | |
Status: | VALID |
CZ_UI_PAGE_ELEMENTS describes the contents of a UI page in a parent/child hierarchy of element types.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_UI_PAGE_ELEMENTS_PK | NORMAL | UNIQUE | APPS_TS_SEED |
UI_DEF_ID
PAGE_ID ELEMENT_ID |
CZ_UI_PAGE_ELEMENTS_N10 | NORMAL | NONUNIQUE | APPS_TS_SEED |
DELETED_FLAG
UI_DEF_ID PERSISTENT_NODE_ID |
CZ_UI_PAGE_ELEMENTS_N11 | NORMAL | NONUNIQUE | APPS_TS_SEED |
CTRL_TEMPLATE_ID
CTRL_TEMPLATE_UI_DEF_ID |
CZ_UI_PAGE_ELEMENTS_N12 | NORMAL | NONUNIQUE | APPS_TS_SEED |
TARGET_PAGE_UI_DEF_ID
TARGET_PAGE_ID DELETED_FLAG |
CZ_UI_PAGE_ELEMENTS_N3 | NORMAL | NONUNIQUE | APPS_TS_SEED |
UI_DEF_ID
PARENT_ELEMENT_ID DELETED_FLAG |
CZ_UI_PAGE_ELEMENTS_N4 | NORMAL | NONUNIQUE | APPS_TS_SEED |
UI_DEF_ID
PAGE_ID DELETED_FLAG |
CZ_UI_PAGE_ELEMENTS_N5 | NORMAL | NONUNIQUE | APPS_TS_SEED |
UI_DEF_ID
DELETED_FLAG |
CZ_UI_PAGE_ELEMENTS_N6 | NORMAL | NONUNIQUE | APPS_TS_SEED |
UI_DEF_ID
PERSISTENT_NODE_ID DELETED_FLAG |
CZ_UI_PAGE_ELEMENTS_N7 | NORMAL | NONUNIQUE | APPS_TS_SEED |
UI_DEF_ID
PARENT_ELEMENT_ID SEQ_NBR ELEMENT_TYPE |
CZ_UI_PAGE_ELEMENTS_N8 | NORMAL | NONUNIQUE | APPS_TS_SEED |
UI_DEF_ID
PARENT_PERSISTENT_NODE_ID PERSISTENT_NODE_ID DELETED_FLAG |
CZ_UI_PAGE_ELEMENTS_N9 | NORMAL | NONUNIQUE | APPS_TS_SEED |
UI_DEF_ID
ELEMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UI_DEF_ID | NUMBER | Yes | identifies UI (PK) | |
PAGE_ID | NUMBER | Yes | identifies base page (PK)-- > CZ_UI_PAGES.page_id | |
PERSISTENT_NODE_ID | NUMBER | |||
ELEMENT_ID | VARCHAR2 | (255) | Yes | identifies element on the page - this is value of XML attribute "id" |
PARENT_PERSISTENT_NODE_ID | NUMBER | |||
REGION_PERSISTENT_NODE_ID | NUMBER | Yes | dentifies persistent_node_id of the nearest region | |
PAGEBASE_PERSISTENT_NODE_ID | NUMBER | Yes | identifies persistent_node_id of the nearest base page | |
CTRL_TEMPLATE_ID | NUMBER | identifies UI template for this UI node-> CZ_UI_TEMPLATES.template_id | ||
BASE_PAGE_FLAG | NUMBER | NULL/'0' or '1' | ||
INSTANTIABLE_FLAG | VARCHAR2 | (1) | Denormalization from CZ_PS_NODES.INSTANTIABLE_FLAG for element's Associated Model Node. INSTANTIABLE_FLAG records the user's intended instantiation behavior for Component and Reference structure nodes. '1' indicates an Optional node (minimum 0 instances, maximum 1 instance); '2' indicates a Mandatory or Single instance (1, 1) node; '4' indicates a Multiply-Instantiable node, allowing a maximum of two or more instances. Also, the value '3' is used for Connectors. | |
SEQ_NBR | NUMBER | Yes | ||
DELETED_FLAG | VARCHAR2 | (1) | Yes | Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved |
CREATED_BY | NUMBER | Yes | Standard field recording the ID of the user that created this record | |
CREATION_DATE | DATE | Yes | Standard field recording the date this record was created | |
LAST_UPDATED_BY | NUMBER | Yes | Standard field recording the ID of the user that last updated this record | |
LAST_UPDATE_DATE | DATE | Yes | Standard field recording the date/time this record was last updated | |
LAST_UPDATE_LOGIN | NUMBER | Records the login ID under which this record was last updated | ||
CTRL_TEMPLATE_UI_DEF_ID | NUMBER | |||
MODEL_REF_EXPL_ID | NUMBER | Explosion ID of associated model node, if any. | ||
SUPPRESS_REFRESH_FLAG | VARCHAR2 | (1) | '1' if element can be updated by UI refresh, '0' if not. | |
PARENT_ELEMENT_ID | VARCHAR2 | (255) | ELEMENT_ID of parent page element. | |
ELEMENT_TYPE | NUMBER | Type of UI element (520 - page, 521 - region, 522 - generic (not page, region, or special control), 523 - drilldown control, 524 - add non-BOM instance management control, 525 - add BOM instance management control, 526 - delete instance management control). FK to CZ_SIGNATURES | ||
NAME | VARCHAR2 | (255) | None | |
ELEMENT_SIGNATURE_ID | NUMBER | Signature ID that corresponds to the OA element type. FK to CZ_SIGNATURES. | ||
TARGET_PAGE_UI_DEF_ID | NUMBER | UI Def Id of target UI page | ||
TARGET_PAGE_ID | NUMBER | Page Id of target UI page |
Cut, paste (and edit) the following text to query this object:
SELECT UI_DEF_ID
, PAGE_ID
, PERSISTENT_NODE_ID
, ELEMENT_ID
, PARENT_PERSISTENT_NODE_ID
, REGION_PERSISTENT_NODE_ID
, PAGEBASE_PERSISTENT_NODE_ID
, CTRL_TEMPLATE_ID
, BASE_PAGE_FLAG
, INSTANTIABLE_FLAG
, SEQ_NBR
, DELETED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CTRL_TEMPLATE_UI_DEF_ID
, MODEL_REF_EXPL_ID
, SUPPRESS_REFRESH_FLAG
, PARENT_ELEMENT_ID
, ELEMENT_TYPE
, NAME
, ELEMENT_SIGNATURE_ID
, TARGET_PAGE_UI_DEF_ID
, TARGET_PAGE_ID
FROM CZ.CZ_UI_PAGE_ELEMENTS;
CZ.CZ_UI_PAGE_ELEMENTS does not reference any database object
CZ.CZ_UI_PAGE_ELEMENTS is referenced by following:
|
|
|