select t1.CLASS_CODE,

t1.ORGANIZATION_ID,

t1.LAST_UPDATE_DATE,

t1.LAST_UPDATED_BY,

t1.CREATION_DATE,

t1.CREATED_BY,

t1.CLASS_TYPE,

t1.DESCRIPTION,

t1.DISABLE_DATE,

t1.attribute1,

t1.attribute2,

g1.CONCATENATED_SEGMENTS MATERIAL_ACCOUNT,

g2.CONCATENATED_SEGMENTS MATERIAL_VARIANCE_ACCOUNT,

g3.CONCATENATED_SEGMENTS MATERIAL_OVERHEAD_ACCOUNT,

g4.CONCATENATED_SEGMENTS RESOURCE_ACCOUNT,

g5.CONCATENATED_SEGMENTS RESOURCE_VARIANCE_ACCOUNT,

g6.CONCATENATED_SEGMENTS OUTSIDE_PROCESSING_ACCOUNT,

g7.CONCATENATED_SEGMENTS OUTSIDE_PROC_VARIANCE_ACCOUNT,

g8.CONCATENATED_SEGMENTS OVERHEAD_ACCOUNT,

g9.CONCATENATED_SEGMENTS OVERHEAD_VARIANCE_ACCOUNT,

g10.CONCATENATED_SEGMENTS STD_COST_ADJUSTMENT_ACCOUNT

from wip.WIP_ACCOUNTING_CLASSES t1,

apps.gl_code_combinations_kfv g1,

apps.gl_code_combinations_kfv g2,

apps.gl_code_combinations_kfv g3,

apps.gl_code_combinations_kfv g4,

apps.gl_code_combinations_kfv g5,

apps.gl_code_combinations_kfv g6,

apps.gl_code_combinations_kfv g7,

apps.gl_code_combinations_kfv g8,

apps.gl_code_combinations_kfv g9,

apps.gl_code_combinations_kfv g10

where t1.organization_id IN (1520, 3438)

and t1.material_account = g1.CODE_COMBINATION_ID(+)

and t1.MATERIAL_VARIANCE_ACCOUNT = g2.CODE_COMBINATION_ID(+)

and t1.MATERIAL_OVERHEAD_ACCOUNT = g3.CODE_COMBINATION_ID(+)

and t1.RESOURCE_ACCOUNT = g4.CODE_COMBINATION_ID(+)

and t1.RESOURCE_VARIANCE_ACCOUNT = g5.CODE_COMBINATION_ID(+)

and t1.OUTSIDE_PROCESSING_ACCOUNT = g6.CODE_COMBINATION_ID(+)

and t1.OUTSIDE_PROC_VARIANCE_ACCOUNT = g7.CODE_COMBINATION_ID(+)

and t1.OVERHEAD_ACCOUNT = g8.CODE_COMBINATION_ID(+)

and t1.OVERHEAD_VARIANCE_ACCOUNT = g9.CODE_COMBINATION_ID(+)

and t1.STD_COST_ADJUSTMENT_ACCOUNT = g10.CODE_COMBINATION_ID(+)