Product: | BOM - Bills of Material |
---|---|
Description: | Resolves all foreign key references for the table CST_COST_TYPES |
Implementation/DBA Data: | APPS.CST_COST_TYPES_V |
SELECT CCT.ROWID
, CCT.COST_TYPE_ID
, CCT.LAST_UPDATE_DATE
, CCT.LAST_UPDATED_BY
, CCT.CREATION_DATE
, CCT.CREATED_BY
, CCT.LAST_UPDATE_LOGIN
, CCT.ORGANIZATION_ID
, CCT.COST_TYPE
, CCT.DESCRIPTION
, CCT.COSTING_METHOD_TYPE
, CCT.FROZEN_STANDARD_FLAG
, CCT.DEFAULT_COST_TYPE_ID
, CCT2.COST_TYPE
, CCT.BOM_SNAPSHOT_FLAG
, CCT.ALTERNATE_BOM_DESIGNATOR
, CCT.ALLOW_UPDATES_FLAG
, DECODE(NVL(CCT.ORGANIZATION_ID
, -1)
, -1
, 1
, 2)
, CCT.PL_ELEMENT_FLAG
, CCT.PL_RESOURCE_FLAG
, CCT.PL_OPERATION_FLAG
, CCT.PL_ACTIVITY_FLAG
, CCT.DISABLE_DATE
, CCT.AVAILABLE_TO_ENG_FLAG
, CCT.COMPONENT_YIELD_FLAG
, CCT.ATTRIBUTE_CATEGORY
, CCT.ATTRIBUTE1
, CCT.ATTRIBUTE2
, CCT.ATTRIBUTE3
, CCT.ATTRIBUTE4
, CCT.ATTRIBUTE5
, CCT.ATTRIBUTE6
, CCT.ATTRIBUTE7
, CCT.ATTRIBUTE8
, CCT.ATTRIBUTE9
, CCT.ATTRIBUTE10
, CCT.ATTRIBUTE11
, CCT.ATTRIBUTE12
, CCT.ATTRIBUTE13
, CCT.ATTRIBUTE14
, CCT.ATTRIBUTE15
, CCT.REQUEST_ID
, CCT.PROGRAM_APPLICATION_ID
, CCT.PROGRAM_ID
, CCT.PROGRAM_UPDATE_DATE
FROM CST_COST_TYPES CCT
, CST_COST_TYPES CCT2
WHERE CCT2.COST_TYPE_ID = CCT.DEFAULT_COST_TYPE_ID