VIEW: APPS.EGO_CRITERIA_TEMPLATES_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.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

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.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