VIEW: APPS.EGO_CRITERIA_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)