VIEW: APPS.WIPBV_ACCOUNTING_CLASSES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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