VIEW: APPS.CZ_COMPATCELL_NODE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'