Product: | WIP - Work in Process |
---|---|
Description: | Nonstandard accounting classes |
Implementation/DBA Data: | APPS.WIP_NON_STANDARD_CLASSES_VAL_V |
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)