MSC_DPR_ATTR_LIST

Details

Name
ATTRIBUTE_ID ATTRIBUTE_NAME VALUE_SET_ID DISPLAY_TYPE

Name

ATTRIBUTE_ID

ATTRIBUTE_NAME

VALUE_SET_ID

DISPLAY_TYPE

SQL_Statement
SELECT DISTINCT lookup_code attribute_id, meaning attribute_name, NULL, NULL FROM fnd_lookup_values WHERE view_application_id = 0 AND language = userenv('LANG') AND lookup_type = 'ORA_MSC_BM_DEMAND_PRIORITY_ATT' union all SELECT ds.column_name attribute_id, ds.name attribute_name, ds.value_set_id, ds.display_type FROM fnd_df_segments_vl ds, fnd_vs_value_sets vs WHERE ds.application_id = 724 AND ds.descriptive_flexfield_code = 'MSC_DEMANDS' AND ds.context_code = 'Global Data Elements' AND ds.enabled_flag = 'Y' AND ds.value_set_id = vs.value_set_id UNION ALL SELECT sup_dem_col_mapped attribute_id, attribute_name, NULL, NULL FROM msc_attributes_vl WHERE sup_dem_col_mapped NOT IN ( 'GLOBAL_ATTRIBUTE_NUMBER26', 'GLOBAL_ATTRIBUTE_NUMBER11', 'GLOBAL_ATTRIBUTE_NUMBER12')

SQL_Statement

SELECT DISTINCT

lookup_code attribute_id,

meaning attribute_name,

NULL,

NULL

FROM

fnd_lookup_values

WHERE

view_application_id = 0

AND language = userenv('LANG')

AND lookup_type = 'ORA_MSC_BM_DEMAND_PRIORITY_ATT'

union all

SELECT

ds.column_name attribute_id,

ds.name attribute_name,

ds.value_set_id,

ds.display_type

FROM

fnd_df_segments_vl ds,

fnd_vs_value_sets vs

WHERE

ds.application_id = 724

AND ds.descriptive_flexfield_code = 'MSC_DEMANDS'

AND ds.context_code = 'Global Data Elements'

AND ds.enabled_flag = 'Y'

AND ds.value_set_id = vs.value_set_id

UNION ALL

SELECT

sup_dem_col_mapped attribute_id,

attribute_name,

NULL,

NULL

FROM

msc_attributes_vl

WHERE

sup_dem_col_mapped NOT IN ( 'GLOBAL_ATTRIBUTE_NUMBER26', 'GLOBAL_ATTRIBUTE_NUMBER11', 'GLOBAL_ATTRIBUTE_NUMBER12')