Product: | BOM - Bills of Material |
---|---|
Description: | Resolves all foreign key references for the table CST_ITEM_OVERHEAD_DEFAULTS |
Implementation/DBA Data: | APPS.CST_ITEM_OVERHEAD_DEFAULTS_V |
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