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
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
|
|
|