Product: | BOM - Bills of Material |
---|---|
Description: | Cost types that are not disabled : SINGLE-ORG view |
Implementation/DBA Data: | APPS.CST_COST_TYPES_VAL_V |
SELECT 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
, CCT.BOM_SNAPSHOT_FLAG
, CCT.ALTERNATE_BOM_DESIGNATOR
, CCT.ALLOW_UPDATES_FLAG
, LU.MEANING
, 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
, MFG_LOOKUPS LU
WHERE NVL(CCT.DISABLE_DATE
, SYSDATE+1) > SYSDATE
AND LU.LOOKUP_TYPE = 'SYS_YES_NO'
AND LU.LOOKUP_CODE = CCT.ALLOW_UPDATES_FLAG