Product: | WIP - Work in Process |
---|---|
Description: | Default accounting classes |
Implementation/DBA Data: | APPS.WIP_DEF_CAT_ACC_CLASSES_V |
SELECT WDCACV.ROWID ROW_ID
, WDCACV.CATEGORY_ID
, CCG.COST_GROUP_ID
, WDCACV.ORGANIZATION_ID
, WDCACV.STD_DISCRETE_CLASS
, WDCACV.REPETITIVE_ASSY_CLASS
, CCG.COST_GROUP
, WDCACV.LAST_UPDATE_DATE
, WDCACV.LAST_UPDATED_BY
, WDCACV.CREATION_DATE
, WDCACV.CREATED_BY
, WDCACV.LAST_UPDATE_LOGIN
, WDCACV.REQUEST_ID
, WDCACV.PROGRAM_APPLICATION_ID
, WDCACV.PROGRAM_ID
, WDCACV.PROGRAM_UPDATE_DATE
FROM CST_COST_GROUPS CCG
, WIP_DEF_CAT_ACC_CLASSES WDCACV
WHERE WDCACV.COST_GROUP_ID = CCG.COST_GROUP_ID(+)