View: CST_CG_WIP_ACCT_CLASSES_V

Product:	BOM - Bills of Material
Description:	Accounting classes valid for cost groups
Implementation/DBA Data:	APPS.CST_CG_WIP_ACCT_CLASSES_V

View Text

SELECT MP.ORGANIZATION_ID
, WAC.CLASS_CODE
, WAC.CLASS_TYPE
, NVL(CCWAC.COST_GROUP_ID
, DECODE(MP.PRIMARY_COST_METHOD
, 1
, -1
, DEFAULT_COST_GROUP_ID)) COST_GROUP_ID
, NVL(CCWAC.DISABLE_DATE
, WAC.DISABLE_DATE )
FROM CST_CG_WIP_ACCT_CLASSES CCWAC
, WIP_ACCOUNTING_CLASSES WAC
, MTL_PARAMETERS MP
WHERE WAC.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND WAC.CLASS_CODE = CCWAC.CLASS_CODE(+)
AND WAC.ORGANIZATION_ID = CCWAC.ORGANIZATION_ID(+)
AND NVL(WAC.DISABLE_DATE
, SYSDATE + 1) > SYSDATE
AND NVL(CCWAC.DISABLE_DATE
, SYSDATE+1) > SYSDATE

Columns