View: CST_RESOURCE_COST_TYPES_V

Product:	BOM - Bills of Material
Description:	Resource and outside processing subelement associations with cost type : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_RESOURCE_COST_TYPES_V

View Text

SELECT DISTINCT CRO.RESOURCE_ID
, CRO.COST_TYPE_ID
, CCT.COST_TYPE
, CCT.DESCRIPTION
, CCT.ALLOW_UPDATES_FLAG
FROM CST_RESOURCE_OVERHEADS CRO
, CST_COST_TYPES CCT
WHERE CCT.COST_TYPE_ID = CRO.COST_TYPE_ID
AND NVL(CCT.ORGANIZATION_ID
, CRO.ORGANIZATION_ID) = CRO.ORGANIZATION_ID UNION ALL SELECT DISTINCT CRO.OVERHEAD_ID
, CRO.COST_TYPE_ID
, CCT.COST_TYPE
, CCT.DESCRIPTION
, CCT.ALLOW_UPDATES_FLAG
FROM CST_RESOURCE_OVERHEADS CRO
, CST_COST_TYPES CCT
WHERE CCT.COST_TYPE_ID = CRO.COST_TYPE_ID
AND NVL(CCT.ORGANIZATION_ID
, CRO.ORGANIZATION_ID) = CRO.ORGANIZATION_ID

Columns