View: CZ_COMPATCELL_NODE_V

Product:	CZ - Configurator
Description:
Implementation/DBA Data:	APPS.CZ_COMPATCELL_NODE_V

View Text

SELECT DCL.RULE_ID
, DCL.PRIMARY_OPT_ID
, DCL.SECONDARY_OPT_ID
, DCL.MARK_CHAR
, DCL.DELETED_FLAG
, DCL.SECONDARY_FEAT_EXPL_ID
, DCL.SECONDARY_FEATURE_ID
, PSN.PS_NODE_ID
, PSN.DEVL_PROJECT_ID
, PSN.FROM_POPULATOR_ID
, PSN.PROPERTY_BACKPTR
, PSN.ITEM_TYPE_BACKPTR
, PSN.INTL_TEXT_ID
, PSN.SUB_CONS_ID
, PSN.ITEM_ID
, PSN.NAME
, PSN.ORIG_SYS_REF
, PSN.RESOURCE_FLAG
, PSN.INITIAL_VALUE
, PSN.PARENT_ID
, PSN.MINIMUM
, PSN.MAXIMUM
, PSN.PS_NODE_TYPE
, PSN.FEATURE_TYPE
, PSN.PRODUCT_FLAG
, PSN.REFERENCE_ID
, PSN.MULTI_CONFIG_FLAG
, PSN.ORDER_SEQ_FLAG
, PSN.SYSTEM_NODE_FLAG
, PSN.TREE_SEQ
, PSN.COUNTED_OPTIONS_FLAG
, PSN.UI_OMIT
, PSN.UI_SECTION
, PSN.BOM_TREATMENT
, PSN.COMPONENT_SEQUENCE_ID
, PSN.BOM_REQUIRED_FLAG
, PSN.SO_ITEM_TYPE_CODE
, PSN.MINIMUM_SELECTED
, PSN.MAXIMUM_SELECTED
, PSN.USER_NUM01
, PSN.USER_NUM02
, PSN.USER_NUM03
, PSN.USER_NUM04
, PSN.USER_STR01
, PSN.USER_STR02
, PSN.USER_STR03
, PSN.USER_STR04
, PSN.VIRTUAL_FLAG
, PSN.LAST_UPDATE_LOGIN
, PSN.EFFECTIVE_USAGE_MASK
, PSN.EFFECTIVE_FROM
, PSN.EFFECTIVE_UNTIL
, PSN.DECIMAL_QTY_FLAG
, PSN.PERSISTENT_NODE_ID
, PSN.COMPONENT_SEQUENCE_PATH
, PSN.VIOLATION_TEXT_ID
, PSN.EFFECTIVITY_SET_ID
, PSN.QUOTEABLE_FLAG
, PSN.PRIMARY_UOM_CODE
, PSN.BOM_SORT_ORDER
, PSN.IB_TRACKABLE
, PSN.COMPONENT_ID
FROM CZ_DES_CHART_CELLS DCL
, CZ_PS_NODES PSN
WHERE DCL.SECONDARY_OPT_ID = PSN.PS_NODE_ID
AND DCL.DELETED_FLAG = '0'
AND PSN.DELETED_FLAG = '0'

Columns