[Home] [Help]
| Product: | WSM - Shop Floor Management |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.WSM_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 = 5