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

VIEW: APPS.CZ_NODETYPE_SYSPROPS_V

Object Details
Object Name: CZ_NODETYPE_SYSPROPS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCZ.CZ_NODETYPE_SYSPROPS_V
Subobject Name:
Status: VALID


CZ_NODETYPE_SYSPROPS_V associates each type of Configurator Model Node (including subtypes like "Optional Reference to a BOM Model") with all of the system properties that are available on that type of node.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DETAILED_TYPE_ID NUMBER
Yes
DETAILED_TYPE_NAME VARCHAR2 (30)
SYS_PROP_NAME VARCHAR2 (255)
SYS_PROP_RETTYPE_ID NUMBER

SYS_PROP_RETCOLL_FLAG VARCHAR2 (1)
SYS_PROP_RETMUTABLE_FLAG VARCHAR2 (1) Yes
SYS_PROP_RETTYPE_NAME VARCHAR2 (30)
PROPATTACH_SIG_NAME VARCHAR2 (30)
PROPATTACH_SIGNATURE_ID NUMBER
Yes
RULE_ID NUMBER (9) Yes
SYS_PROP_SIGNATURE_ID NUMBER

SYS_PROP_SIGNATURE_NAME VARCHAR2 (30)
RULE_TYPE_CODE VARCHAR2 (255) Yes
RULE_TYPE NUMBER (9) Yes
RULE_TYPE_LABEL VARCHAR2 (255)
CONFIG_ENGINE_TYPE VARCHAR2 (1)
Query Text

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


SELECT DETAILED_TYPE_ID
,      DETAILED_TYPE_NAME
,      SYS_PROP_NAME
,      SYS_PROP_RETTYPE_ID
,      SYS_PROP_RETCOLL_FLAG
,      SYS_PROP_RETMUTABLE_FLAG
,      SYS_PROP_RETTYPE_NAME
,      PROPATTACH_SIG_NAME
,      PROPATTACH_SIGNATURE_ID
,      RULE_ID
,      SYS_PROP_SIGNATURE_ID
,      SYS_PROP_SIGNATURE_NAME
,      RULE_TYPE_CODE
,      RULE_TYPE
,      RULE_TYPE_LABEL
,      CONFIG_ENGINE_TYPE
FROM APPS.CZ_NODETYPE_SYSPROPS_V;

Dependencies

[top of page]

APPS.CZ_NODETYPE_SYSPROPS_V references the following:

SchemaAPPS
SynonymCZ_RULES
ViewCZ_RULETYPECODES_LKV
SynonymCZ_SIGNATURES
SynonymCZ_TYPE_RELATIONSHIPS

APPS.CZ_NODETYPE_SYSPROPS_V is not referenced by any database object