details: /erp/devel/pi/rev/068edc851241
changeset: 7023:068edc851241
user: Salvador Zapata <salvador.zapata <at> openbravo.com>
date: Tue Apr 13 19:58:44 2010 +0200
summary: fixed issue: 12498
details: /erp/devel/pi/rev/f549fe3f7592
changeset: 7024:f549fe3f7592
user: Salvador Zapata <salvador.zapata <at> openbravo.com>
date: Tue Apr 13 20:00:34 2010 +0200
summary: Merge for issue 12498
diffstat:
src-db/database/lib/dbsourcemanager.jar | 0
src-db/database/model/views/AD_AUDIT_TRAIL_V.xml | 27 +-
src-db/database/model/views/AD_FIELD_V.xml | 17 +-
src-db/database/model/views/AD_FIELD_VT.xml | 19 +-
src-db/database/model/views/AD_PROCESS_EXECUTION_V.xml | 5 +-
src-db/database/model/views/AD_REF_LIST_V.xml | 17 +-
src-db/database/model/views/AD_TABLE_POST_V.xml | 43 ++--
src-db/database/model/views/AD_TAB_V.xml | 7 +-
src-db/database/model/views/AD_TAB_VT.xml | 9 +-
src-db/database/model/views/AD_USER_ROLES_V.xml | 7 +-
src-db/database/model/views/AD_WINDOW_VT.xml | 7 +-
src-db/database/model/views/A_ASSET_AMORTIZATION.xml | 5 +-
src-db/database/model/views/C_BPARTNER_V.xml | 9 +-
src-db/database/model/views/C_CASH_DETAIL.xml | 5 +-
src-db/database/model/views/C_DEBT_PAYMENT_CANCEL.xml | 5 +-
src-db/database/model/views/C_DEBT_PAYMENT_GENERATE.xml | 5 +-
src-db/database/model/views/C_DEBT_PAYMENT_V.xml | 41 ++-
src-db/database/model/views/C_INVOICELINE_V.xml | 21 +-
src-db/database/model/views/C_INVOICELINE_V2.xml | 37 +-
src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml | 31 +-
src-db/database/model/views/C_INVOICE_CUSTOMERPRODQTR.xml | 21 +-
src-db/database/model/views/C_INVOICE_CUSTOMERVENDQTR.xml | 23 +-
src-db/database/model/views/C_INVOICE_DAY.xml | 21 +-
src-db/database/model/views/C_INVOICE_HEADER_V.xml | 23 +-
src-db/database/model/views/C_INVOICE_HEADER_VT.xml | 23 +-
src-db/database/model/views/C_INVOICE_LINETAX_V.xml | 97 ++++----
src-db/database/model/views/C_INVOICE_LINETAX_VT.xml | 105 +++++----
src-db/database/model/views/C_INVOICE_MONTH.xml | 21 +-
src-db/database/model/views/C_INVOICE_PRODMONTH.xml | 21 +-
src-db/database/model/views/C_INVOICE_PRODWEEK.xml | 21 +-
src-db/database/model/views/C_INVOICE_V.xml | 45 ++--
src-db/database/model/views/C_INVOICE_V2.xml | 37 +-
src-db/database/model/views/C_INVOICE_VENDORMONTH.xml | 23 +-
src-db/database/model/views/C_INVOICE_WEEK.xml | 21 +-
src-db/database/model/views/C_ORDER_HEADER_V.xml | 23 +-
src-db/database/model/views/C_ORDER_HEADER_VT.xml | 23 +-
src-db/database/model/views/C_ORDER_LINETAX_V.xml | 59 ++--
src-db/database/model/views/C_ORDER_LINETAX_VT.xml | 67 +++---
src-db/database/model/views/C_ORDER_OPEN.xml | 5 +-
src-db/database/model/views/C_PERIODCONTROL_V.xml | 5 +-
src-db/database/model/views/C_PROJECTPROPOSAL_V.xml | 5 +-
src-db/database/model/views/C_PROJECT_DETAILS_V.xml | 17 +-
src-db/database/model/views/C_PROJECT_DETAILS_VT.xml | 17 +-
src-db/database/model/views/C_PROJECT_HEADER_V.xml | 25 +-
src-db/database/model/views/C_PROJECT_HEADER_VT.xml | 25 +-
src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml | 13 +-
src-db/database/model/views/FIN_PAYMENT_PROP_DETAIL_V.xml | 17 +-
src-db/database/model/views/FIN_PAYMENT_SCHED_INV_V.xml | 17 +-
src-db/database/model/views/FIN_PAYMENT_SCHED_ORD_V.xml | 17 +-
src-db/database/model/views/FIN_RECONCILIATIONLINE_V.xml | 5 +-
src-db/database/model/views/GL_JOURNALLINE_ACCT_V.xml | 5 +-
src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml | 37 +-
src-db/database/model/views/MA_SEQUENCE_EMPLOYEE_COST.xml | 27 +-
src-db/database/model/views/MA_SEQUENCE_INDIRECT_COST_COST.xml | 27 +-
src-db/database/model/views/MA_SEQUENCE_MACHINE_COST.xml | 27 +-
src-db/database/model/views/M_INOUT_CANDIDATE_V.xml | 13 +-
src-db/database/model/views/M_INOUT_HEADER_V.xml | 19 +-
src-db/database/model/views/M_INOUT_HEADER_VT.xml | 19 +-
src-db/database/model/views/M_INOUT_LINE_V.xml | 27 +-
src-db/database/model/views/M_INOUT_LINE_VT.xml | 31 +-
src-db/database/model/views/M_TRANSACTION_SUM.xml | 7 +-
src-db/database/model/views/M_TRANSACTION_V.xml | 5 +-
src-db/database/model/views/R_REQUEST_V.xml | 5 +-
src-db/database/model/views/S_TIMEEXPENSELINE_V.xml | 7 +-
src-db/database/sourcedata/AD_COLUMN.xml | 4 +-
65 files changed, 741 insertions(+), 678 deletions(-)
diffs (truncated from 1951 to 300 lines):
diff -r e3451d9eeb7a -r f549fe3f7592 src-db/database/lib/dbsourcemanager.jar
Binary file src-db/database/lib/dbsourcemanager.jar has changed
diff -r e3451d9eeb7a -r f549fe3f7592
src-db/database/model/views/AD_AUDIT_TRAIL_V.xml
--- a/src-db/database/model/views/AD_AUDIT_TRAIL_V.xml Tue Apr 13 15:39:28
2010 +0200
+++ b/src-db/database/model/views/AD_AUDIT_TRAIL_V.xml Tue Apr 13 20:00:34
2010 +0200
@@ -1,17 +1,18 @@
<?xml version="1.0"?>
<database name="VIEW AD_AUDIT_TRAIL_V">
<view name="AD_AUDIT_TRAIL_V"><![CDATA[SELECT at.ad_audit_trail_id,
at.ad_client_id, at.ad_org_id, at.isactive, at.created, at.createdby,
at.updated, at.updatedby, at.ad_table_id, at.record_id, at.record_revision,
at.ad_user_id, at.event_time, at.processtype, at.process_id, at.action,
at.ad_column_id, at.old_char, at.new_char, at.old_nchar, at.new_nchar,
at.old_number, at.new_number, at.old_date, at.new_date,
- CASE
- WHEN at.processtype = 'P' THEN ( SELECT to_char(p.name) AS to_char
- FROM ad_process p
- WHERE p.ad_process_id = at.process_id)
- WHEN at.processtype = 'W' THEN ( SELECT to_char(w.name) AS to_char
- FROM ad_tab t, ad_window w
- WHERE t.ad_tab_id = at.process_id AND t.ad_window_id =
w.ad_window_id)
- WHEN at.processtype = 'X' THEN ( SELECT to_char(f.name) AS to_char
- FROM ad_form f
- WHERE f.ad_form_id = at.process_id)
- ELSE ''
- END AS process_desc, COALESCE(at.old_char, to_char(at.old_nchar),
to_char(at.old_date), to_char(at.old_number)) AS old_value,
COALESCE(at.new_char, to_char(at.new_nchar), to_char(at.new_date),
to_char(at.new_number)) AS new_value
- FROM ad_audit_trail at]]></view>
+CASE
+WHEN at.processtype = 'P' THEN (SELECT to_char(p.name) AS to_char
+FROM ad_process p
+WHERE p.ad_process_id = at.process_id)
+WHEN at.processtype = 'W' THEN (SELECT to_char(w.name) AS to_char
+FROM ad_tab t, ad_window w
+WHERE t.ad_tab_id = at.process_id AND t.ad_window_id = w.ad_window_id)
+WHEN at.processtype = 'X' THEN (SELECT to_char(f.name) AS to_char
+FROM ad_form f
+WHERE f.ad_form_id = at.process_id)
+ELSE ''
+END AS process_desc, COALESCE(at.old_char, to_char(at.old_nchar),
to_char(at.old_date), to_char(at.old_number)) AS old_value,
COALESCE(at.new_char, to_char(at.new_nchar), to_char(at.new_date),
to_char(at.new_number)) AS new_value
+FROM ad_audit_trail at
+]]></view>
</database>
diff -r e3451d9eeb7a -r f549fe3f7592 src-db/database/model/views/AD_FIELD_V.xml
--- a/src-db/database/model/views/AD_FIELD_V.xml Tue Apr 13 15:39:28
2010 +0200
+++ b/src-db/database/model/views/AD_FIELD_V.xml Tue Apr 13 20:00:34
2010 +0200
@@ -1,12 +1,13 @@
<?xml version="1.0"?>
<database name="VIEW AD_FIELD_V">
<view name="AD_FIELD_V"><![CDATA[SELECT t.ad_window_id, f.ad_tab_id,
f.ad_field_id, tbl.ad_table_id, f.ad_column_id, f.name, f.description, f.help,
f.isdisplayed, f.displaylogic, f.displaylength, f.seqno, f.sortno,
f.issameline, f.isfieldonly, f.isreadonly, f.isencrypted AS isencryptedfield,
c.columnname, c.fieldlength, c.vformat, c.defaultvalue, c.iskey, c.isparent,
c.ismandatory, c.isidentifier, c.istranslated, c.ad_reference_value_id,
c.callout, c.ad_reference_id, c.ad_val_rule_id, c.ad_process_id,
c.readonlylogic, c.isupdateable, c.isencrypted AS isencryptedcolumn,
c.isselectioncolumn, tbl.tablename, c.valuemin, c.valuemax, fg.name AS
fieldgroup, vr.code AS validationcode
- FROM ad_field f
- JOIN ad_tab t ON f.ad_tab_id = t.ad_tab_id
- LEFT JOIN ad_fieldgroup fg ON f.ad_fieldgroup_id = fg.ad_fieldgroup_id
- LEFT JOIN ad_column c ON f.ad_column_id = c.ad_column_id
- JOIN ad_table tbl ON c.ad_table_id = tbl.ad_table_id
- JOIN ad_reference r ON c.ad_reference_id = r.ad_reference_id
- LEFT JOIN ad_val_rule vr ON c.ad_val_rule_id = vr.ad_val_rule_id
- WHERE f.isactive = 'Y' AND c.isactive = 'Y']]></view>
+FROM ad_field f
+JOIN ad_tab t ON f.ad_tab_id = t.ad_tab_id
+LEFT JOIN ad_fieldgroup fg ON f.ad_fieldgroup_id = fg.ad_fieldgroup_id
+LEFT JOIN ad_column c ON f.ad_column_id = c.ad_column_id
+JOIN ad_table tbl ON c.ad_table_id = tbl.ad_table_id
+JOIN ad_reference r ON c.ad_reference_id = r.ad_reference_id
+LEFT JOIN ad_val_rule vr ON c.ad_val_rule_id = vr.ad_val_rule_id
+WHERE f.isactive = 'Y' AND c.isactive = 'Y'
+]]></view>
</database>
diff -r e3451d9eeb7a -r f549fe3f7592 src-db/database/model/views/AD_FIELD_VT.xml
--- a/src-db/database/model/views/AD_FIELD_VT.xml Tue Apr 13 15:39:28
2010 +0200
+++ b/src-db/database/model/views/AD_FIELD_VT.xml Tue Apr 13 20:00:34
2010 +0200
@@ -1,13 +1,14 @@
<?xml version="1.0"?>
<database name="VIEW AD_FIELD_VT">
<view name="AD_FIELD_VT"><![CDATA[SELECT trl.ad_language, t.ad_window_id,
f.ad_tab_id, f.ad_field_id, tbl.ad_table_id, f.ad_column_id, trl.name,
trl.description, trl.help, f.isdisplayed, f.displaylogic, f.displaylength,
f.seqno, f.sortno, f.issameline, f.isfieldonly, f.isreadonly, f.isencrypted AS
isencryptedfield, c.columnname, c.fieldlength, c.vformat, c.defaultvalue,
c.iskey, c.isparent, c.ismandatory, c.isidentifier, c.istranslated,
c.ad_reference_value_id, c.callout, c.ad_reference_id, c.ad_val_rule_id,
c.ad_process_id, c.readonlylogic, c.isupdateable, c.isencrypted AS
isencryptedcolumn, c.isselectioncolumn, tbl.tablename, c.valuemin, c.valuemax,
fgt.name AS fieldgroup, vr.code AS validationcode
- FROM ad_field f
- JOIN ad_field_trl trl ON f.ad_field_id = trl.ad_field_id
- JOIN ad_tab t ON f.ad_tab_id = t.ad_tab_id
- LEFT JOIN ad_fieldgroup_trl fgt ON f.ad_fieldgroup_id =
fgt.ad_fieldgroup_id AND trl.ad_language = fgt.ad_language
- LEFT JOIN ad_column c ON f.ad_column_id = c.ad_column_id
- JOIN ad_table tbl ON c.ad_table_id = tbl.ad_table_id
- JOIN ad_reference r ON c.ad_reference_id = r.ad_reference_id
- LEFT JOIN ad_val_rule vr ON c.ad_val_rule_id = vr.ad_val_rule_id
- WHERE f.isactive = 'Y' AND c.isactive = 'Y']]></view>
+FROM ad_field f
+JOIN ad_field_trl trl ON f.ad_field_id = trl.ad_field_id
+JOIN ad_tab t ON f.ad_tab_id = t.ad_tab_id
+LEFT JOIN ad_fieldgroup_trl fgt ON f.ad_fieldgroup_id = fgt.ad_fieldgroup_id
AND trl.ad_language = fgt.ad_language
+LEFT JOIN ad_column c ON f.ad_column_id = c.ad_column_id
+JOIN ad_table tbl ON c.ad_table_id = tbl.ad_table_id
+JOIN ad_reference r ON c.ad_reference_id = r.ad_reference_id
+LEFT JOIN ad_val_rule vr ON c.ad_val_rule_id = vr.ad_val_rule_id
+WHERE f.isactive = 'Y' AND c.isactive = 'Y'
+]]></view>
</database>
diff -r e3451d9eeb7a -r f549fe3f7592
src-db/database/model/views/AD_PROCESS_EXECUTION_V.xml
--- a/src-db/database/model/views/AD_PROCESS_EXECUTION_V.xml Tue Apr 13
15:39:28 2010 +0200
+++ b/src-db/database/model/views/AD_PROCESS_EXECUTION_V.xml Tue Apr 13
20:00:34 2010 +0200
@@ -1,6 +1,7 @@
<?xml version="1.0"?>
<database name="VIEW AD_PROCESS_EXECUTION_V">
<view name="AD_PROCESS_EXECUTION_V"><![CDATA[SELECT rn.ad_process_run_id,
rn.ad_client_id, rn.ad_org_id, rn.isactive, rn.created, rn.createdby,
rn.updated, rn.updatedby, rq.ad_user_id, rn.status, rn.start_time, rn.end_time,
rn.runtime, rn.log, rn.result, rq.params, rn.report, rq.channel,
rq.isrolesecurity, rq.ad_process_id, rn.ad_process_request_id
- FROM ad_process_run rn
- LEFT JOIN ad_process_request rq ON rn.ad_process_request_id =
rq.ad_process_request_id]]></view>
+FROM ad_process_run rn
+LEFT JOIN ad_process_request rq ON rn.ad_process_request_id =
rq.ad_process_request_id
+]]></view>
</database>
diff -r e3451d9eeb7a -r f549fe3f7592
src-db/database/model/views/AD_REF_LIST_V.xml
--- a/src-db/database/model/views/AD_REF_LIST_V.xml Tue Apr 13 15:39:28
2010 +0200
+++ b/src-db/database/model/views/AD_REF_LIST_V.xml Tue Apr 13 20:00:34
2010 +0200
@@ -1,13 +1,14 @@
<?xml version="1.0"?>
<database name="VIEW AD_REF_LIST_V">
<view name="AD_REF_LIST_V"><![CDATA[SELECT ad_ref_list.ad_ref_list_id,
ad_ref_list.value, to_char(ad_ref_list.name) AS name, 'en_US' AS ad_language,
ad_ref_list.ad_reference_id
- FROM ad_ref_list
+FROM ad_ref_list
UNION
- SELECT v1.ad_ref_list_id, v1.value, COALESCE(v1.name_trl, v2.name) AS name,
v1.ad_language, v1.ad_reference_id
- FROM ( SELECT ad_ref_list.ad_ref_list_id, ad_ref_list.value,
to_char(ad_ref_list_trl.name) AS name_trl, '' AS name,
ad_ref_list_trl.ad_language, ad_ref_list.ad_reference_id
- FROM ad_ref_list, ad_ref_list_trl
- WHERE ad_ref_list.ad_ref_list_id = ad_ref_list_trl.ad_ref_list_id)
v1, ( SELECT ad_ref_list.ad_ref_list_id, ad_ref_list.value,
to_char(ad_ref_list.name) AS name, ad_language.ad_language,
ad_ref_list.ad_reference_id
- FROM ad_ref_list, ad_language
- WHERE ad_language.issystemlanguage = 'Y') v2
- WHERE v1.ad_ref_list_id = v2.ad_ref_list_id AND v1.ad_reference_id =
v2.ad_reference_id]]></view>
+SELECT v1.ad_ref_list_id, v1.value, COALESCE(v1.name_trl, v2.name) AS name,
v1.ad_language, v1.ad_reference_id
+FROM (SELECT ad_ref_list.ad_ref_list_id, ad_ref_list.value,
to_char(ad_ref_list_trl.name) AS name_trl, '' AS name,
ad_ref_list_trl.ad_language, ad_ref_list.ad_reference_id
+FROM ad_ref_list, ad_ref_list_trl
+WHERE ad_ref_list.ad_ref_list_id = ad_ref_list_trl.ad_ref_list_id) v1, (SELECT
ad_ref_list.ad_ref_list_id, ad_ref_list.value, to_char(ad_ref_list.name) AS
name, ad_language.ad_language, ad_ref_list.ad_reference_id
+FROM ad_ref_list, ad_language
+WHERE ad_language.issystemlanguage = 'Y') v2
+WHERE v1.ad_ref_list_id = v2.ad_ref_list_id AND v1.ad_reference_id =
v2.ad_reference_id
+]]></view>
</database>
diff -r e3451d9eeb7a -r f549fe3f7592
src-db/database/model/views/AD_TABLE_POST_V.xml
--- a/src-db/database/model/views/AD_TABLE_POST_V.xml Tue Apr 13 15:39:28
2010 +0200
+++ b/src-db/database/model/views/AD_TABLE_POST_V.xml Tue Apr 13 20:00:34
2010 +0200
@@ -1,26 +1,27 @@
<?xml version="1.0"?>
<database name="VIEW AD_TABLE_POST_V">
<view name="AD_TABLE_POST_V"><![CDATA[SELECT ad_table.ad_table_id,
(COALESCE(to_char(w2.name), '') ||
- CASE
- WHEN w2.name IS NULL THEN ''
- ELSE ' - '
- END) || w1.name AS name, w1.ad_language, ad_table.ad_client_id,
ad_table.ad_org_id, ad_table.isactive, ad_table.created, ad_table.createdby,
ad_table.updated, ad_table.updatedby
- FROM ad_table
- LEFT JOIN ad_window_trl w1 ON ad_table.ad_window_id = w1.ad_window_id
- LEFT JOIN ad_window_trl w2 ON ad_table.po_window_id = w2.ad_window_id
- WHERE (EXISTS ( SELECT c.ad_column_id, c.ad_client_id, c.ad_org_id,
c.isactive, c.created, c.updated, c.createdby, c.updatedby, c.name,
c.description, c.help, c.columnname, c.ad_table_id, c.ad_reference_id,
c.ad_reference_value_id, c.ad_val_rule_id, c.fieldlength, c.defaultvalue,
c.iskey, c.isparent, c.ismandatory, c.isupdateable, c.readonlylogic,
c.isidentifier, c.seqno, c.istranslated, c.isencrypted, c.callout, c.vformat,
c.valuemin, c.valuemax, c.isselectioncolumn, c.ad_element_id, c.ad_process_id,
c.issessionattr, c.issecondarykey, c.isdesencryptable, c.ad_callout_id,
c.developmentstatus
- FROM ad_column c
- WHERE ad_table.ad_table_id = c.ad_table_id AND c.columnname = 'Posted')) AND
w1.ad_language = COALESCE(w2.ad_language, w1.ad_language) AND ad_table.isactive
= 'Y'
+CASE
+WHEN w2.name IS NULL THEN ''
+ELSE ' - '
+END) || w1.name AS name, w1.ad_language, ad_table.ad_client_id,
ad_table.ad_org_id, ad_table.isactive, ad_table.created, ad_table.createdby,
ad_table.updated, ad_table.updatedby
+FROM ad_table
+LEFT JOIN ad_window_trl w1 ON ad_table.ad_window_id = w1.ad_window_id
+LEFT JOIN ad_window_trl w2 ON ad_table.po_window_id = w2.ad_window_id
+WHERE (EXISTS (SELECT c.ad_column_id, c.ad_client_id, c.ad_org_id, c.isactive,
c.created, c.updated, c.createdby, c.updatedby, c.name, c.description, c.help,
c.columnname, c.ad_table_id, c.ad_reference_id, c.ad_reference_value_id,
c.ad_val_rule_id, c.fieldlength, c.defaultvalue, c.iskey, c.isparent,
c.ismandatory, c.isupdateable, c.readonlylogic, c.isidentifier, c.seqno,
c.istranslated, c.isencrypted, c.callout, c.vformat, c.valuemin, c.valuemax,
c.isselectioncolumn, c.ad_element_id, c.ad_process_id, c.issessionattr,
c.issecondarykey, c.isdesencryptable, c.ad_callout_id, c.developmentstatus
+FROM ad_column c
+WHERE ad_table.ad_table_id = c.ad_table_id AND c.columnname = 'Posted')) AND
w1.ad_language = COALESCE(w2.ad_language, w1.ad_language) AND ad_table.isactive
= 'Y'
UNION
- SELECT ad_table.ad_table_id, (COALESCE(to_char(w2.name), '') ||
- CASE
- WHEN w2.name IS NULL THEN ''
- ELSE ' - '
- END) || w1.name AS name, 'en_US' AS ad_language,
ad_table.ad_client_id, ad_table.ad_org_id, ad_table.isactive, ad_table.created,
ad_table.createdby, ad_table.updated, ad_table.updatedby
- FROM ad_table
- LEFT JOIN ad_window w1 ON ad_table.ad_window_id = w1.ad_window_id
- LEFT JOIN ad_window w2 ON ad_table.po_window_id = w2.ad_window_id
- WHERE (EXISTS ( SELECT c.ad_column_id, c.ad_client_id, c.ad_org_id,
c.isactive, c.created, c.updated, c.createdby, c.updatedby, c.name,
c.description, c.help, c.columnname, c.ad_table_id, c.ad_reference_id,
c.ad_reference_value_id, c.ad_val_rule_id, c.fieldlength, c.defaultvalue,
c.iskey, c.isparent, c.ismandatory, c.isupdateable, c.readonlylogic,
c.isidentifier, c.seqno, c.istranslated, c.isencrypted, c.callout, c.vformat,
c.valuemin, c.valuemax, c.isselectioncolumn, c.ad_element_id, c.ad_process_id,
c.issessionattr, c.issecondarykey, c.isdesencryptable, c.ad_callout_id,
c.developmentstatus
- FROM ad_column c
- WHERE ad_table.ad_table_id = c.ad_table_id AND c.columnname = 'Posted')) AND
ad_table.isactive = 'Y']]></view>
+SELECT ad_table.ad_table_id, (COALESCE(to_char(w2.name), '') ||
+CASE
+WHEN w2.name IS NULL THEN ''
+ELSE ' - '
+END) || w1.name AS name, 'en_US' AS ad_language, ad_table.ad_client_id,
ad_table.ad_org_id, ad_table.isactive, ad_table.created, ad_table.createdby,
ad_table.updated, ad_table.updatedby
+FROM ad_table
+LEFT JOIN ad_window w1 ON ad_table.ad_window_id = w1.ad_window_id
+LEFT JOIN ad_window w2 ON ad_table.po_window_id = w2.ad_window_id
+WHERE (EXISTS (SELECT c.ad_column_id, c.ad_client_id, c.ad_org_id, c.isactive,
c.created, c.updated, c.createdby, c.updatedby, c.name, c.description, c.help,
c.columnname, c.ad_table_id, c.ad_reference_id, c.ad_reference_value_id,
c.ad_val_rule_id, c.fieldlength, c.defaultvalue, c.iskey, c.isparent,
c.ismandatory, c.isupdateable, c.readonlylogic, c.isidentifier, c.seqno,
c.istranslated, c.isencrypted, c.callout, c.vformat, c.valuemin, c.valuemax,
c.isselectioncolumn, c.ad_element_id, c.ad_process_id, c.issessionattr,
c.issecondarykey, c.isdesencryptable, c.ad_callout_id, c.developmentstatus
+FROM ad_column c
+WHERE ad_table.ad_table_id = c.ad_table_id AND c.columnname = 'Posted')) AND
ad_table.isactive = 'Y'
+]]></view>
</database>
diff -r e3451d9eeb7a -r f549fe3f7592 src-db/database/model/views/AD_TAB_V.xml
--- a/src-db/database/model/views/AD_TAB_V.xml Tue Apr 13 15:39:28 2010 +0200
+++ b/src-db/database/model/views/AD_TAB_V.xml Tue Apr 13 20:00:34 2010 +0200
@@ -1,7 +1,8 @@
<?xml version="1.0"?>
<database name="VIEW AD_TAB_V">
<view name="AD_TAB_V"><![CDATA[SELECT t.ad_tab_id, t.ad_window_id,
t.ad_table_id, t.name, t.description, t.help, t.seqno, t.issinglerow,
t.hastree, t.isinfotab, tbl.tablename, tbl.accesslevel, tbl.issecurityenabled,
tbl.isdeleteable, tbl.ishighvolume, tbl.isview, to_char('N') AS hasassociation,
t.istranslationtab, t.isreadonly, t.ad_image_id, t.tablevel, t.whereclause,
t.orderbyclause, t.commitwarning, t.ad_column_id, t.ad_process_id, t.issorttab,
t.ad_columnsortorder_id, t.ad_columnsortyesno_id, t.included_tab_id
- FROM ad_tab t
- JOIN ad_table tbl ON t.ad_table_id = tbl.ad_table_id
- WHERE t.isactive = 'Y' AND tbl.isactive = 'Y']]></view>
+FROM ad_tab t
+JOIN ad_table tbl ON t.ad_table_id = tbl.ad_table_id
+WHERE t.isactive = 'Y' AND tbl.isactive = 'Y'
+]]></view>
</database>
diff -r e3451d9eeb7a -r f549fe3f7592 src-db/database/model/views/AD_TAB_VT.xml
--- a/src-db/database/model/views/AD_TAB_VT.xml Tue Apr 13 15:39:28 2010 +0200
+++ b/src-db/database/model/views/AD_TAB_VT.xml Tue Apr 13 20:00:34 2010 +0200
@@ -1,8 +1,9 @@
<?xml version="1.0"?>
<database name="VIEW AD_TAB_VT">
<view name="AD_TAB_VT"><![CDATA[SELECT trl.ad_language, t.ad_tab_id,
t.ad_window_id, t.ad_table_id, trl.name, trl.description, trl.help, t.seqno,
t.issinglerow, t.hastree, t.isinfotab, tbl.tablename, tbl.accesslevel,
tbl.issecurityenabled, tbl.isdeleteable, tbl.ishighvolume, tbl.isview,
to_char('N') AS hasassociation, t.istranslationtab, t.isreadonly,
t.ad_image_id, t.tablevel, t.whereclause, t.orderbyclause, t.commitwarning,
t.ad_column_id, t.ad_process_id, t.issorttab, t.ad_columnsortorder_id,
t.ad_columnsortyesno_id, t.included_tab_id
- FROM ad_tab t
- JOIN ad_table tbl ON t.ad_table_id = tbl.ad_table_id
- JOIN ad_tab_trl trl ON t.ad_tab_id = trl.ad_tab_id
- WHERE t.isactive = 'Y' AND tbl.isactive = 'Y']]></view>
+FROM ad_tab t
+JOIN ad_table tbl ON t.ad_table_id = tbl.ad_table_id
+JOIN ad_tab_trl trl ON t.ad_tab_id = trl.ad_tab_id
+WHERE t.isactive = 'Y' AND tbl.isactive = 'Y'
+]]></view>
</database>
diff -r e3451d9eeb7a -r f549fe3f7592
src-db/database/model/views/AD_USER_ROLES_V.xml
--- a/src-db/database/model/views/AD_USER_ROLES_V.xml Tue Apr 13 15:39:28
2010 +0200
+++ b/src-db/database/model/views/AD_USER_ROLES_V.xml Tue Apr 13 20:00:34
2010 +0200
@@ -1,7 +1,8 @@
<?xml version="1.0"?>
<database name="VIEW AD_USER_ROLES_V">
<view name="AD_USER_ROLES_V"><![CDATA[SELECT u.name, r.name AS rolename
- FROM ad_user_roles ur
- JOIN ad_user u ON ur.ad_user_id = u.ad_user_id
- JOIN ad_role r ON ur.ad_role_id = r.ad_role_id]]></view>
+FROM ad_user_roles ur
+JOIN ad_user u ON ur.ad_user_id = u.ad_user_id
+JOIN ad_role r ON ur.ad_role_id = r.ad_role_id
+]]></view>
</database>
diff -r e3451d9eeb7a -r f549fe3f7592
src-db/database/model/views/AD_WINDOW_VT.xml
--- a/src-db/database/model/views/AD_WINDOW_VT.xml Tue Apr 13 15:39:28
2010 +0200
+++ b/src-db/database/model/views/AD_WINDOW_VT.xml Tue Apr 13 20:00:34
2010 +0200
@@ -1,7 +1,8 @@
<?xml version="1.0"?>
<database name="VIEW AD_WINDOW_VT">
<view name="AD_WINDOW_VT"><![CDATA[SELECT trl.ad_language,
bt.ad_window_id, trl.name, trl.description, trl.help, bt.windowtype,
bt.ad_image_id, bt.isactive
- FROM ad_window bt
- JOIN ad_window_trl trl ON bt.ad_window_id = trl.ad_window_id
- WHERE bt.isactive = 'Y']]></view>
+FROM ad_window bt
+JOIN ad_window_trl trl ON bt.ad_window_id = trl.ad_window_id
+WHERE bt.isactive = 'Y'
+]]></view>
</database>
diff -r e3451d9eeb7a -r f549fe3f7592
src-db/database/model/views/A_ASSET_AMORTIZATION.xml
--- a/src-db/database/model/views/A_ASSET_AMORTIZATION.xml Tue Apr 13
15:39:28 2010 +0200
+++ b/src-db/database/model/views/A_ASSET_AMORTIZATION.xml Tue Apr 13
20:00:34 2010 +0200
@@ -1,6 +1,7 @@
<?xml version="1.0"?>
<database name="VIEW A_ASSET_AMORTIZATION">
<view name="A_ASSET_AMORTIZATION"><![CDATA[SELECT a_asset.ad_client_id,
a_asset.ad_org_id, a_asset.isactive, a_asset.created, a_asset.createdby,
a_asset.updated, a_asset.updatedby, a_asset.a_asset_id,
a_amortization.a_amortization_id, a_amortization.startdate,
a_amortization.enddate, a_amortizationline.amortization_percentage,
a_amortizationline.amortizationamt
- FROM a_asset, a_amortization, a_amortizationline
- WHERE a_asset.a_asset_id = a_amortizationline.a_asset_id AND
a_amortizationline.a_amortization_id =
a_amortization.a_amortization_id]]></view>
+FROM a_asset, a_amortization, a_amortizationline
+WHERE a_asset.a_asset_id = a_amortizationline.a_asset_id AND
a_amortizationline.a_amortization_id = a_amortization.a_amortization_id
+]]></view>
</database>
diff -r e3451d9eeb7a -r f549fe3f7592
src-db/database/model/views/C_BPARTNER_V.xml
--- a/src-db/database/model/views/C_BPARTNER_V.xml Tue Apr 13 15:39:28
2010 +0200
+++ b/src-db/database/model/views/C_BPARTNER_V.xml Tue Apr 13 20:00:34
2010 +0200
@@ -1,8 +1,9 @@
<?xml version="1.0"?>
<database name="VIEW C_BPARTNER_V">
<view name="C_BPARTNER_V"><![CDATA[SELECT p.ad_client_id, p.ad_org_id,
p.c_bpartner_id, p.value, p.name, p.referenceno, p.so_creditlimit -
p.so_creditused AS so_creditavailable, p.so_creditlimit, p.so_creditused,
p.iscustomer, p.isvendor, p.actuallifetimevalue AS revenue, c.name AS contact,
c.phone, a.postal, a.city, c.email
- FROM c_bpartner p
- LEFT JOIN ad_user c ON p.c_bpartner_id = c.c_bpartner_id
- LEFT JOIN c_bpartner_location l ON p.c_bpartner_id = l.c_bpartner_id
- LEFT JOIN c_location a ON l.c_location_id = a.c_location_id]]></view>
+FROM c_bpartner p
+LEFT JOIN ad_user c ON p.c_bpartner_id = c.c_bpartner_id
+LEFT JOIN c_bpartner_location l ON p.c_bpartner_id = l.c_bpartner_id
+LEFT JOIN c_location a ON l.c_location_id = a.c_location_id
+]]></view>
</database>
diff -r e3451d9eeb7a -r f549fe3f7592
src-db/database/model/views/C_CASH_DETAIL.xml
--- a/src-db/database/model/views/C_CASH_DETAIL.xml Tue Apr 13 15:39:28
2010 +0200
+++ b/src-db/database/model/views/C_CASH_DETAIL.xml Tue Apr 13 20:00:34
2010 +0200
@@ -1,6 +1,7 @@
<?xml version="1.0"?>
<database name="VIEW C_CASH_DETAIL">
<view name="C_CASH_DETAIL"><![CDATA[SELECT cl.c_cash_id, cl.c_cashline_id,
c.ad_client_id, c.ad_org_id, cl.isactive, cl.created, cl.createdby, cl.updated,
cl.updatedby, c.c_cashbook_id, c.name, c.statementdate, c.dateacct,
c.processed, c.posted, cl.line, cl.description, cl.cashtype, cl.c_currency_id,
cl.amount, c_currency_convert(cl.amount, cl.c_currency_id, cb.c_currency_id,
c.statementdate, NULL, c.ad_client_id, c.ad_org_id) AS convertedamt,
cl.c_debt_payment_id, cl.c_charge_id
- FROM c_cash c, c_cashline cl, c_cashbook cb
- WHERE c.c_cash_id = cl.c_cash_id AND c.c_cashbook_id =
cb.c_cashbook_id]]></view>
+FROM c_cash c, c_cashline cl, c_cashbook cb
+WHERE c.c_cash_id = cl.c_cash_id AND c.c_cashbook_id = cb.c_cashbook_id
+]]></view>
</database>
diff -r e3451d9eeb7a -r f549fe3f7592
src-db/database/model/views/C_DEBT_PAYMENT_CANCEL.xml
--- a/src-db/database/model/views/C_DEBT_PAYMENT_CANCEL.xml Tue Apr 13
15:39:28 2010 +0200
+++ b/src-db/database/model/views/C_DEBT_PAYMENT_CANCEL.xml Tue Apr 13
20:00:34 2010 +0200
@@ -1,6 +1,7 @@
<?xml version="1.0"?>
<database name="VIEW C_DEBT_PAYMENT_CANCEL">
<view name="C_DEBT_PAYMENT_CANCEL"><![CDATA[SELECT
c_debt_payment.c_debt_payment_id, c_debt_payment.ad_client_id,
c_debt_payment.ad_org_id, c_debt_payment.isactive, c_debt_payment.created,
c_debt_payment.createdby, c_debt_payment.updated, c_debt_payment.updatedby,
c_debt_payment.isreceipt, c_debt_payment.c_settlement_cancel_id AS
c_settlement_id, c_debt_payment.description, c_debt_payment.c_invoice_id,
c_debt_payment.c_bpartner_id, c_debt_payment.c_currency_id,
c_debt_payment.c_cashline_id, c_debt_payment.c_bankstatementline_id,
c_debt_payment.c_bankaccount_id, c_debt_payment.c_cashbook_id,
c_debt_payment.paymentrule, c_debt_payment.ispaid, c_debt_payment.amount,
c_debt_payment.writeoffamt, c_debt_payment.dateplanned,
c_debt_payment.ismanual, c_debt_payment.isvalid,
c_debt_payment.changesettlementcancel, c_debt_payment.cancel_processed,
c_debt_payment.status, c_debt_payment.c_withholding_id,
c_debt_payment.withholdingamount
- FROM c_debt_payment
- WHERE c_debt_payment.c_settlement_cancel_id IS NOT NULL]]></view>
+FROM c_debt_payment
+WHERE c_debt_payment.c_settlement_cancel_id IS NOT NULL
+]]></view>
</database>
diff -r e3451d9eeb7a -r f549fe3f7592
src-db/database/model/views/C_DEBT_PAYMENT_GENERATE.xml
--- a/src-db/database/model/views/C_DEBT_PAYMENT_GENERATE.xml Tue Apr 13
15:39:28 2010 +0200
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
