View: AMS_CUSTOM_SETUP_SCR_V

Product:	AMS - Marketing
Description:	This view returns all the custom setups details.
Implementation/DBA Data:	APPS.AMS_CUSTOM_SETUP_SCR_V

View Text

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(+)

Columns