VIEW: APPS.CST_ITEM_OVERHEAD_DEFAULTS_V

Source

View Text - Preformatted

SELECT CIOD.ROWID , CIOD.ORGANIZATION_ID , CIOD.CATEGORY_SET_ID , CIOD.CATEGORY_ID , BR.RESOURCE_ID , BR.RESOURCE_CODE , CIOD.ITEM_TYPE , LU1.MEANING , CIOD.LAST_UPDATE_DATE , CIOD.LAST_UPDATED_BY , CIOD.CREATION_DATE , CIOD.CREATED_BY , CIOD.LAST_UPDATE_LOGIN , CA.ACTIVITY , CIOD.ACTIVITY_ID , LU2.MEANING , CIOD.BASIS_TYPE , CIOD.ITEM_UNITS , CIOD.ACTIVITY_UNITS , CIOD.USAGE_RATE_OR_AMOUNT , CIOD.ATTRIBUTE_CATEGORY , CIOD.ACTIVITY_CONTEXT , CIOD.ATTRIBUTE1 , CIOD.ATTRIBUTE2 , CIOD.ATTRIBUTE3 , CIOD.ATTRIBUTE4 , CIOD.ATTRIBUTE5 , CIOD.ATTRIBUTE6 , CIOD.ATTRIBUTE7 , CIOD.ATTRIBUTE8 , CIOD.ATTRIBUTE9 , CIOD.ATTRIBUTE10 , CIOD.ATTRIBUTE11 , CIOD.ATTRIBUTE12 , CIOD.ATTRIBUTE13 , CIOD.ATTRIBUTE14 , CIOD.ATTRIBUTE15 , CIOD.REQUEST_ID , CIOD.PROGRAM_APPLICATION_ID , CIOD.PROGRAM_ID , CIOD.PROGRAM_UPDATE_DATE FROM CST_ITEM_OVERHEAD_DEFAULTS CIOD, BOM_RESOURCES BR, CST_ACTIVITIES CA, MFG_LOOKUPS LU1, MFG_LOOKUPS LU2 WHERE BR.RESOURCE_ID(+) = CIOD.MATERIAL_OVERHEAD_ID AND CA.ACTIVITY_ID(+) = CIOD.ACTIVITY_ID AND LU1.LOOKUP_TYPE(+) = 'CST_MTL_ITEM_TYPE' AND LU1.LOOKUP_CODE(+) = CIOD.ITEM_TYPE AND LU2.LOOKUP_TYPE(+) = 'CST_BASIS' AND LU2.LOOKUP_CODE(+) = CIOD.BASIS_TYPE

View Text - HTML Formatted

SELECT CIOD.ROWID
, CIOD.ORGANIZATION_ID
, CIOD.CATEGORY_SET_ID
, CIOD.CATEGORY_ID
, BR.RESOURCE_ID
, BR.RESOURCE_CODE
, CIOD.ITEM_TYPE
, LU1.MEANING
, CIOD.LAST_UPDATE_DATE
, CIOD.LAST_UPDATED_BY
, CIOD.CREATION_DATE
, CIOD.CREATED_BY
, CIOD.LAST_UPDATE_LOGIN
, CA.ACTIVITY
, CIOD.ACTIVITY_ID
, LU2.MEANING
, CIOD.BASIS_TYPE
, CIOD.ITEM_UNITS
, CIOD.ACTIVITY_UNITS
, CIOD.USAGE_RATE_OR_AMOUNT
, CIOD.ATTRIBUTE_CATEGORY
, CIOD.ACTIVITY_CONTEXT
, CIOD.ATTRIBUTE1
, CIOD.ATTRIBUTE2
, CIOD.ATTRIBUTE3
, CIOD.ATTRIBUTE4
, CIOD.ATTRIBUTE5
, CIOD.ATTRIBUTE6
, CIOD.ATTRIBUTE7
, CIOD.ATTRIBUTE8
, CIOD.ATTRIBUTE9
, CIOD.ATTRIBUTE10
, CIOD.ATTRIBUTE11
, CIOD.ATTRIBUTE12
, CIOD.ATTRIBUTE13
, CIOD.ATTRIBUTE14
, CIOD.ATTRIBUTE15
, CIOD.REQUEST_ID
, CIOD.PROGRAM_APPLICATION_ID
, CIOD.PROGRAM_ID
, CIOD.PROGRAM_UPDATE_DATE
FROM CST_ITEM_OVERHEAD_DEFAULTS CIOD
, BOM_RESOURCES BR
, CST_ACTIVITIES CA
, MFG_LOOKUPS LU1
, MFG_LOOKUPS LU2
WHERE BR.RESOURCE_ID(+) = CIOD.MATERIAL_OVERHEAD_ID
AND CA.ACTIVITY_ID(+) = CIOD.ACTIVITY_ID
AND LU1.LOOKUP_TYPE(+) = 'CST_MTL_ITEM_TYPE'
AND LU1.LOOKUP_CODE(+) = CIOD.ITEM_TYPE
AND LU2.LOOKUP_TYPE(+) = 'CST_BASIS'
AND LU2.LOOKUP_CODE(+) = CIOD.BASIS_TYPE