+- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com)
+-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html)
+--- Forum: Oracle E-Business Suite (EBS) (http://www.oraerp.com/forum-1.html)
+---- Forum: Purchasing, Inventory & Order Management (http://www.oraerp.com/forum-3.html)
+---- Thread: WIP Acounting Class (/thread-71191.html)
WIP Acounting Class - shirfanarshad - 10-24-2014
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