View: WIPFV_ACCOUNTING_CLASSES

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPFV_ACCOUNTING_CLASSES

View Text

SELECT /* REGULAR ATTRIBUTES */ AC.CLASS_CODE
, AC.ORGANIZATION_ID
, LO1.MEANING
, AC.DISABLE_DATE
, AC.DESCRIPTION
, LO2.MEANING
, LO3.MEANING /* RESOLVED FOREIGN KEYS */
, PA.ORGANIZATION_CODE
, AL.NAME
, CO.COST_TYPE
, '_KF:SQLGL:GL#:CO1'
, '_KF:SQLGL:GL#:CO2'
, '_KF:SQLGL:GL#:CO3'
, '_KF:SQLGL:GL#:CO4'
, '_KF:SQLGL:GL#:CO5'
, '_KF:SQLGL:GL#:CO6'
, '_KF:SQLGL:GL#:CO7'
, '_KF:SQLGL:GL#:CO8'
, '_KF:SQLGL:GL#:CO9'
, '_KF:SQLGL:GL#:CO10'
, '_KF:SQLGL:GL#:CO11'
, '_KF:SQLGL:GL#:CO12'
, '_DF:WIP:WIP_ACCOUNTING_CLASSES:AC' /* IDS */
, AC.MATERIAL_ACCOUNT
, AC.MATERIAL_VARIANCE_ACCOUNT
, AC.MATERIAL_OVERHEAD_ACCOUNT
, AC.RESOURCE_ACCOUNT
, AC.RESOURCE_VARIANCE_ACCOUNT
, AC.OUTSIDE_PROCESSING_ACCOUNT
, AC.OUTSIDE_PROC_VARIANCE_ACCOUNT
, AC.OVERHEAD_ACCOUNT
, AC.OVERHEAD_VARIANCE_ACCOUNT
, AC.STD_COST_ADJUSTMENT_ACCOUNT
, AC.BRIDGING_ACCOUNT
, AC.EXPENSE_ACCOUNT
, AC.COST_TYPE_ID /* WHO */
, AC.CREATION_DATE
, AC.CREATED_BY
, AC.LAST_UPDATE_DATE
, AC.LAST_UPDATED_BY
FROM MFG_LOOKUPS LO2
, MFG_LOOKUPS LO3
, GL_CODE_COMBINATIONS CO9
, GL_CODE_COMBINATIONS CO10
, GL_CODE_COMBINATIONS CO11
, GL_CODE_COMBINATIONS CO12
, CST_COST_TYPES CO
, GL_CODE_COMBINATIONS CO1
, GL_CODE_COMBINATIONS CO2
, GL_CODE_COMBINATIONS CO3
, GL_CODE_COMBINATIONS CO4
, GL_CODE_COMBINATIONS CO5
, GL_CODE_COMBINATIONS CO6
, GL_CODE_COMBINATIONS CO7
, GL_CODE_COMBINATIONS CO8
, MFG_LOOKUPS LO1
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_ACCOUNTING_CLASSES AC
WHERE AC.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND AC.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND CO1.CODE_COMBINATION_ID = AC.MATERIAL_ACCOUNT
AND CO2.CODE_COMBINATION_ID = AC.MATERIAL_VARIANCE_ACCOUNT
AND CO3.CODE_COMBINATION_ID = AC.MATERIAL_OVERHEAD_ACCOUNT
AND CO4.CODE_COMBINATION_ID = AC.RESOURCE_ACCOUNT
AND CO5.CODE_COMBINATION_ID = AC.RESOURCE_VARIANCE_ACCOUNT
AND CO6.CODE_COMBINATION_ID = AC.OUTSIDE_PROCESSING_ACCOUNT
AND CO7.CODE_COMBINATION_ID = AC.OUTSIDE_PROC_VARIANCE_ACCOUNT
AND CO8.CODE_COMBINATION_ID = AC.OVERHEAD_ACCOUNT
AND CO9.CODE_COMBINATION_ID (+) = AC.OVERHEAD_VARIANCE_ACCOUNT
AND CO10.CODE_COMBINATION_ID (+) = AC.STD_COST_ADJUSTMENT_ACCOUNT
AND CO11.CODE_COMBINATION_ID (+) = AC.BRIDGING_ACCOUNT
AND CO12.CODE_COMBINATION_ID (+) = AC.EXPENSE_ACCOUNT
AND CO.COST_TYPE_ID (+) = AC.COST_TYPE_ID
AND LO1.LOOKUP_TYPE = 'WIP_CLASS_TYPE'
AND LO1.LOOKUP_CODE = AC.CLASS_TYPE
AND LO2.LOOKUP_TYPE (+) = 'CST_COMPLETION_COST_SRC'
AND LO2.LOOKUP_CODE (+) = AC.COMPLETION_COST_SOURCE
AND LO3.LOOKUP_TYPE (+) = 'CST_SYSTEM_COMPLETION_OPTIONS'
AND LO3.LOOKUP_CODE (+) = AC.SYSTEM_OPTION_ID
AND '_SEC:AC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns