FND Design Data [Home] [Help]

View: WIP_STANDARD_CLASSES_VAL_V

Product: WIP - Work in Process
Description: Standard discrete accounting classes
Implementation/DBA Data: ViewAPPS.WIP_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 = 1

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