VIEW: APPS.CST_COST_TYPES_VAL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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