eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CZ_PSNODE_REFRULE_IMAGES_V

Source

View Text - Preformatted


SELECT P2RUL.MODEL_ID, P2RUL.MODEL_REF_EXPL_ID, P2RUL.PS_NODE_ID, P2RUL.PSN_PS_NODE_TYPE, P2RUL.PARENT_ID, P2RUL.PS_NODE_NAME, P2RUL.RULE_DEVL_PROJECT_ID, P2RUL.RULE_ID, P2RUL.RULE_FOLDER_ID, P2RUL.RULE_FOLDER_TYPE, P2RUL.RULE_NAME, P2RUL.RULE_TYPE, P2RUL.DESC_TEXT, P2RUL.DISABLED_FLAG, P2RUL.REFERENCED_RULE_FLAG, RIMG.IMAGE_USAGE_CODE, RIMG.ENTITY_CODE, RIMG.REFERENCED_USAGE_FLAG, RIMG.IMAGE_FILE, RIMG.DATA_VALUE, RIMG.VALUE_LABEL, RIMG.ALT_TEXT, P2RUL.DETAILED_RULE_TYPE, DECODE (p2rul.RULE_TYPE, 200, decode (abs (p2rul.detailed_rule_type), 200, 200, 228), 199) AS RULETYPE_DATATYPE, decode (p2rul.rule_type, 200, decode (p2rul.presentation_flag, 1, (-1 * p2rul.detailed_rule_type), null), null) as expr_root_rule_template_id, rimg.data_value as rule_type_code, rimg.value_label as rule_type_label, rimg.ALT_TEXT as rule_type_description, p2rul.persistent_rule_id, p2rul.desc_text as rule_description, p2rul.seq_nbr, p2rul.signature_id, p2rul.mutable_flag, p2rul.template_token, p2rul.template_primitive_flag, p2rul.presentation_flag, p2rul.rule_text, p2rul.component_id, p2rul.rule_expl_node_id, p2rul.notes, p2rul.class_name, p2rul.instantiation_scope, p2rul.reason_id, p2rul.reason_type, p2rul.unsatisfied_msg_id, p2rul.unsatisfied_msg_source, p2rul.seeded_flag, p2rul.invalid_flag, p2rul.effective_from, p2rul.effective_until, p2rul.effective_usage_mask, p2rul.effectivity_set_id, p2rul.checkout_user, p2rul.orig_sys_ref, P2RUL.PSN_MODEL_ID, P2RUL.RULE_IN_ENCLOSING_MODEL_FLAG, P2RUL.RULE_TYPE_STRING, P2RUL.PARENT_PSNODE_EXPL_ID, P2RUL.EFFECTIVE_PARENT_ID, P2RUL.DESCENDANT_EXPL_NODE_ID, P2RUL.PARTICIPANT_ROLE_LIST, RIMG.FULL_IMAGE_PATH, 'N' AS EFFECTIVITY_FILTER FROM CZ_PSNODE_RULE_REFS_V P2RUL, CZ_RULETYPE_IMAGES_V RIMG WHERE rimg.referenced_usage_flag(+) = P2RUL.REFERENCED_RULE_FLAG and rimg.entity_code(+) = P2RUL.detailed_rule_type UNION ALL SELECT P2RUL.MODEL_ID, P2RUL.MODEL_REF_EXPL_ID, P2RUL.PS_NODE_ID, P2RUL.PSN_PS_NODE_TYPE, P2RUL.PARENT_ID, P2RUL.PS_NODE_NAME, P2RUL.RULE_DEVL_PROJECT_ID, P2RUL.RULE_ID, P2RUL.RULE_FOLDER_ID, P2RUL.RULE_FOLDER_TYPE, P2RUL.RULE_NAME, P2RUL.RULE_TYPE, P2RUL.DESC_TEXT, P2RUL.DISABLED_FLAG, P2RUL.REFERENCED_RULE_FLAG, RIMG.IMAGE_USAGE_CODE, RIMG.ENTITY_CODE, RIMG.REFERENCED_USAGE_FLAG, RIMG.IMAGE_FILE, RIMG.DATA_VALUE, RIMG.VALUE_LABEL, RIMG.ALT_TEXT, P2RUL.DETAILED_RULE_TYPE, DECODE (p2rul.RULE_TYPE, 200, decode (abs (p2rul.detailed_rule_type), 200, 200, 228), 199) AS RULETYPE_DATATYPE, decode (p2rul.rule_type, 200, decode (p2rul.presentation_flag, 1, (-1 * p2rul.detailed_rule_type), null), null) as expr_root_rule_template_id, rimg.data_value as rule_type_code, rimg.value_label as rule_type_label, rimg.ALT_TEXT as rule_type_description, p2rul.persistent_rule_id, p2rul.desc_text as rule_description, p2rul.seq_nbr, p2rul.signature_id, p2rul.mutable_flag, p2rul.template_token, p2rul.template_primitive_flag, p2rul.presentation_flag, p2rul.rule_text, p2rul.component_id, p2rul.rule_expl_node_id, p2rul.notes, p2rul.class_name, p2rul.instantiation_scope, p2rul.reason_id, p2rul.reason_type, p2rul.unsatisfied_msg_id, p2rul.unsatisfied_msg_source, p2rul.seeded_flag, p2rul.invalid_flag, p2rul.effective_from, p2rul.effective_until, p2rul.effective_usage_mask, p2rul.effectivity_set_id, p2rul.checkout_user, p2rul.orig_sys_ref, P2RUL.PSN_MODEL_ID, P2RUL.RULE_IN_ENCLOSING_MODEL_FLAG, P2RUL.RULE_TYPE_STRING, P2RUL.PARENT_PSNODE_EXPL_ID, P2RUL.EFFECTIVE_PARENT_ID, P2RUL.DESCENDANT_EXPL_NODE_ID, P2RUL.PARTICIPANT_ROLE_LIST, RIMG.FULL_IMAGE_PATH, 'Y' AS EFFECTIVITY_FILTER FROM CZ_PSNODE_RULE_REFS_V P2RUL, CZ_RULETYPE_IMAGES_V RIMG WHERE rimg.referenced_usage_flag(+) = P2RUL.REFERENCED_RULE_FLAG AND rimg.entity_code(+) = P2RUL.detailed_rule_type AND CASE WHEN NVL(fnd_profile.value_wnps('CZEFFECTIVITYFILTER'), 'ALL') = 'CURRENT' THEN CASE WHEN (DECODE(p2rul.effectivity_set_id, NULL, p2rul.effective_from, (SELECT effective_from FROM cz_effectivity_sets WHERE deleted_flag = '0' AND effectivity_set_id = p2rul.effectivity_set_id)) <= SYSDATE AND DECODE(p2rul.effectivity_set_id, NULL, p2rul.effective_until, (SELECT effective_until FROM cz_effectivity_sets WHERE deleted_flag = '0' AND effectivity_set_id = p2rul.effectivity_set_id)) > SYSDATE) THEN 1 ELSE 0 END WHEN NVL(fnd_profile.value_wnps('CZEFFECTIVITYFILTER'), 'ALL') = 'FUTUREANDCURRENT' THEN CASE WHEN DECODE(p2rul.effectivity_set_id, NULL, p2rul.effective_until, (SELECT effective_until FROM cz_effectivity_sets WHERE deleted_flag = '0' AND effectivity_set_id = p2rul.effectivity_set_id)) > SYSDATE THEN 1 ELSE 0 END ELSE 1 END = 1

View Text - HTML Formatted

SELECT P2RUL.MODEL_ID
, P2RUL.MODEL_REF_EXPL_ID
, P2RUL.PS_NODE_ID
, P2RUL.PSN_PS_NODE_TYPE
, P2RUL.PARENT_ID
, P2RUL.PS_NODE_NAME
, P2RUL.RULE_DEVL_PROJECT_ID
, P2RUL.RULE_ID
, P2RUL.RULE_FOLDER_ID
, P2RUL.RULE_FOLDER_TYPE
, P2RUL.RULE_NAME
, P2RUL.RULE_TYPE
, P2RUL.DESC_TEXT
, P2RUL.DISABLED_FLAG
, P2RUL.REFERENCED_RULE_FLAG
, RIMG.IMAGE_USAGE_CODE
, RIMG.ENTITY_CODE
, RIMG.REFERENCED_USAGE_FLAG
, RIMG.IMAGE_FILE
, RIMG.DATA_VALUE
, RIMG.VALUE_LABEL
, RIMG.ALT_TEXT
, P2RUL.DETAILED_RULE_TYPE
, DECODE (P2RUL.RULE_TYPE
, 200
, DECODE (ABS (P2RUL.DETAILED_RULE_TYPE)
, 200
, 200
, 228)
, 199) AS RULETYPE_DATATYPE
, DECODE (P2RUL.RULE_TYPE
, 200
, DECODE (P2RUL.PRESENTATION_FLAG
, 1
, (-1 * P2RUL.DETAILED_RULE_TYPE)
, NULL)
, NULL) AS EXPR_ROOT_RULE_TEMPLATE_ID
, RIMG.DATA_VALUE AS RULE_TYPE_CODE
, RIMG.VALUE_LABEL AS RULE_TYPE_LABEL
, RIMG.ALT_TEXT AS RULE_TYPE_DESCRIPTION
, P2RUL.PERSISTENT_RULE_ID
, P2RUL.DESC_TEXT AS RULE_DESCRIPTION
, P2RUL.SEQ_NBR
, P2RUL.SIGNATURE_ID
, P2RUL.MUTABLE_FLAG
, P2RUL.TEMPLATE_TOKEN
, P2RUL.TEMPLATE_PRIMITIVE_FLAG
, P2RUL.PRESENTATION_FLAG
, P2RUL.RULE_TEXT
, P2RUL.COMPONENT_ID
, P2RUL.RULE_EXPL_NODE_ID
, P2RUL.NOTES
, P2RUL.CLASS_NAME
, P2RUL.INSTANTIATION_SCOPE
, P2RUL.REASON_ID
, P2RUL.REASON_TYPE
, P2RUL.UNSATISFIED_MSG_ID
, P2RUL.UNSATISFIED_MSG_SOURCE
, P2RUL.SEEDED_FLAG
, P2RUL.INVALID_FLAG
, P2RUL.EFFECTIVE_FROM
, P2RUL.EFFECTIVE_UNTIL
, P2RUL.EFFECTIVE_USAGE_MASK
, P2RUL.EFFECTIVITY_SET_ID
, P2RUL.CHECKOUT_USER
, P2RUL.ORIG_SYS_REF
, P2RUL.PSN_MODEL_ID
, P2RUL.RULE_IN_ENCLOSING_MODEL_FLAG
, P2RUL.RULE_TYPE_STRING
, P2RUL.PARENT_PSNODE_EXPL_ID
, P2RUL.EFFECTIVE_PARENT_ID
, P2RUL.DESCENDANT_EXPL_NODE_ID
, P2RUL.PARTICIPANT_ROLE_LIST
, RIMG.FULL_IMAGE_PATH
, 'N' AS EFFECTIVITY_FILTER
FROM CZ_PSNODE_RULE_REFS_V P2RUL
, CZ_RULETYPE_IMAGES_V RIMG
WHERE RIMG.REFERENCED_USAGE_FLAG(+) = P2RUL.REFERENCED_RULE_FLAG
AND RIMG.ENTITY_CODE(+) = P2RUL.DETAILED_RULE_TYPE UNION ALL SELECT P2RUL.MODEL_ID
, P2RUL.MODEL_REF_EXPL_ID
, P2RUL.PS_NODE_ID
, P2RUL.PSN_PS_NODE_TYPE
, P2RUL.PARENT_ID
, P2RUL.PS_NODE_NAME
, P2RUL.RULE_DEVL_PROJECT_ID
, P2RUL.RULE_ID
, P2RUL.RULE_FOLDER_ID
, P2RUL.RULE_FOLDER_TYPE
, P2RUL.RULE_NAME
, P2RUL.RULE_TYPE
, P2RUL.DESC_TEXT
, P2RUL.DISABLED_FLAG
, P2RUL.REFERENCED_RULE_FLAG
, RIMG.IMAGE_USAGE_CODE
, RIMG.ENTITY_CODE
, RIMG.REFERENCED_USAGE_FLAG
, RIMG.IMAGE_FILE
, RIMG.DATA_VALUE
, RIMG.VALUE_LABEL
, RIMG.ALT_TEXT
, P2RUL.DETAILED_RULE_TYPE
, DECODE (P2RUL.RULE_TYPE
, 200
, DECODE (ABS (P2RUL.DETAILED_RULE_TYPE)
, 200
, 200
, 228)
, 199) AS RULETYPE_DATATYPE
, DECODE (P2RUL.RULE_TYPE
, 200
, DECODE (P2RUL.PRESENTATION_FLAG
, 1
, (-1 * P2RUL.DETAILED_RULE_TYPE)
, NULL)
, NULL) AS EXPR_ROOT_RULE_TEMPLATE_ID
, RIMG.DATA_VALUE AS RULE_TYPE_CODE
, RIMG.VALUE_LABEL AS RULE_TYPE_LABEL
, RIMG.ALT_TEXT AS RULE_TYPE_DESCRIPTION
, P2RUL.PERSISTENT_RULE_ID
, P2RUL.DESC_TEXT AS RULE_DESCRIPTION
, P2RUL.SEQ_NBR
, P2RUL.SIGNATURE_ID
, P2RUL.MUTABLE_FLAG
, P2RUL.TEMPLATE_TOKEN
, P2RUL.TEMPLATE_PRIMITIVE_FLAG
, P2RUL.PRESENTATION_FLAG
, P2RUL.RULE_TEXT
, P2RUL.COMPONENT_ID
, P2RUL.RULE_EXPL_NODE_ID
, P2RUL.NOTES
, P2RUL.CLASS_NAME
, P2RUL.INSTANTIATION_SCOPE
, P2RUL.REASON_ID
, P2RUL.REASON_TYPE
, P2RUL.UNSATISFIED_MSG_ID
, P2RUL.UNSATISFIED_MSG_SOURCE
, P2RUL.SEEDED_FLAG
, P2RUL.INVALID_FLAG
, P2RUL.EFFECTIVE_FROM
, P2RUL.EFFECTIVE_UNTIL
, P2RUL.EFFECTIVE_USAGE_MASK
, P2RUL.EFFECTIVITY_SET_ID
, P2RUL.CHECKOUT_USER
, P2RUL.ORIG_SYS_REF
, P2RUL.PSN_MODEL_ID
, P2RUL.RULE_IN_ENCLOSING_MODEL_FLAG
, P2RUL.RULE_TYPE_STRING
, P2RUL.PARENT_PSNODE_EXPL_ID
, P2RUL.EFFECTIVE_PARENT_ID
, P2RUL.DESCENDANT_EXPL_NODE_ID
, P2RUL.PARTICIPANT_ROLE_LIST
, RIMG.FULL_IMAGE_PATH
, 'Y' AS EFFECTIVITY_FILTER
FROM CZ_PSNODE_RULE_REFS_V P2RUL
, CZ_RULETYPE_IMAGES_V RIMG
WHERE RIMG.REFERENCED_USAGE_FLAG(+) = P2RUL.REFERENCED_RULE_FLAG
AND RIMG.ENTITY_CODE(+) = P2RUL.DETAILED_RULE_TYPE
AND CASE WHEN NVL(FND_PROFILE.VALUE_WNPS('CZEFFECTIVITYFILTER')
, 'ALL') = 'CURRENT' THEN CASE WHEN (DECODE(P2RUL.EFFECTIVITY_SET_ID
, NULL
, P2RUL.EFFECTIVE_FROM
, (SELECT EFFECTIVE_FROM
FROM CZ_EFFECTIVITY_SETS
WHERE DELETED_FLAG = '0'
AND EFFECTIVITY_SET_ID = P2RUL.EFFECTIVITY_SET_ID)) <= SYSDATE
AND DECODE(P2RUL.EFFECTIVITY_SET_ID
, NULL
, P2RUL.EFFECTIVE_UNTIL
, (SELECT EFFECTIVE_UNTIL
FROM CZ_EFFECTIVITY_SETS
WHERE DELETED_FLAG = '0'
AND EFFECTIVITY_SET_ID = P2RUL.EFFECTIVITY_SET_ID)) > SYSDATE) THEN 1 ELSE 0 END WHEN NVL(FND_PROFILE.VALUE_WNPS('CZEFFECTIVITYFILTER')
, 'ALL') = 'FUTUREANDCURRENT' THEN CASE WHEN DECODE(P2RUL.EFFECTIVITY_SET_ID
, NULL
, P2RUL.EFFECTIVE_UNTIL
, (SELECT EFFECTIVE_UNTIL
FROM CZ_EFFECTIVITY_SETS
WHERE DELETED_FLAG = '0'
AND EFFECTIVITY_SET_ID = P2RUL.EFFECTIVITY_SET_ID)) > SYSDATE THEN 1 ELSE 0 END ELSE 1 END = 1