[Home] [Help]
View: BOM_MIXED_MODEL_MAP_RES_V
View Text
SELECT BMMMR.MIXED_MODEL_MAP_ID
, BMMMR.RESOURCE_ID
, BMMMR.RESOURCE_CODE
, BMMMR.ACTIVITY_ID
, BMMMR.ACTIVITY
, BMMMR.STANDARD_OPERATION_ID
, BMMMR.OPERATION_CODE
, BMMMR.ORGANIZATION_ID
, BMMMR.RESOURCE_TYPE
, LU.MEANING
, ROUND(BMMMR.RESOURCE_NEEDED
, 2)
FROM BOM_MIXED_MODEL_MAP_RES BMMMR
, MFG_LOOKUPS LU
WHERE LU.LOOKUP_CODE(+) = BMMMR.RESOURCE_TYPE
AND LU.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'
Columns
Name |
MIXED_MODEL_MAP_ID |
RESOURCE_ID |
RESOURCE_CODE |
ACTIVITY_ID |
ACTIVITY |
STANDARD_OPERATION_ID |
OPERATION_CODE |
ORGANIZATION_ID |
RESOURCE_TYPE |
RESOURCE_TYPE_DISP |
RESOURCE_NEEDED |