CREATE OR REPLACE VIEW IFSAPP.LANGUAGE_TRANSLATION_EXP AS
SELECT C.module MODULE,
C.context_id CONTEXT_ID,
C.path PATH,
A.name NAME,
C.main_type MAIN_TYPE,
C.sub_type SUB_TYPE,
substrb(Language_Tr_Method_API.Decode(A.method),1,50) METHOD,
A.method METHOD_DB,
A.prog_text PROG_TEXT,
substrb(Language_Obsolete_API.Decode(A.obsolete),1,50) OBSOLETE,
A.obsolete OBSOLETE_DB,
A.attribute_id ATTRIBUTE_ID,
E.lang_code LANG_CODE,
Language_Translation_API.Get_Text( A.attribute_id, E.lang_code ) TEXT,
Language_Translation_API.Get_Diff_Text( A.attribute_id, E.lang_code ) DIFF_TEXT,
substrb(Language_Translation_API.Get_Status( A.attribute_id, E.lang_code ),1,50) STATUS,
substrb(Language_Translation_API.Get_Status_Db( A.attribute_id, E.lang_code ),1,1) STATUS_DB,
Language_Translation_API.Get_Last_Update( A.attribute_id, E.lang_code ) LAST_UPDATE,
substrb(Language_Translation_API.Get_Objid_( A.attribute_id, E.lang_code),1,200) OBJID,
Language_Translation_API.Get_Objversion_( A.attribute_id, E.lang_code) OBJVERSION
FROM language_attribute_tab A,
language_context_tab C,
language_code_tab E
WHERE C.context_id = A.context_id
AND A.obsolete = 'N'
AND E.status = 'A'
WITH read only
select * from language_attribute_tab
where context_id = 3874
AND obsolete = 'N'
-->attribute_id =3778
SELECT text
FROM LANGUAGE_TRANSLATION
WHERE attribute_id = 3778
AND lang_code = 'en';
status ='A' AUTO
'N' NOT TRANSLATED
'O' OK
<Context name="ORDERWBACKORDEROVWAUTHORIZECODE"><Attribute name="Text"><Text>Coordinator</Text></Attribute></Context><Context name="ORDERWBACKORDEROVWAUTHORIZECODES"><Attribute name="Text"><Text>Coordinator</Text></Attribute></Context><Context name="ORDERWBACKORDEROVWBACKORDER"><Attribute name="Text"><Text>Query - Backorders</Text></Attribute></Context><Context name="ORDERWBACKORDEROVWBUYQTYDUEQTYSHIPPED"><Attribute name="Text"><Text>Qty To Deliver</Text></Attribute></Context><Context name="ORDERWBACKORDEROVWCATALOGNO"><Attribute name="Text"><Text>Sales Part No</Text></Attribute></Context><Context name="ORDERWBACKORDEROVWCATALOGNOS"><Attribute name="Text"><Text>Sales Part No</Text></Attribute></Context><Context name="ORDERWBACKORDEROVWCONDITIOCODE"><Attribute name="Text"><Text>Condition Code</Text></Attribute></Context><Context name="ORDERWBACKORDEROVWCONDITIOCODEDESC"><Attribute name="Text"><Text>Condition Code Description</Text></Attribute></Context>
|