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_MODELRULEFOLDER_IMAGES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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