VIEW: APPS.AK_CRITERIA_V

Source

View Text - Preformatted

SELECT AC.CUSTOMIZATION_APPLICATION_ID , AC.CUSTOMIZATION_CODE , AC.REGION_APPLICATION_ID , AC.REGION_CODE , ACUS.CUSTOMIZATION_LEVEL_ID , AC.ATTRIBUTE_APPLICATION_ID , AC.ATTRIBUTE_CODE , ARI.ITEM_NAME , ARI.VIEW_USAGE_NAME , ARI.VIEW_ATTRIBUTE_NAME , AC.SEQUENCE_NUMBER , AC.OPERATION , AC.VALUE_VARCHAR2 , AC.VALUE_NUMBER , AC.VALUE_DATE , ACR.CRITERIA_JOIN_CONDITION , AC.CREATED_BY , AC.CREATION_DATE , AC.LAST_UPDATED_BY , AC.LAST_UPDATE_DATE , AC.LAST_UPDATE_LOGIN , AC.START_DATE_ACTIVE , AC.END_DATE_ACTIVE from AK_CRITERIA AC , AK_CUSTOMIZATIONS ACUS , AK_REGION_ITEMS ARI , AK_CUSTOM_REGIONS ACR where AC.CUSTOMIZATION_CODE = ACUS.CUSTOMIZATION_CODE and AC.CUSTOMIZATION_APPLICATION_ID = ACUS.CUSTOMIZATION_APPLICATION_ID and AC.REGION_CODE = ACUS.REGION_CODE and AC.REGION_APPLICATION_ID = ACUS.REGION_APPLICATION_ID and AC.CUSTOMIZATION_CODE = ACR.CUSTOMIZATION_CODE and AC.CUSTOMIZATION_APPLICATION_ID = ACR.CUSTOMIZATION_APPLICATION_ID and AC.REGION_CODE = ACR.REGION_CODE and AC.REGION_APPLICATION_ID = ACR.REGION_APPLICATION_ID and AC.ATTRIBUTE_CODE = ARI.ATTRIBUTE_CODE and AC.ATTRIBUTE_APPLICATION_ID = ARI.ATTRIBUTE_APPLICATION_ID and AC.REGION_CODE = ARI.REGION_CODE and AC.REGION_APPLICATION_ID = ARI.REGION_APPLICATION_ID

View Text - HTML Formatted

SELECT AC.CUSTOMIZATION_APPLICATION_ID
, AC.CUSTOMIZATION_CODE
, AC.REGION_APPLICATION_ID
, AC.REGION_CODE
, ACUS.CUSTOMIZATION_LEVEL_ID
, AC.ATTRIBUTE_APPLICATION_ID
, AC.ATTRIBUTE_CODE
, ARI.ITEM_NAME
, ARI.VIEW_USAGE_NAME
, ARI.VIEW_ATTRIBUTE_NAME
, AC.SEQUENCE_NUMBER
, AC.OPERATION
, AC.VALUE_VARCHAR2
, AC.VALUE_NUMBER
, AC.VALUE_DATE
, ACR.CRITERIA_JOIN_CONDITION
, AC.CREATED_BY
, AC.CREATION_DATE
, AC.LAST_UPDATED_BY
, AC.LAST_UPDATE_DATE
, AC.LAST_UPDATE_LOGIN
, AC.START_DATE_ACTIVE
, AC.END_DATE_ACTIVE
FROM AK_CRITERIA AC
, AK_CUSTOMIZATIONS ACUS
, AK_REGION_ITEMS ARI
, AK_CUSTOM_REGIONS ACR
WHERE AC.CUSTOMIZATION_CODE = ACUS.CUSTOMIZATION_CODE
AND AC.CUSTOMIZATION_APPLICATION_ID = ACUS.CUSTOMIZATION_APPLICATION_ID
AND AC.REGION_CODE = ACUS.REGION_CODE
AND AC.REGION_APPLICATION_ID = ACUS.REGION_APPLICATION_ID
AND AC.CUSTOMIZATION_CODE = ACR.CUSTOMIZATION_CODE
AND AC.CUSTOMIZATION_APPLICATION_ID = ACR.CUSTOMIZATION_APPLICATION_ID
AND AC.REGION_CODE = ACR.REGION_CODE
AND AC.REGION_APPLICATION_ID = ACR.REGION_APPLICATION_ID
AND AC.ATTRIBUTE_CODE = ARI.ATTRIBUTE_CODE
AND AC.ATTRIBUTE_APPLICATION_ID = ARI.ATTRIBUTE_APPLICATION_ID
AND AC.REGION_CODE = ARI.REGION_CODE
AND AC.REGION_APPLICATION_ID = ARI.REGION_APPLICATION_ID