Product: | EGO - Advanced Product Catalog |
---|---|
Description: | This stores all of the criteria asociated with the criteria templates |
Implementation/DBA Data: | APPS.EGO_CRITERIA_V |
SELECT AC.CUSTOMIZATION_APPLICATION_ID CUSTOMIZATION_APPLICATION_ID
, AC.CUSTOMIZATION_CODE CUSTOMIZATION_CODE
, AC.REGION_APPLICATION_ID REGION_APPLICATION_ID
, AC.REGION_CODE REGION_CODE
, AC.ATTRIBUTE_APPLICATION_ID ATTRIBUTE_APPLICATION_ID
, AC.ATTRIBUTE_CODE ATTRIBUTE_CODE
, AC.SEQUENCE_NUMBER SEQUENCE_NUMBER
, AC.OPERATION OPERATION
, AC.VALUE_VARCHAR2 VALUE_VARCHAR2
, AC2.VALUE_VARCHAR2 AS SECOND_VALUE_VARCHAR2
, AC.VALUE_NUMBER VALUE_NUMBER
, AC2.VALUE_NUMBER AS SECOND_VALUE_NUMBER
, AC.VALUE_DATE VALUE_DATE
, AC2.VALUE_DATE AS SECOND_VALUE_DATE
, AC.START_DATE_ACTIVE START_DATE_ACTIVE
, AC.END_DATE_ACTIVE END_DATE_ACTIVE
, ECE.USE_KEYWORD_SEARCH USE_KEYWORD_SEARCH
, ECE.MATCH_CONDITION MATCH_CONDITION
, ECE.FUZZY FUZZY
, ECE.STEMMING STEMMING
, ECE.SYNONYMS SYNONYMS
FROM AK_CRITERIA AC
, AK_CRITERIA AC2
, EGO_CRITERIA_EXT ECE
WHERE AC.CUSTOMIZATION_APPLICATION_ID = AC2.CUSTOMIZATION_APPLICATION_ID (+)
AND AC.CUSTOMIZATION_CODE = AC2.CUSTOMIZATION_CODE (+)
AND AC.REGION_APPLICATION_ID = AC2.REGION_APPLICATION_ID (+)
AND AC.REGION_CODE = AC2.REGION_CODE (+)
AND AC.ATTRIBUTE_APPLICATION_ID = AC2.ATTRIBUTE_APPLICATION_ID (+)
AND AC.ATTRIBUTE_CODE = AC2.ATTRIBUTE_CODE (+)
AND AC.SEQUENCE_NUMBER = (-1)*AC2.SEQUENCE_NUMBER (+)
AND AC.SEQUENCE_NUMBER > 0
AND AC.CUSTOMIZATION_APPLICATION_ID = ECE.CUSTOMIZATION_APPLICATION_ID (+)
AND AC.CUSTOMIZATION_CODE = ECE.CUSTOMIZATION_CODE (+)
AND AC.REGION_APPLICATION_ID = ECE.REGION_APPLICATION_ID (+)
AND AC.REGION_CODE = ECE.REGION_CODE (+)
AND AC.ATTRIBUTE_APPLICATION_ID = ECE.ATTRIBUTE_APPLICATION_ID (+)
AND AC.ATTRIBUTE_CODE = ECE.ATTRIBUTE_CODE (+)
AND AC.SEQUENCE_NUMBER = ECE.SEQUENCE_NUMBER (+)