AutoAccounting Rule

Hi,

We are defining auto accounting for Supplier Cost Adjustment Transaction. Our COA Account Segment is mapped to expenditure type but account value varies based on Project Type for example:

If Project Type = Software Development, then

Subcontractor = 100001

If Project Type = Training, then

Subcontractor = 100005

Same expenditure type has multiple account segement values based on project types. We have defined two different lookups and trying to define rule with SQL script to derive lookup based on project type. But we want to understand that How to call two different lookups in single rule?

Can we achieve it through SQL? any other solution.