Product: | CZ - Configurator |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CZ_JAVASYSPROPVALS_LKV |
SELECT JVLK.LIST_NAME
, JVLK.DATA_VALUE
, JVLK.NUMERIC_ID_VALUE
, JVLK.VALUE_SEQ
, JVLK.DATA_TYPE_ID
, JVLK.NULL_VALUE_FLAG
, DECODE(JVLK.LIST_NAME
, 'SYSPROPVALS_LOGIC_STATE'
, JVLK.DATA_VALUE
, JVLK.VALUE_LABEL) AS VALUE_LABEL
, JVLK.VALUE_DESCRIPTION
, JVLK.VALUE_NOTES
, JVLK.LANGUAGE
, JVLK.SOURCE_LANG
, PRSIG.SIGNATURE_ID AS PROPERTY_SIGNATURE_ID
, PRSIG.NAME AS PROPERTY_SIGNATURE_NAME
, PRRUL.RULE_ID AS PROPERTY_RULE_ID
, PRRUL.NAME AS PROPERTY_RULE_NAME
, PRRUL.DESC_TEXT AS PROPERTY_RULE_DESC
, PRRUL.DEVL_PROJECT_ID AS PROPERTY_RULE_MODEL_ID
, PRRUL.MUTABLE_FLAG AS PROPERTY_RULE_MUTABLE_FLAG
, PRRUL.TEMPLATE_TOKEN AS PROPERTY_RULE_TOKEN
FROM CZ_LOOKUP_VALUES_VL JVLK
, CZ_SIGNATURES PRSIG
, CZ_RULES PRRUL
WHERE PRRUL.RULE_TYPE = 501
AND PRRUL.SIGNATURE_ID = PRSIG.SIGNATURE_ID
AND PRRUL.DELETED_FLAG = '0'
AND JVLK.DATA_TYPE_ID IN PRSIG.DATA_TYPE
AND PRSIG.DELETED_FLAG = '0'
AND LIST_NAME LIKE 'SYSPROPVALS/_%' ESCAPE '/'