[Home] [Help]
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
Name |
RESOURCE_ID |
COST_TYPE_ID |
COST_TYPE |
DESCRIPTION |
ALLOW_UPDATES_FLAG |