Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities

SELECT
wac.ORGANIZATION_ID,
(sELECT NAME FROM HR_ORGANIZATION_UNITS_V HRO WHERE HRO.ORGANIZATION_ID = wac.ORGANIZATION_ID) ORG_NAME,
wac.class_code,
wac.description,
(SELECT GCC.SEGMENT1||'.'||GCC.SEGMENT2||'.'||GCC.SEGMENT3||'.'||GCC.SEGMENT4||'.'||GCC.SEGMENT5||'.'||GCC.SEGMENT6 FROM GL_CODE_COMBINATIONS GCC WHERE GCC.CODE_COMBINATION_ID = MATERIAL_ACCOUNT) WIP_MATERIAL_ACCOUNT,
(SELECT GCC.SEGMENT1||'.'||GCC.SEGMENT2||'.'||GCC.SEGMENT3||'.'||GCC.SEGMENT4||'.'||GCC.SEGMENT5||'.'||GCC.SEGMENT6 FROM GL_CODE_COMBINATIONS GCC WHERE GCC.CODE_COMBINATION_ID = MATERIAL_VARIANCE_ACCOUNT) MATERIAL_Variance_ACCOUNT,
(SELECT GCC.SEGMENT1||'.'||GCC.SEGMENT2||'.'||GCC.SEGMENT3||'.'||GCC.SEGMENT4||'.'||GCC.SEGMENT5||'.'||GCC.SEGMENT6 FROM GL_CODE_COMBINATIONS GCC WHERE GCC.CODE_COMBINATION_ID = MATERIAL_overhead_ACCOUNT) MATERIAL_OVERHEAD_ACCOUNT,
(SELECT GCC.SEGMENT1||'.'||GCC.SEGMENT2||'.'||GCC.SEGMENT3||'.'||GCC.SEGMENT4||'.'||GCC.SEGMENT5||'.'||GCC.SEGMENT6 FROM GL_CODE_COMBINATIONS GCC WHERE GCC.CODE_COMBINATION_ID = RESOURCE_ACCOUNT) WIP_RESOURCE_ACCOUNT,
(SELECT GCC.SEGMENT1||'.'||GCC.SEGMENT2||'.'||GCC.SEGMENT3||'.'||GCC.SEGMENT4||'.'||GCC.SEGMENT5||'.'||GCC.SEGMENT6 FROM GL_CODE_COMBINATIONS GCC WHERE GCC.CODE_COMBINATION_ID = RESOURCE_variance_ACCOUNT) RESOURCE_Variance_ACCOUNT,
(SELECT GCC.SEGMENT1||'.'||GCC.SEGMENT2||'.'||GCC.SEGMENT3||'.'||GCC.SEGMENT4||'.'||GCC.SEGMENT5||'.'||GCC.SEGMENT6 FROM GL_CODE_COMBINATIONS GCC WHERE GCC.CODE_COMBINATION_ID = OVERHEAD_ACCOUNT) WIP_OVERHEAD_ACCOUNT,
(SELECT GCC.SEGMENT1||'.'||GCC.SEGMENT2||'.'||GCC.SEGMENT3||'.'||GCC.SEGMENT4||'.'||GCC.SEGMENT5||'.'||GCC.SEGMENT6 FROM GL_CODE_COMBINATIONS GCC WHERE GCC.CODE_COMBINATION_ID = OVERHEAD_VARIANCE_account) WIP_OVERHEAD_VARIANCE,
(SELECT GCC.SEGMENT1||'.'||GCC.SEGMENT2||'.'||GCC.SEGMENT3||'.'||GCC.SEGMENT4||'.'||GCC.SEGMENT5||'.'||GCC.SEGMENT6 FROM GL_CODE_COMBINATIONS GCC WHERE GCC.CODE_COMBINATION_ID = OUTSIDE_PROCESSING_ACCOUNT) OUTSIDE_PROCESSING_ACCOUNT,
(SELECT GCC.SEGMENT1||'.'||GCC.SEGMENT2||'.'||GCC.SEGMENT3||'.'||GCC.SEGMENT4||'.'||GCC.SEGMENT5||'.'||GCC.SEGMENT6 FROM GL_CODE_COMBINATIONS GCC WHERE GCC.CODE_COMBINATION_ID = OUTSIDE_PROC_VARIANCE_ACCOUNT) OUTSIDE_PROC_VARIANCE_ACCOUNT
from
WIP_ACCOUNTING_CLASSES wac
where wac.organization_id = :Organization_id