VIEW: APPS.CZ_JAVASYSPROPVALS_LKV

Source

View Text - Preformatted

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 '/'

View Text - HTML Formatted

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 '/'