VIEW: APPS.AMS_DATASRC_ATTBINFO_VL

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'