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;