[Home] [Help]
View: CST_XLA_RES_OVH_REF_V
View Text
SELECT BR.RESOURCE_ID
, BR.RESOURCE_CODE
, BR.DESCRIPTION
, CCE.COST_ELEMENT
, BR.PURCHASE_ITEM_ID
, BR.FUNCTIONAL_CURRENCY_FLAG
, BR.RESOURCE_TYPE
, 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.ABSORPTION_ACCOUNT
FROM BOM_RESOURCES BR
, CST_COST_ELEMENTS CCE
WHERE BR.COST_ELEMENT_ID = CCE.COST_ELEMENT_ID
Columns
Name |
RESOURCE_ID |
RESOURCE_CODE |
RES_DESCRIPTION |
RES_COST_ELEMENT |
RES_PURCHASE_ITEM_ID |
RES_FUNC_CURRENCY_FLAG |
RES_TYPE |
RES_EXPENDITURE_TYPE |
RES_ATTRIBUTE_CATEGORY |
RES_ATTRIBUTE1 |
RES_ATTRIBUTE2 |
RES_ATTRIBUTE3 |
RES_ATTRIBUTE4 |
RES_ATTRIBUTE5 |
RES_ATTRIBUTE6 |
RES_ATTRIBUTE7 |
RES_ATTRIBUTE8 |
RES_ATTRIBUTE9 |
RES_ATTRIBUTE10 |
RES_ATTRIBUTE11 |
RES_ATTRIBUTE12 |
RES_ATTRIBUTE13 |
RES_ATTRIBUTE14 |
RES_ATTRIBUTE15 |
RES_OVH_ABSORPTION_ACCT |