Product: | CZ - Configurator |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CZ_TEMPLATE_DEFS_V |
SELECT RUL.RULE_ID
, RUL.SIGNATURE_ID
, RUL.NAME
, RUL.TEMPLATE_TOKEN
, RUL.DESC_TEXT
, RUL.RULE_TEXT
, RUL.TEMPLATE_PRIMITIVE_FLAG
, RUL.INVALID_FLAG
, RUL.PRESENTATION_FLAG
, RUL.NOTES
, RUL.SEQ_NBR
, RUL.REASON_ID
, RUL.REASON_TYPE
, RUL.UNSATISFIED_MSG_ID
, RUL.UNSATISFIED_MSG_SOURCE
, RUL.DISABLED_FLAG
, RUL.RULE_TYPE
, RUL.RULE_FOLDER_ID
, RUL.DEVL_PROJECT_ID
, RUL.DELETED_FLAG
, RUL.SEEDED_FLAG
, PRJ.DEVL_PROJECT_ID AS P_MODEL_ID
FROM CZ_RULES RUL
, CZ_DEVL_PROJECTS PRJ
, CZ_LOOKUP_VALUES MODENGTYP
WHERE RUL.RULE_TYPE = 100
AND RUL.DELETED_FLAG = '0'
AND MODENGTYP.DELETED_FLAG = '0'
AND NVL(PRJ.CONFIG_ENGINE_TYPE
, 'L') = MODENGTYP.DATA_VALUE
AND MODENGTYP.LIST_NAME = 'CZ_ENGINE_TYPES'
AND RUL.CONFIG_ENGINE_TYPE IN (SELECT RULENGTYP.DATA_VALUE
FROM CZ_TYPE_RELATIONSHIPS RELS
, CZ_LOOKUP_VALUES RULENGTYP
WHERE RELS.DELETED_FLAG = '0'
AND RULENGTYP.DELETED_FLAG = '0'
AND RULENGTYP.LIST_NAME = 'CZ_ENGINE_TYPES'
AND RELS.SUBJECT_TYPE = MODENGTYP.NUMERIC_ID_VALUE
AND RELS.REL_TYPE_CODE = 'ETY'
AND RELS.OBJECT_TYPE = RULENGTYP.NUMERIC_ID_VALUE)