[Home] [Help]
View: CST_DEPOVH_COST_TYPES_V
Product: | BOM - Bills of Material |
Description: | Departmental overheads for cost type : SINGLE-ORG view |
Implementation/DBA Data: |
APPS.CST_DEPOVH_COST_TYPES_V
|
View Text
SELECT DISTINCT -1
, CDO.DEPARTMENT_ID
, CDO.COST_TYPE_ID
, CCT.COST_TYPE
, CCT.DESCRIPTION
, CCT.ALLOW_UPDATES_FLAG
FROM CST_DEPARTMENT_OVERHEADS CDO
, CST_COST_TYPES CCT
WHERE CCT.COST_TYPE_ID = CDO.COST_TYPE_ID
AND NVL(CCT.ORGANIZATION_ID
, CDO.ORGANIZATION_ID) = CDO.ORGANIZATION_ID UNION ALL SELECT DISTINCT CDO.OVERHEAD_ID
, -1
, CDO.COST_TYPE_ID
, CCT.COST_TYPE
, CCT.DESCRIPTION
, CCT.ALLOW_UPDATES_FLAG
FROM CST_DEPARTMENT_OVERHEADS CDO
, CST_COST_TYPES CCT
WHERE CCT.COST_TYPE_ID = CDO.COST_TYPE_ID
AND NVL(CCT.ORGANIZATION_ID
, CDO.ORGANIZATION_ID) = CDO.ORGANIZATION_ID
Columns
Name |
OVERHEAD_ID |
DEPARTMENT_ID |
COST_TYPE_ID |
COST_TYPE |
DESCRIPTION |
ALLOW_UPDATES_FLAG |