1. Tables and Views for Common Features
  2. FND_BOSS_DEPLOY_CACHE_TL_V

FND_BOSS_DEPLOY_CACHE_TL_V

Details

  • Schema: BOSS

  • Object owner: FND

  • Object type: VIEW

Query

SQL_Statement

with

w_modules as

(

select t.namespace, t.deployment_id, t.module_name, t.path,

json_transform(json_query(t.content_json, '$.translations' returning clob), keep '$.*.path' returning varchar2) m_translations

from fnd_boss_deployment_cache t

where t.metadata_type = 'Module'

),

w_artifacts_tl as

(

select

t.namespace, t.deployment_id, t.module_name, t.path,

t.metadata_type, t.content_json.label a_label, t.content_json.description a_description,

fl.language_code language, fl.language_code source_lang, fl.bcp47_tag,

m.path m_path, m.m_translations

from fnd_boss_deployment_cache t,

fnd_languages fl,

w_modules m

where 1=1

and fl.installed_flag in ('B', 'I')

and t.namespace = m.namespace(+)

and t.deployment_id = m.deployment_id(+)

and t.module_name = m.module_name(+)

)

select t.namespace, t.deployment_id, t.module_name, t.path,

t.language, t.source_lang,

case

when ( (t.a_label is not null)

and (t.m_path is not null)

and (t.m_translations is not null)) then

fnd_boss_util.fbdc_get_tl_field(t.bcp47_tag, t.a_label,

t.namespace, t.deployment_id, t.module_name, t.m_path, t.m_translations)

else null

end label,

case

when ( (t.a_description is not null)

and (t.m_path is not null)

and (t.m_translations is not null)) then

fnd_boss_util.fbdc_get_tl_field(t.bcp47_tag, t.a_description,

t.namespace, t.deployment_id, t.module_name, t.m_path, t.m_translations)

else null

end description

from w_artifacts_tl t