Product: | BOM - Bills of Material |
---|---|
Description: | View for resource list of values - only enabled records |
Implementation/DBA Data: | APPS.BOM_RESOURCES_VAL_V |
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
WHERE TRUNC(NVL(DISABLE_DATE
, SYSDATE + 1)) > TRUNC(SYSDATE)