VIEW: APPS.AMS_CUSTOM_SETUP_SCR_V

Source

View Text - Preformatted

SELECT a.creation_date, a.custom_setup_id, a.setup_name, a.description , a.object_type, a.activity_type_code , a.media_id, a.enabled_flag, b.MEANING , c.media_name, a.object_version_number, d.meaning, a.source_code_suffix, a.created_by, a.last_updated_by, a.last_update_date, a.last_update_login, a.application_id, a.allow_essential_grouping from AMS_CUSTOM_SETUPS_VL a, ams_lookups b, ams_media_vl c , AMS_LOOKUPS d WHERE b.LOOKUP_TYPE = 'AMS_SYS_ARC_QUALIFIER' AND a.OBJECT_TYPE = b.LOOKUP_CODE and a.media_id = c.media_id(+) and d.lookup_type (+) = 'AMS_MEDIA_TYPE' and a.activity_type_code = d.lookup_code(+)

View Text - HTML Formatted

SELECT A.CREATION_DATE
, A.CUSTOM_SETUP_ID
, A.SETUP_NAME
, A.DESCRIPTION
, A.OBJECT_TYPE
, A.ACTIVITY_TYPE_CODE
, A.MEDIA_ID
, A.ENABLED_FLAG
, B.MEANING
, C.MEDIA_NAME
, A.OBJECT_VERSION_NUMBER
, D.MEANING
, A.SOURCE_CODE_SUFFIX
, A.CREATED_BY
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, A.APPLICATION_ID
, A.ALLOW_ESSENTIAL_GROUPING
FROM AMS_CUSTOM_SETUPS_VL A
, AMS_LOOKUPS B
, AMS_MEDIA_VL C
, AMS_LOOKUPS D
WHERE B.LOOKUP_TYPE = 'AMS_SYS_ARC_QUALIFIER'
AND A.OBJECT_TYPE = B.LOOKUP_CODE
AND A.MEDIA_ID = C.MEDIA_ID(+)
AND D.LOOKUP_TYPE (+) = 'AMS_MEDIA_TYPE'
AND A.ACTIVITY_TYPE_CODE = D.LOOKUP_CODE(+)