Product: | AK - Common Modules-AK |
---|---|
Description: | Stores criteria for customization. |
Implementation/DBA Data: | APPS.AK_CRITERIA_V |
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