[Home] [Help]
23: SELECT to_number(nvl(b.attribute_value, a.attribute_value)) attribute_value
24: FROM (SELECT jrp.organization_id organization_id,
25: acc.attribute_value attribute_value,
26: jrp.regime_org_id
27: FROM jai_rgm_parties jrp,
28: jai_rgm_registrations jrr,
29: jai_rgm_definitions jrg,
30: jai_rgm_registrations acc
31: WHERE 1 = 1
41: ) a,
42: (SELECT jrp.organization_id organization_id,
43: jpr.attribute_value attribute_value,
44: jrp.regime_org_id
45: FROM jai_rgm_parties jrp,
46: jai_rgm_registrations jrr,
47: jai_rgm_registrations acc,
48: jai_rgm_party_regns jpr,
49: jai_rgm_definitions jrg