VIEW: APPS.BOM_RESOURCES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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