Product: | CZ - Configurator |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CZ_PSNODE_REFRULE_IMAGES_V |
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