Product: | EGO - Advanced Product Catalog |
---|---|
Description: | This view shows all of the criteria templates that have been defined |
Implementation/DBA Data: | APPS.EGO_CRITERIA_TEMPLATES_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.DEFAULT_CUSTOMIZATION_FLAG DEFAULT_CUSTOMIZATION_FLAG
, L1.MEANING DEFAULT_CUST_FLAG_MEANING
, AC.START_DATE_ACTIVE START_DATE_ACTIVE
, AC.END_DATE_ACTIVE END_DATE_ACTIVE
, ACL.NAME NAME
, ACL.DESCRIPTION DESCRIPTION
, EXT.CLASSIFICATION1 CLASSIFICATION1
, EXT.CLASSIFICATION2 CLASSIFICATION2
, EXT.CLASSIFICATION3 CLASSIFICATION3
, EXT.RF_CUSTOMIZATION_APPL_ID RF_CUSTOMIZATION_APPL_ID
, EXT.RF_CUSTOMIZATION_CODE RF_CUSTOMIZATION_CODE
, EXT.RF_REGION_APPLICATION_ID RF_REGION_APPLICATION_ID
, EXT.RF_REGION_CODE RF_REGION_CODE
, AC.CUSTOMIZATION_LEVEL_ID CUSTOMIZATION_LEVEL_ID
, AC.SITE_ID SITE_ID
, AC.WEB_USER_ID WEB_USER_ID
FROM AK_CUSTOMIZATIONS AC
, AK_CUSTOMIZATIONS_TL ACL
, EGO_CUSTOMIZATION_EXT EXT
, FND_LOOKUP_VALUES L1
WHERE AC.CUSTOMIZATION_APPLICATION_ID = EXT.CUSTOMIZATION_APPLICATION_ID
AND AC.CUSTOMIZATION_CODE = EXT.CUSTOMIZATION_CODE
AND AC.REGION_APPLICATION_ID = EXT.REGION_APPLICATION_ID
AND AC.REGION_CODE = EXT.REGION_CODE
AND AC.CUSTOMIZATION_APPLICATION_ID = ACL.CUSTOMIZATION_APPLICATION_ID
AND AC.CUSTOMIZATION_CODE = ACL.CUSTOMIZATION_CODE
AND AC.REGION_APPLICATION_ID = ACL.REGION_APPLICATION_ID
AND AC.REGION_CODE = ACL.REGION_CODE
AND L1.LOOKUP_TYPE = 'YES_NO'
AND L1.LOOKUP_CODE = AC.DEFAULT_CUSTOMIZATION_FLAG
AND L1.VIEW_APPLICATION_ID = 0
AND L1.LANGUAGE = USERENV('LANG')
AND ACL.LANGUAGE = USERENV('LANG')
AND ACL.CUSTOMIZATION_APPLICATION_ID = EXT.CUSTOMIZATION_APPLICATION_ID
AND ACL.CUSTOMIZATION_CODE = EXT.CUSTOMIZATION_CODE
AND ACL.REGION_APPLICATION_ID = EXT.REGION_APPLICATION_ID
AND ACL.REGION_CODE = EXT.REGION_CODE