[Home] [Help]
View: WSM_STANDARD_CLASSES_VAL_V
View Text
SELECT CLASS_CODE
, DESCRIPTION
, CLASS_TYPE
, MATERIAL_ACCOUNT
, MATERIAL_VARIANCE_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT
, RESOURCE_ACCOUNT
, RESOURCE_VARIANCE_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT
, OUTSIDE_PROC_VARIANCE_ACCOUNT
, OVERHEAD_ACCOUNT
, OVERHEAD_VARIANCE_ACCOUNT
, STD_COST_ADJUSTMENT_ACCOUNT
, ORGANIZATION_ID
FROM WIP_ACCOUNTING_CLASSES
WHERE NVL ( DISABLE_DATE
, SYSDATE+1 ) > SYSDATE
AND CLASS_TYPE = 5
Columns
Name |
CLASS_CODE |
DESCRIPTION |
CLASS_TYPE |
MATERIAL_ACCOUNT |
MATERIAL_VARIANCE_ACCOUNT |
MATERIAL_OVERHEAD_ACCOUNT |
RESOURCE_ACCOUNT |
RESOURCE_VARIANCE_ACCOUNT |
OUTSIDE_PROCESSING_ACCOUNT |
OUTSIDE_PROC_VARIANCE_ACCOUNT |
OVERHEAD_ACCOUNT |
OVERHEAD_VARIANCE_ACCOUNT |
STD_COST_ADJUSTMENT_ACCOUNT |
ORGANIZATION_ID |