|
|
These are the afected validation rules:
<!--800022--> <CODE><![CDATA[AD_CLIENT.ISACTIVE = 'Y' AND EXISTS (SELECT 1 FROM AD_ROLE_ORGACCESS WHERE AD_ROLE_ORGACCESS.AD_CLIENT_ID = AD_CLIENT.AD_CLIENT_ID AND AD_ROLE_ORGACCESS.AD_ROLE_ID = @Default_AD_Role_ID@ AND AD_ROLE_ORGACCESS.ISACTIVE = 'Y')]]></CODE>
name | name | tablevel | name | sqllogic
------+------+----------+----------------+----------
User | User | 0 | Default Client |
<!--800023--> <CODE><![CDATA[EXISTS (SELECT 1 FROM AD_ROLE_ORGACCESS A_R_O, ad_role r
WHERE A_R_O.AD_ORG_ID = AD_ORG.AD_Org_ID
AND A_R_O.ISACTIVE = 'Y'
AND A_R_O.AD_ROLE_ID = R.AD_ROLE_ID
and r.ad_role_id = @Default_AD_Role_ID@
AND R.ISACTIVE = 'Y'
AND (LPAD(TO_CHAR(R.USERLEVEL), 1, '1')='S' OR AD_ORG.AD_ORG_ID <> '0')
AND A_R_O.AD_ROLE_ID = @Default_AD_Role_ID@)]]></CODE>
db_pos2_modules=> select w.name, t.name, t.tablevel, f.name, c.sqllogic from ad_window w, ad_tab t, ad_field f, ad_column c where w.ad_window_id = t.ad_window_id and t.ad_tab_id = f.ad_tab_id and f.ad_column_id = c.ad_column_id and c.ad_column_id in (select ad_column_id from ad_column where ad_val_rule_id = '800023') order by 1, 2, 3;
name | name | tablevel | name | sqllogic
------+------+----------+----------------------+----------
User | User | 0 | Default Organization |
(1 row)
<!--994D5D0FB26D44988D04CE19D66B0A2C--> <CODE><![CDATA[EXISTS (SELECT 1
FROM AD_ROLE_ORGACCESS A_R_O
INNER JOIN ad_role r ON (A_R_O.AD_ROLE_ID = r.AD_ROLE_ID)
WHERE A_R_O.ISACTIVE = 'Y'
AND r.ISACTIVE = 'Y'
and r.ad_role_id = @#AD_Role_ID@
AND (A_R_O.AD_ORG_ID = td0.AD_Org_ID
OR (SUBSTR(TO_CHAR(r.USERLEVEL), 2, 1) = 'C' AND td0.AD_ORG_ID = '0')
)
)]]></CODE>
db_pos2_modules=> select w.name, t.name, t.tablevel, f.name, c.sqllogic from ad_window w, ad_tab t, ad_field f, ad_column c where w.ad_window_id = t.ad_window_id and t.ad_tab_id = f.ad_tab_id and f.ad_column_id = c.ad_column_id and c.ad_column_id in (select ad_column_id from ad_column where ad_val_rule_id = '994D5D0FB26D44988D04CE19D66B0A2C') order by 1, 2, 3;
name | name | tablevel | name | sqllogic
----------------------------------+-------------------------------+----------+--------------------+----------
Commercial Operations by Product | Commercial Operations | 0 | Product Price |
Commercial Operations by Product | Commercial Operations | 0 | Price List Version |
Expense Type | Price | 2 | Price List Version |
Price List | Product Price | 2 | Price List Version |
Price List | Product Price with Exceptions | 3 | Product Price |
Product | Price | 1 | Price List Version |
Product | Product Price with Exceptions | 2 | Product Price |
Resource | Price | 2 | Price List Version |
<!--D9463AFD77E44F619D396C19BF9E6A15--> <CODE><![CDATA[EXISTS (SELECT 1 FROM AD_ROLE_ORGACCESS A_R_O, ad_role r
WHERE A_R_O.AD_ORG_ID = AD_ORG.AD_Org_ID
AND A_R_O.ISACTIVE = 'Y'
AND A_R_O.AD_ROLE_ID = R.AD_ROLE_ID
and r.ad_role_id = @#AD_Role_ID@
AND R.ISACTIVE = 'Y'
AND (LPAD(TO_CHAR(R.USERLEVEL), 1, '1')='S' OR AD_ORG.AD_ORG_ID <> '0')
AND A_R_O.AD_ROLE_ID = @#AD_Role_ID@)]]></CODE>
db_pos2_modules=> select w.name, t.name, t.tablevel, f.name, c.sqllogic from ad_window w, ad_tab t, ad_field f, ad_column c where w.ad_window_id = t.ad_window_id and t.ad_tab_id = f.ad_tab_id and f.ad_column_id = c.ad_column_id and c.ad_column_id in (select ad_column_id from ad_column where ad_val_rule_id = 'D9463AFD77E44F619D396C19BF9E6A15') order by 1, 2, 3;
name | name | tablevel | name | sqllogic
------+------+----------+------+----------
(0 rows) |
|
Screenshot_6.png (97,674) 2023-11-06 15:50