View: AMS_DATASRC_ATTBINFO_VL

Product:	AMS - Marketing
Description:	This view is used to construct the data source Hgrid in the audience administration workbench.
Implementation/DBA Data:	APPS.AMS_DATASRC_ATTBINFO_VL

View Text

SELECT ASSOC.SUB_SOURCE_TYPE_ID ID
, TYPES1.LIST_SOURCE_NAME NAME
, 'DUMMY' SELECT_WHERE
, TYPES1.SOURCE_OBJECT_NAME FROM_CLAUSE
, TYPES1.SOURCE_TYPE_CODE ALIAS
, -1 SRC_FLD_ID
, ASSOC.MASTER_SOURCE_TYPE_ID MASTER_SRC_TYPE_ID
, 'Y' DISABLED
, TYPES1.SOURCE_OBJECT_NAME SOURCE_COLUMN_NAME
, TYPES1.SOURCE_TYPE_CODE SOURCE_COLUMN_MEANING
, 'DUMMY' FIELD_DATA_TYPE
, -1 ATTB_LOV_ID
, TYPES1.LIST_SOURCE_NAME DATA_SOURCE_NAME
FROM AMS_LIST_SRC_TYPES_VL TYPES1
, AMS_LIST_SRC_TYPE_ASSOCS ASSOC
WHERE TYPES1.LIST_SOURCE_TYPE IN ('ANALYTICS'
, 'TARGET')
AND TYPES1.LIST_SOURCE_TYPE_ID = ASSOC.SUB_SOURCE_TYPE_ID
AND TYPES1.ENABLED_FLAG = 'Y'
AND ASSOC.ENABLED_FLAG ='Y' UNION SELECT -1 ID
, FLD.SOURCE_COLUMN_MEANING NAME
, FLD.SOURCE_COLUMN_NAME SELECT_WHERE
, TYPES1.SOURCE_OBJECT_NAME FROM_CLAUSE
, TYPES1.SOURCE_TYPE_CODE ALIAS
, FLD.LIST_SOURCE_FIELD_ID SRC_FLD_ID
, TYPES1.LIST_SOURCE_TYPE_ID MASTER_SRC_TYPE_ID
, 'N' DISABLED
, SOURCE_COLUMN_NAME SOURCE_COLUMN_NAME
, SOURCE_COLUMN_MEANING SOURCE_COLUMN_MEANING
, FIELD_DATA_TYPE FIELD_DATA_TYPE
, FLD.ATTB_LOV_ID ATTB_LOV_ID
, TYPES1.LIST_SOURCE_NAME DATA_SOURCE_NAME
FROM AMS_LIST_SRC_TYPES_VL TYPES1
, AMS_LIST_SRC_FIELDS_VL FLD
WHERE TYPES1.LIST_SOURCE_TYPE IN ('ANALYTICS'
, 'TARGET')
AND FLD.LIST_SOURCE_TYPE_ID = TYPES1.LIST_SOURCE_TYPE_ID
AND FLD.FIELD_COLUMN_NAME IS NOT NULL
AND FLD.ENABLED_FLAG = 'Y'
AND TYPES1.ENABLED_FLAG = 'Y'

Columns