[Home] [Help] [Dependency Information]
Object Name: | CZ_PSNODE_PROPCOMPAT_GENS |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_PSNODE_PROPCOMPAT_GENS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_PSNODE_PROPCOMPAT_GENS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
COMPAT_RUN
COMPAT_FEAT PROPERTY_VALUE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPAT_RUN | NUMBER | Yes | Run ID for the logic generation in which this property-based compatibility is being compiled | |
COMPAT_FEAT | VARCHAR2 | (1) | Yes | Feature participating in this property-based compatibility generation |
PS_NODE_ID | NUMBER | Yes | Associates this record with a Model structure node ('psnode') | |
PARENT_ID | NUMBER | Yes | Identifies the parent record of this one to implement a data hierarchy | |
PS_NODE_NAME | VARCHAR2 | (255) | Yes | Name of the psnode described in this compatibility entry |
PROPERTY_ID | NUMBER | Yes | Associates this record with a Property | |
PROPERTY_NAME | VARCHAR2 | (255) | Yes | Name of the associated Property |
PROPERTY_VALUE | VARCHAR2 | (255) | Specifies a value for the Property associated with this record | |
ITEM_ID | NUMBER | Associates an Item Master record with this record | ||
ITEM_TYPE_ID | NUMBER | ID of the item type associated with this record | ||
VALUESOURCE | VARCHAR2 | (30) | Yes | Indicates the source of this property value as applied to the psnode - 'Item' indicates the property value is on the attached item, 'ItmTyp' indicates the item type, 'PsValue' indicates the value is from a psnode-attached property, 'PsDflt' indicates the default property value overrides property values from attached items |
DELETED_FLAG | VARCHAR2 | (1) | Yes | Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved |
CREATED_BY | NUMBER | (15) | Standard field recording the ID of the user that created this record | |
CREATION_DATE | DATE | Standard field recording the date this record was created | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard field recording the ID of the user that last updated this record | |
LAST_UPDATE_DATE | DATE | Standard field recording the date/time this record was last updated | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Records the login ID under which this record was last updated | |
EFF_FROM | DATE | UNUSED | ||
EFF_TO | DATE | UNUSED | ||
EFF_MASK | VARCHAR2 | (40) | UNUSED | |
SECURITY_MASK | VARCHAR2 | (40) | UNUSED | |
CHECKOUT_USER | VARCHAR2 | (40) | UNUSED | |
PROPERTY_VALUE_NUM | NUMBER | (25) | Numeric value for this psnode property if applicable | |
PERSISTENT_PS_NODE_ID | NUMBER | Persistent ID of this psnode described by this entry | ||
PERSISTENT_PARENT_ID | NUMBER | Persistent ID of the parent (feature) psnode | ||
MODEL_REF_EXPL_ID | NUMBER | (9) | Associates this record with a model-reference explosion node in the current model |
Cut, paste (and edit) the following text to query this object:
SELECT COMPAT_RUN
, COMPAT_FEAT
, PS_NODE_ID
, PARENT_ID
, PS_NODE_NAME
, PROPERTY_ID
, PROPERTY_NAME
, PROPERTY_VALUE
, ITEM_ID
, ITEM_TYPE_ID
, VALUESOURCE
, DELETED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, EFF_FROM
, EFF_TO
, EFF_MASK
, SECURITY_MASK
, CHECKOUT_USER
, PROPERTY_VALUE_NUM
, PERSISTENT_PS_NODE_ID
, PERSISTENT_PARENT_ID
, MODEL_REF_EXPL_ID
FROM CZ.CZ_PSNODE_PROPCOMPAT_GENS;
CZ.CZ_PSNODE_PROPCOMPAT_GENS does not reference any database object
CZ.CZ_PSNODE_PROPCOMPAT_GENS is referenced by following:
|
|
|