VIEW Fnd_Tab_View_Columns IS LuName = 'FndObjSubscriptionUtil' Prompt = 'Fnd Tab View Columns' Lu_Name.Flags = 'A---L' Lu_Name.Datatype = 'STRING(30)' Lu_Name.Prompt = 'Lu Name' View_Name.Flags = 'A---L' View_Name.Datatype = 'STRING(30)' View_Name.Prompt = 'View Name' Column_Name.Flags = 'A---L' Column_Name.Datatype = 'STRING(30)' Column_Name.Prompt = 'Column Name' SELECT dv.lu_name, dv.view_name, dtc.column_name FROM dictionary_sys_view_column_tab dv, dictionary_sys_tab d, dba_tab_columns dtc WHERE dv.lu_name = d.lu_name AND (dv.column_name = dtc.column_name OR (dtc.column_name = 'ROWSTATE' AND dv.column_name = 'STATE') OR dtc.column_name ||'_DB' = dv.column_name) AND dtc.table_name = nvl(d.table_name, Dictionary_SYS.Clientnametodbname_(d.lu_name)||'_TAB') AND dtc.owner = Fnd_Session_API.Get_App_Owner $IF Component_Fndcob_SYS.INSTALLED $THEN UNION SELECT f.lu, Dictionary_SYS.Get_Base_View(f.lu), dtc.column_name FROM dba_tab_columns dtc, CUSTOM_FIELDS_TAB f WHERE f.table_name = dtc.table_name AND dtc.column_name LIKE 'CF$/_%' ESCAPE '/' AND dtc.owner = Fnd_Session_API.Get_App_Owner UNION SELECT v.lu, v.view_name, vc.column_name FROM dictionary_sys_view_column_tab vc, custom_field_views_tab v, custom_field_attributes_tab a WHERE vc.view_name = v.cf_view_name AND v.lu = vc.lu_name AND vc.column_name = 'CF$_' || a.attribute_name AND a.custom_field_type IN ('PERSISTENT_FIELD', 'LU_FIELD') $END;