Product: | CZ - Configurator |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CZ_MODELRULEFOLDER_IMAGES_V |
SELECT MRFL.MODEL_ID
, MRFL.NODE_DEPTH
, MRFL.RULE_FOLDER_ID
, MRFL.NAME
, MRFL.DESC_TEXT
, MRFL.PARENT_RULE_FOLDER_ID
, MRFL.DEVL_PROJECT_ID
, MRFL.REFERENCED_RULE_FOLDER_FLAG
, MRFL.TREE_SEQ
, MRFL.DELETED_FLAG
, MRFL.CREATION_DATE
, MRFL.CREATED_BY
, MRFL.LAST_UPDATE_DATE
, MRFL.LAST_UPDATED_BY
, MRFL.LAST_UPDATE_LOGIN
, MRFL.FOLDER_TYPE
, MRFL.EFFECTIVE_USAGE_MASK
, MRFL.EFFECTIVE_FROM
, MRFL.EFFECTIVE_UNTIL
, MRFL.PERSISTENT_RULE_FOLDER_ID
, MRFL.EFFECTIVITY_SET_ID
, MRFL.OBJECT_TYPE
, MRFL.DISABLED_FLAG
, MRFL.ORIG_SYS_REF
, MRFL.DETAILED_RULE_TYPE
, MRFL.RULE_TYPE_LABEL
, MRFL.RULE_TYPE_DESCRIPTION
, MRFL.INVALID_FLAG
, MRFL.PRESENTATION_FLAG
, RTIMG.IMAGE_FILE
, RTIMG.DATA_VALUE
, RTIMG.VALUE_LABEL
, RTIMG.ALT_TEXT
, RTIMG.FULL_IMAGE_PATH
, MRFL.RULE_TYPE
, MRFL.SEQ_NBR
, MRFL.RULE_CLASS
, MRFL.CLASS_SEQ
, 'N' AS EFFECTIVITY_FILTER
FROM CZ_MODEL_ALL_RULEFOLDERS_V MRFL
, CZ_RULETYPE_IMAGES_V RTIMG
WHERE MRFL.DETAILED_RULE_TYPE = RTIMG.ENTITY_CODE (+)
AND MRFL.REFERENCED_RULE_FOLDER_FLAG = RTIMG.REFERENCED_USAGE_FLAG (+)
AND MRFL.DETAILED_RULE_TYPE NOT IN (33
, 34
, 400
, 500
, 501
, 502
, 700) UNION ALL SELECT MRFL.MODEL_ID
, MRFL.NODE_DEPTH
, MRFL.RULE_FOLDER_ID
, MRFL.NAME
, MRFL.DESC_TEXT
, MRFL.PARENT_RULE_FOLDER_ID
, MRFL.DEVL_PROJECT_ID
, MRFL.REFERENCED_RULE_FOLDER_FLAG
, MRFL.TREE_SEQ
, MRFL.DELETED_FLAG
, MRFL.CREATION_DATE
, MRFL.CREATED_BY
, MRFL.LAST_UPDATE_DATE
, MRFL.LAST_UPDATED_BY
, MRFL.LAST_UPDATE_LOGIN
, MRFL.FOLDER_TYPE
, MRFL.EFFECTIVE_USAGE_MASK
, MRFL.EFFECTIVE_FROM
, MRFL.EFFECTIVE_UNTIL
, MRFL.PERSISTENT_RULE_FOLDER_ID
, MRFL.EFFECTIVITY_SET_ID
, MRFL.OBJECT_TYPE
, MRFL.DISABLED_FLAG
, MRFL.ORIG_SYS_REF
, MRFL.DETAILED_RULE_TYPE
, MRFL.RULE_TYPE_LABEL
, MRFL.RULE_TYPE_DESCRIPTION
, MRFL.INVALID_FLAG
, MRFL.PRESENTATION_FLAG
, RTIMG.IMAGE_FILE
, RTIMG.DATA_VALUE
, RTIMG.VALUE_LABEL
, RTIMG.ALT_TEXT
, RTIMG.FULL_IMAGE_PATH
, MRFL.RULE_TYPE
, MRFL.SEQ_NBR
, MRFL.RULE_CLASS
, MRFL.CLASS_SEQ
, 'Y' AS EFFECTIVITY_FILTER
FROM CZ_MODEL_ALL_RULEFOLDERS_V MRFL
, CZ_RULETYPE_IMAGES_V RTIMG
WHERE MRFL.DETAILED_RULE_TYPE = RTIMG.ENTITY_CODE (+)
AND MRFL.REFERENCED_RULE_FOLDER_FLAG = RTIMG.REFERENCED_USAGE_FLAG (+)
AND MRFL.DETAILED_RULE_TYPE NOT IN (33
, 34
, 400
, 500
, 501
, 502
, 700)
AND CASE WHEN MRFL.OBJECT_TYPE IN ('RFL'
, 'RSQ') THEN 1 WHEN NVL(FND_PROFILE.VALUE_WNPS('CZEFFECTIVITYFILTER')
, 'ALL') = 'CURRENT' THEN CASE WHEN (DECODE(MRFL.EFFECTIVITY_SET_ID
, NULL
, MRFL.EFFECTIVE_FROM
, (SELECT EFFECTIVE_FROM
FROM CZ_EFFECTIVITY_SETS
WHERE DELETED_FLAG = '0'
AND EFFECTIVITY_SET_ID = MRFL.EFFECTIVITY_SET_ID)) <= SYSDATE
AND DECODE(MRFL.EFFECTIVITY_SET_ID
, NULL
, MRFL.EFFECTIVE_UNTIL
, (SELECT EFFECTIVE_UNTIL
FROM CZ_EFFECTIVITY_SETS
WHERE DELETED_FLAG = '0'
AND EFFECTIVITY_SET_ID = MRFL.EFFECTIVITY_SET_ID)) > SYSDATE) THEN 1 ELSE 0 END WHEN NVL(FND_PROFILE.VALUE_WNPS('CZEFFECTIVITYFILTER')
, 'ALL') = 'FUTUREANDCURRENT' THEN CASE WHEN DECODE(MRFL.EFFECTIVITY_SET_ID
, NULL
, MRFL.EFFECTIVE_UNTIL
, (SELECT EFFECTIVE_UNTIL
FROM CZ_EFFECTIVITY_SETS
WHERE DELETED_FLAG = '0'
AND EFFECTIVITY_SET_ID = MRFL.EFFECTIVITY_SET_ID)) > SYSDATE THEN 1 ELSE 0 END ELSE 1 END = 1