FND Design Data [Home] [Help]

View: WIP_NON_STANDARD_CLASSES_VAL_V

Product: WIP - Work in Process
Description: Nonstandard accounting classes
Implementation/DBA Data: ViewAPPS.WIP_NON_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 IN (3
, 4)

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