VIEW: BOM.BOM_RESOURCES#

Source

View Text - Preformatted

select RESOURCE_ID RESOURCE_ID, RESOURCE_CODE RESOURCE_CODE, ORGANIZATION_ID ORGANIZATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DESCRIPTION DESCRIPTION, DISABLE_DATE DISABLE_DATE, COST_ELEMENT_ID COST_ELEMENT_ID, PURCHASE_ITEM_ID PURCHASE_ITEM_ID, COST_CODE_TYPE COST_CODE_TYPE, FUNCTIONAL_CURRENCY_FLAG FUNCTIONAL_CURRENCY_FLAG, UNIT_OF_MEASURE UNIT_OF_MEASURE, DEFAULT_ACTIVITY_ID DEFAULT_ACTIVITY_ID, RESOURCE_TYPE RESOURCE_TYPE, AUTOCHARGE_TYPE AUTOCHARGE_TYPE, STANDARD_RATE_FLAG STANDARD_RATE_FLAG, DEFAULT_BASIS_TYPE DEFAULT_BASIS_TYPE, ABSORPTION_ACCOUNT ABSORPTION_ACCOUNT, ALLOW_COSTS_FLAG ALLOW_COSTS_FLAG, RATE_VARIANCE_ACCOUNT RATE_VARIANCE_ACCOUNT, EXPENDITURE_TYPE EXPENDITURE_TYPE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, BATCHABLE BATCHABLE, MAX_BATCH_CAPACITY MAX_BATCH_CAPACITY, MIN_BATCH_CAPACITY MIN_BATCH_CAPACITY, BATCH_CAPACITY_UOM BATCH_CAPACITY_UOM, BATCH_WINDOW BATCH_WINDOW, BATCH_WINDOW_UOM BATCH_WINDOW_UOM, COMPETENCE_ID COMPETENCE_ID, RATING_LEVEL_ID RATING_LEVEL_ID, QUALIFICATION_TYPE_ID QUALIFICATION_TYPE_ID, BILLABLE_ITEM_ID BILLABLE_ITEM_ID, SUPPLY_SUBINVENTORY SUPPLY_SUBINVENTORY, SUPPLY_LOCATOR_ID SUPPLY_LOCATOR_ID, BATCHING_PENALTY BATCHING_PENALTY from "BOM"."BOM_RESOURCES"

View Text - HTML Formatted

SELECT RESOURCE_ID RESOURCE_ID
, RESOURCE_CODE RESOURCE_CODE
, ORGANIZATION_ID ORGANIZATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DESCRIPTION DESCRIPTION
, DISABLE_DATE DISABLE_DATE
, COST_ELEMENT_ID COST_ELEMENT_ID
, PURCHASE_ITEM_ID PURCHASE_ITEM_ID
, COST_CODE_TYPE COST_CODE_TYPE
, FUNCTIONAL_CURRENCY_FLAG FUNCTIONAL_CURRENCY_FLAG
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, DEFAULT_ACTIVITY_ID DEFAULT_ACTIVITY_ID
, RESOURCE_TYPE RESOURCE_TYPE
, AUTOCHARGE_TYPE AUTOCHARGE_TYPE
, STANDARD_RATE_FLAG STANDARD_RATE_FLAG
, DEFAULT_BASIS_TYPE DEFAULT_BASIS_TYPE
, ABSORPTION_ACCOUNT ABSORPTION_ACCOUNT
, ALLOW_COSTS_FLAG ALLOW_COSTS_FLAG
, RATE_VARIANCE_ACCOUNT RATE_VARIANCE_ACCOUNT
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, BATCHABLE BATCHABLE
, MAX_BATCH_CAPACITY MAX_BATCH_CAPACITY
, MIN_BATCH_CAPACITY MIN_BATCH_CAPACITY
, BATCH_CAPACITY_UOM BATCH_CAPACITY_UOM
, BATCH_WINDOW BATCH_WINDOW
, BATCH_WINDOW_UOM BATCH_WINDOW_UOM
, COMPETENCE_ID COMPETENCE_ID
, RATING_LEVEL_ID RATING_LEVEL_ID
, QUALIFICATION_TYPE_ID QUALIFICATION_TYPE_ID
, BILLABLE_ITEM_ID BILLABLE_ITEM_ID
, SUPPLY_SUBINVENTORY SUPPLY_SUBINVENTORY
, SUPPLY_LOCATOR_ID SUPPLY_LOCATOR_ID
, BATCHING_PENALTY BATCHING_PENALTY
FROM "BOM"."BOM_RESOURCES"