View: BOM_RESOURCES_V

Product:	BOM - Bills of Material
Description:	Resources, overheads, material cost codes, and material overheads
Implementation/DBA Data:	APPS.BOM_RESOURCES_V

View Text

SELECT BR.ROWID ROW_ID
, BR.RESOURCE_ID
, BR.RESOURCE_CODE
, BR.ORGANIZATION_ID
, BR.LAST_UPDATE_DATE
, BR.LAST_UPDATED_BY
, BR.CREATION_DATE
, BR.CREATED_BY
, BR.LAST_UPDATE_LOGIN
, BR.DESCRIPTION
, BR.DISABLE_DATE
, BR.COST_ELEMENT_ID
, BR.PURCHASE_ITEM_ID
, BR.COST_CODE_TYPE
, BR.FUNCTIONAL_CURRENCY_FLAG
, BR.UNIT_OF_MEASURE
, BR.DEFAULT_ACTIVITY_ID
, CA.ACTIVITY DEFAULT_ACTIVITY
, DECODE(BR.FUNCTIONAL_CURRENCY_FLAG
, 1
, 6
, BR.RESOURCE_TYPE)
, BR.AUTOCHARGE_TYPE
, BR.STANDARD_RATE_FLAG
, BR.DEFAULT_BASIS_TYPE
, BR.ALLOW_COSTS_FLAG
, BR.ABSORPTION_ACCOUNT
, BR.RATE_VARIANCE_ACCOUNT
, BR.EXPENDITURE_TYPE
, BR.ATTRIBUTE_CATEGORY
, BR.ATTRIBUTE1
, BR.ATTRIBUTE2
, BR.ATTRIBUTE3
, BR.ATTRIBUTE4
, BR.ATTRIBUTE5
, BR.ATTRIBUTE6
, BR.ATTRIBUTE7
, BR.ATTRIBUTE8
, BR.ATTRIBUTE9
, BR.ATTRIBUTE10
, BR.ATTRIBUTE11
, BR.ATTRIBUTE12
, BR.ATTRIBUTE13
, BR.ATTRIBUTE14
, BR.ATTRIBUTE15
, BR.REQUEST_ID
, BR.PROGRAM_APPLICATION_ID
, BR.PROGRAM_ID
, BR.PROGRAM_UPDATE_DATE
, BR.BATCHABLE
, BR.MIN_BATCH_CAPACITY
, BR.MAX_BATCH_CAPACITY
, BR.BATCH_CAPACITY_UOM
, BR.BATCH_WINDOW
, BR.BATCH_WINDOW_UOM
, BR.COMPETENCE_ID
, BR.RATING_LEVEL_ID
, BR.QUALIFICATION_TYPE_ID
, BR.BILLABLE_ITEM_ID
, BR.SUPPLY_SUBINVENTORY
, BR.SUPPLY_LOCATOR_ID
, BR.BATCHING_PENALTY
FROM BOM_RESOURCES BR
, CST_ACTIVITIES CA
WHERE CA.ACTIVITY_ID(+) = BR.DEFAULT_ACTIVITY_ID

Columns