VIEW: APPS.WIPFV_ACCOUNTING_CLASSES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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