View: CZ_PSNODE_DIRECTPROP_INFO_V

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

View Text

SELECT PS_NODE_ID
, PS_NODE_NAME
, PROPERTY_ID
, PROPERTY_NAME
, DATA_TYPE
, PROPERTY_VALUE
, PROPERTY_NUM_VALUE
, ITEM_ID
, ITEM_TYPE_ID
, DEFAULT_VALUE
, DEF_NUM_VALUE
, PROP_ATTACHES
, ORIG_SYS_REF
, VALUE_ORIG_SYS_REF
, PROPERTY_ORIG_SYS_REF
, (SELECT TEXT_STR
FROM CZ_INTL_TEXTS
WHERE DELETED_FLAG = '0'
AND CZ_PSNODE_PROPVAL_V.DATA_TYPE = 8
AND INTL_TEXT_ID=CZ_PSNODE_PROPVAL_V.PROPERTY_NUM_VALUE) AS TRANSLATED_TEXT
, (SELECT TEXT_STR
FROM CZ_INTL_TEXTS
WHERE DELETED_FLAG = '0'
AND CZ_PSNODE_PROPVAL_V.DATA_TYPE = 8
AND INTL_TEXT_ID=CZ_PSNODE_PROPVAL_V.DEF_NUM_VALUE) AS DEF_TRANSLATED_TEXT
, CZ_UI_PATHED_IMAGES_V.IMAGE_FILE
, CZ_UI_PATHED_IMAGES_V.FULL_IMAGE_PATH
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS ALT_TEXT
, CZ_PSNODE_PROPVAL_V.PS_NODE_TYPE AS PS_NODE_TYPE
, CZ_PSNODE_PROPVAL_V.INHERITED_FLAG
, CZ_PSNODE_PROPVAL_V.SRC_APPLICATION_ID
FROM CZ_PSNODE_PROPVAL_V
, CZ_UI_PATHED_IMAGES_V
, CZ_RPOBJECTTYPES_LKV
WHERE CZ_RPOBJECTTYPES_LKV.DATA_VALUE = 'PRP'
AND CZ_UI_PATHED_IMAGES_V.ENTITY_CODE = CZ_RPOBJECTTYPES_LKV.NUMERIC_ID_VALUE
AND CZ_UI_PATHED_IMAGES_V.SEEDED_FLAG = '1'
AND CZ_UI_PATHED_IMAGES_V.UI_DEF_ID=0
AND CZ_UI_PATHED_IMAGES_V.IMAGE_USAGE_CODE = 30

Columns