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 IN (3, 4)
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 IN (3
, 4)
|
|
|