View: WIPBV_ACCOUNTING_CLASSES

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

View Text

SELECT /* REGULAR ATTRIBUTE */ AC.CLASS_CODE
, AC.ORGANIZATION_ID
, LO1.MEANING
, AC.DISABLE_DATE
, AC.DESCRIPTION
, LO2.MEANING
, LO3.MEANING
, /* FOREIGN KEYS RESOLVED */ PA.ORGANIZATION_CODE
, AL.NAME
, /* 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 LO3
, MFG_LOOKUPS LO2
, 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 LO1.LOOKUP_TYPE = 'WIP_CLASS_TYPE'
AND LO1.LOOKUP_CODE = AC.CLASS_TYPE
AND LO2.LOOKUP_CODE (+) = AC.COMPLETION_COST_SOURCE
AND LO2.LOOKUP_TYPE (+) = 'CST_COMPLETION_COST_SRC'
AND LO3.LOOKUP_CODE (+) = AC.SYSTEM_OPTION_ID
AND LO3.LOOKUP_TYPE (+) = 'CST_SYSTEM_COMPLETION_OPTIONS'
AND '_SEC:AC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns