[Home] [Help]
View: WIP_OSP_RESOURCES_VAL_V
View Text
SELECT WOR.WIP_ENTITY_ID
, WOR.ORGANIZATION_ID
, WOR.OPERATION_SEQ_NUM
, WOR.REPETITIVE_SCHEDULE_ID
, WOR.RESOURCE_SEQ_NUM
, WOR.RESOURCE_ID
, WOR.USAGE_RATE_OR_AMOUNT
, BR.RESOURCE_CODE
, BR.UNIT_OF_MEASURE
, BR.COST_ELEMENT_ID
, BR.DESCRIPTION
FROM BOM_RESOURCES BR
, WIP_OPERATION_RESOURCES WOR
WHERE WOR.RESOURCE_ID = BR.RESOURCE_ID
AND WOR.AUTOCHARGE_TYPE IN (3
, 4)
Columns
Name |
WIP_ENTITY_ID |
ORGANIZATION_ID |
OPERATION_SEQ_NUM |
REPETITIVE_SCHEDULE_ID |
RESOURCE_SEQ_NUM |
RESOURCE_ID |
USAGE_RATE_OR_AMOUNT |
RESOURCE_CODE |
UNIT_OF_MEASURE |
COST_ELEMENT_ID |
DESCRIPTION |