DBA Data[Home] [Help]

VIEW: APPS.WIP_NON_STANDARD_CLASSES_VAL_V

Source

View Text - Preformatted

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)
View Text - HTML Formatted

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)