Index: src-db/database/sourcedata/AD_TABLE.xml
===================================================================
--- src-db/database/sourcedata/AD_TABLE.xml	(revision 6681)
+++ src-db/database/sourcedata/AD_TABLE.xml	(working copy)
@@ -185,7 +185,7 @@
 <!--103 ISDEFAULTACCT-->
 <!--103-->              <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--103 SQL_RECORD_IDENTIFIER-->
-<!--103-->              <SQL_RECORD_IDENTIFIER><![CDATA[**No key found]]></SQL_RECORD_IDENTIFIER>
+<!--103-->              <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT (SELECT COALESCE(TO_CHAR(MAX(TTT.Name)), TO_CHAR(TT.Name)) FROM AD_Reference_Trl TTT WHERE TTT.AD_Reference_ID=TT.AD_Reference_ID AND TTT.AD_LANGUAGE=L.AD_LANGUAGE) ||' - '||(SELECT NAME FROM AD_REF_LIST_V WHERE AD_Language=L.AD_LANGUAGE AND Value=TT.ValidationType AND AD_Reference_ID=2) FROM AD_Reference TT WHERE TT.AD_Reference_ID=T.AD_Reference_ID)  AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, AD_Ref_Table T WHERE AD_Reference_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>
 <!--103 DEVELOPMENTSTATUS-->
 <!--103-->              <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--103**************--></AD_TABLE>
@@ -894,7 +894,7 @@
 <!--119 ISDEFAULTACCT-->
 <!--119-->              <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--119 SQL_RECORD_IDENTIFIER-->
-<!--119-->              <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Value),'')) FROM AD_Message TT WHERE TT.AD_Message_ID=T.AD_Message_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM AD_Language TT WHERE TT.AD_Language=T.AD_Language)  AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, AD_Message_Trl T WHERE AD_Message_Trl_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>
+<!--119-->              <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>
 <!--119 DEVELOPMENTSTATUS-->
 <!--119-->              <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--119**************--></AD_TABLE>
@@ -1270,7 +1270,7 @@
 <!--131 ISDEFAULTACCT-->
 <!--131-->              <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--131 SQL_RECORD_IDENTIFIER-->
-<!--131-->              <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM AD_WF_Node TT WHERE TT.AD_WF_Node_ID=T.AD_WF_Next_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM AD_WF_Node TT WHERE TT.AD_WF_Node_ID=T.AD_WF_Node_ID)  AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, AD_WF_NodeNext T WHERE AD_WF_NodeNext_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>
+<!--131-->              <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>
 <!--131 DEVELOPMENTSTATUS-->
 <!--131-->              <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--131**************--></AD_TABLE>
@@ -3399,7 +3399,7 @@
 <!--227 ISDEFAULTACCT-->
 <!--227-->              <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--227 SQL_RECORD_IDENTIFIER-->
-<!--227-->              <SQL_RECORD_IDENTIFIER><![CDATA[**No key found]]></SQL_RECORD_IDENTIFIER>
+<!--227-->              <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM AD_Client TT WHERE TT.AD_Client_ID=T.AD_Client_ID)  AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, AD_ClientInfo T WHERE AD_Client_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>
 <!--227 DEVELOPMENTSTATUS-->
 <!--227-->              <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--227**************--></AD_TABLE>
@@ -3446,7 +3446,7 @@
 <!--228 ISDEFAULTACCT-->
 <!--228-->              <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--228 SQL_RECORD_IDENTIFIER-->
-<!--228-->              <SQL_RECORD_IDENTIFIER><![CDATA[**No key found]]></SQL_RECORD_IDENTIFIER>
+<!--228-->              <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM AD_Org TT WHERE TT.AD_Org_ID=T.AD_Org_ID)  AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, AD_OrgInfo T WHERE AD_Org_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>
 <!--228 DEVELOPMENTSTATUS-->
 <!--228-->              <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--228**************--></AD_TABLE>
@@ -7404,7 +7404,7 @@
 <!--389 ISDEFAULTACCT-->
 <!--389-->              <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--389 SQL_RECORD_IDENTIFIER-->
-<!--389-->              <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT (SELECT COALESCE(TO_CHAR(MAX(TTT.MsgText)), TO_CHAR(TT.MsgText)) FROM AD_Message_Trl TTT WHERE TTT.AD_Message_ID=TT.AD_Message_ID AND TTT.AD_LANGUAGE=L.AD_LANGUAGE)  FROM AD_Message TT WHERE TT.AD_Message_ID=T.AD_Message_ID) ||' - '||TO_CHAR(COALESCE(TO_CHAR(T.Reference),'')) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, AD_Note T WHERE AD_Note_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>
+<!--389-->              <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>
 <!--389 DEVELOPMENTSTATUS-->
 <!--389-->              <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--389**************--></AD_TABLE>
@@ -7733,7 +7733,7 @@
 <!--397 ISDEFAULTACCT-->
 <!--397-->              <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--397 SQL_RECORD_IDENTIFIER-->
-<!--397-->              <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT VALUE || ' - ' || TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM AD_Org TT WHERE TT.AD_Org_ID=T.AD_OrgTo_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_AcctSchema TT WHERE TT.C_AcctSchema_ID=T.C_AcctSchema_ID)  AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, C_InterOrg_Acct T WHERE C_InterOrg_Acct_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>
+<!--397-->              <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>
 <!--397 DEVELOPMENTSTATUS-->
 <!--397-->              <DEVELOPMENTSTATUS><![CDATA[NI]]></DEVELOPMENTSTATUS>
 <!--397**************--></AD_TABLE>
@@ -9669,7 +9669,7 @@
 <!--486 ISDEFAULTACCT-->
 <!--486-->              <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--486 SQL_RECORD_IDENTIFIER-->
-<!--486-->              <SQL_RECORD_IDENTIFIER><![CDATA[SELECT TO_CHAR(COALESCE(TO_CHAR(T.DocumentNo),''))||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_BPartner TT WHERE TT.C_BPartner_ID=T.C_BPartner_ID) ||' - '||TO_CHAR(COALESCE(TO_CHAR(T.DateReport),'')) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, S_TimeExpense T WHERE S_TimeExpense_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>
+<!--486-->              <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>
 <!--486 DEVELOPMENTSTATUS-->
 <!--486-->              <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--486**************--></AD_TABLE>
@@ -10099,7 +10099,7 @@
 <!--528 ISDEFAULTACCT-->
 <!--528-->              <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--528 SQL_RECORD_IDENTIFIER-->
-<!--528-->              <SQL_RECORD_IDENTIFIER><![CDATA[**No key found]]></SQL_RECORD_IDENTIFIER>
+<!--528-->              <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM AD_User TT WHERE TT.AD_User_ID=T.AD_User_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM R_InterestArea TT WHERE TT.R_InterestArea_ID=T.R_InterestArea_ID)  AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, R_ContactInterest T WHERE R_ContactInterest_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>
 <!--528 DEVELOPMENTSTATUS-->
 <!--528-->              <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--528**************--></AD_TABLE>
@@ -11622,7 +11622,7 @@
 <!--582 ISDEFAULTACCT-->
 <!--582-->              <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--582 SQL_RECORD_IDENTIFIER-->
-<!--582-->              <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM S_Resource TT WHERE TT.S_Resource_ID=T.S_Resource_ID) ||' - '||--No key found AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, R_ResourcePlanCost T WHERE R_ResourcePlanCost_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>
+<!--582-->              <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM S_Resource TT WHERE TT.S_Resource_ID=T.S_Resource_ID) ||' - '||TO_CHAR(COALESCE(TO_CHAR(T.C_CostType_ID),'')) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, R_ResourcePlanCost T WHERE R_ResourcePlanCost_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>
 <!--582 DEVELOPMENTSTATUS-->
 <!--582-->              <DEVELOPMENTSTATUS><![CDATA[NI]]></DEVELOPMENTSTATUS>
 <!--582**************--></AD_TABLE>
@@ -13072,7 +13072,7 @@
 <!--800015 ISDEFAULTACCT-->
 <!--800015-->              <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--800015 SQL_RECORD_IDENTIFIER-->
-<!--800015-->              <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Value),''))||' - '||(SELECT COALESCE(TO_CHAR(MAX(TTT.Name)), TO_CHAR(TT.Name)) FROM C_ElementValue_Trl TTT WHERE TTT.C_ElementValue_ID=TT.C_ElementValue_ID AND TTT.AD_LANGUAGE=L.AD_LANGUAGE)  FROM C_ElementValue TT WHERE TT.C_ElementValue_ID=T.C_ElementValue_ID) ||' - '||(SELECT VALUE || ' - ' || (SELECT COALESCE(TO_CHAR(MAX(TTT.Name)), TO_CHAR(TT.Name)) FROM C_ElementValue_Trl TTT WHERE TTT.C_ElementValue_ID=TT.C_ElementValue_ID AND TTT.AD_LANGUAGE=L.AD_LANGUAGE)  FROM C_ElementValue TT WHERE TT.C_ElementValue_ID=T.Account_ID)  AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, C_ElementValue_Operand T WHERE C_Elementvalue_Operand_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>
+<!--800015-->              <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>
 <!--800015 DEVELOPMENTSTATUS-->
 <!--800015-->              <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--800015**************--></AD_TABLE>
@@ -13502,7 +13502,7 @@
 <!--800027 ISDEFAULTACCT-->
 <!--800027-->              <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--800027 SQL_RECORD_IDENTIFIER-->
-<!--800027-->              <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_AcctSchema TT WHERE TT.C_AcctSchema_ID=T.C_AcctSchema_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM AD_Table TT WHERE TT.AD_Table_ID=T.AD_Table_ID)  AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, C_AcctSchema_Table T WHERE C_Acctschema_Table_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>
+<!--800027-->              <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>
 <!--800027 DEVELOPMENTSTATUS-->
 <!--800027-->              <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--800027**************--></AD_TABLE>
@@ -17986,7 +17986,7 @@
 <!--800174 ISDEFAULTACCT-->
 <!--800174-->              <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--800174 SQL_RECORD_IDENTIFIER-->
-<!--800174-->              <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_Period TT WHERE TT.C_Period_ID=T.C_Period_ID) ||' - '||TO_CHAR(COALESCE(TO_CHAR(T.SeqNo),''))||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_Budget TT WHERE TT.C_Budget_ID=T.C_Budget_ID)  AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, C_BudgetLine T WHERE C_Budgetline_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>
+<!--800174-->              <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>
 <!--800174 DEVELOPMENTSTATUS-->
 <!--800174-->              <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--800174**************--></AD_TABLE>
@@ -19976,7 +19976,7 @@
 <!--800220 ISDEFAULTACCT-->
 <!--800220-->              <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--800220 SQL_RECORD_IDENTIFIER-->
-<!--800220-->              <SQL_RECORD_IDENTIFIER><![CDATA[SELECT TO_CHAR(COALESCE(TO_CHAR(T.Name),''))||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM MRP_Planner TT WHERE TT.MRP_Planner_ID=T.MRP_Planner_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_BPartner TT WHERE TT.C_BPartner_ID=T.Vendor_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM M_Product_Category TT WHERE TT.M_Product_Category_ID=T.M_Product_Category_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM M_Product TT WHERE TT.M_Product_ID=T.M_Product_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_BPartner TT WHERE TT.C_BPartner_ID=T.C_BPartner_ID)  AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, MRP_Run_Purchase T WHERE MRP_Run_Purchase_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>
+<!--800220-->              <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>
 <!--800220 DEVELOPMENTSTATUS-->
 <!--800220-->              <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--800220**************--></AD_TABLE>
@@ -20023,7 +20023,7 @@
 <!--800221 ISDEFAULTACCT-->
 <!--800221-->              <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--800221 SQL_RECORD_IDENTIFIER-->
-<!--800221-->              <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),''))||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TTT.Name),'')) FROM MRP_Planner TTT WHERE TTT.MRP_Planner_ID=TT.MRP_Planner_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TTT.Name),'')) FROM C_BPartner TTT WHERE TTT.C_BPartner_ID=TT.Vendor_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TTT.Name),'')) FROM M_Product_Category TTT WHERE TTT.M_Product_Category_ID=TT.M_Product_Category_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TTT.Name),'')) FROM M_Product TTT WHERE TTT.M_Product_ID=TT.M_Product_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TTT.Name),'')) FROM C_BPartner TTT WHERE TTT.C_BPartner_ID=TT.C_BPartner_ID)  FROM MRP_Run_Purchase TT WHERE TT.MRP_Run_Purchase_ID=T.MRP_Run_Purchase_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM M_Product TT WHERE TT.M_Product_ID=T.M_Product_ID) ||' - '||(SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TTT.DocumentNo),'')) FROM M_Requisition TTT WHERE TTT.M_Requisition_ID=TT.M_Requisition_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TTT.Name),'')) FROM M_Product TTT WHERE TTT.M_Product_ID=TT.M_Product_ID) ||' - '||TO_CHAR(COALESCE(TO_CHAR(TT.Qty),''))||' - '||TO_CHAR(COALESCE(TO_CHAR(TT.Needbydate),'')) FROM M_Requisitionline TT WHERE TT.M_Requisitionline_ID=T.M_Requisitionline_ID)  AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, MRP_Run_PurchaseLine T WHERE MRP_Run_Purchaseline_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>
+<!--800221-->              <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>
 <!--800221 DEVELOPMENTSTATUS-->
 <!--800221-->              <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--800221**************--></AD_TABLE>