VIEW: APPS.BOM_RESOURCES_ALL_V

Source

View Text - Preformatted

SELECT BR.RESOURCE_ID, BR.RESOURCE_CODE, BR.DESCRIPTION, BR.UNIT_OF_MEASURE, BR.COST_ELEMENT_ID, BR.DISABLE_DATE, BR.ORGANIZATION_ID, BR.COST_CODE_TYPE, BR.LAST_UPDATE_DATE, BR.LAST_UPDATED_BY, BR.CREATION_DATE, BR.CREATED_BY, BR.LAST_UPDATE_LOGIN, BR.PURCHASE_ITEM_ID, BR.FUNCTIONAL_CURRENCY_FLAG, BR.DEFAULT_ACTIVITY_ID, BR.RESOURCE_TYPE, BR.AUTOCHARGE_TYPE, BR.STANDARD_RATE_FLAG, BR.DEFAULT_BASIS_TYPE, BR.ABSORPTION_ACCOUNT, BR.ALLOW_COSTS_FLAG, 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 FROM BOM_RESOURCES BR

View Text - HTML Formatted

SELECT BR.RESOURCE_ID
, BR.RESOURCE_CODE
, BR.DESCRIPTION
, BR.UNIT_OF_MEASURE
, BR.COST_ELEMENT_ID
, BR.DISABLE_DATE
, BR.ORGANIZATION_ID
, BR.COST_CODE_TYPE
, BR.LAST_UPDATE_DATE
, BR.LAST_UPDATED_BY
, BR.CREATION_DATE
, BR.CREATED_BY
, BR.LAST_UPDATE_LOGIN
, BR.PURCHASE_ITEM_ID
, BR.FUNCTIONAL_CURRENCY_FLAG
, BR.DEFAULT_ACTIVITY_ID
, BR.RESOURCE_TYPE
, BR.AUTOCHARGE_TYPE
, BR.STANDARD_RATE_FLAG
, BR.DEFAULT_BASIS_TYPE
, BR.ABSORPTION_ACCOUNT
, BR.ALLOW_COSTS_FLAG
, 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
FROM BOM_RESOURCES BR