[Home] [Help]
View: MRP_AP_UOM_CLASS_CONVERSIONS_V
Product: | MRP - Master Scheduling/MRP |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT X.INVENTORY_ITEM_ID
, X.FROM_UNIT_OF_MEASURE
, X.FROM_UOM_CODE
, X.FROM_UOM_CLASS
, X.TO_UNIT_OF_MEASURE
, X.TO_UOM_CODE
, X.TO_UOM_CLASS
, X.CONVERSION_RATE
, X.DISABLE_DATE
, 0 RN3
, 0 RN2
, X.RN RN1
FROM MRP_AP_UOM_CLCNVS_SN X
WHERE X.INVENTORY_ITEM_ID= 0 UNION ALL SELECT X.INVENTORY_ITEM_ID
, X.FROM_UNIT_OF_MEASURE
, X.FROM_UOM_CODE
, X.FROM_UOM_CLASS
, X.TO_UNIT_OF_MEASURE
, X.TO_UOM_CODE
, X.TO_UOM_CLASS
, X.CONVERSION_RATE
, X.DISABLE_DATE
, X.RN RN3
, Y.RN2 RN2
, Y.RN1 RN1
FROM MRP_AP_UOM_CLCNVS_SN X
, ( SELECT INVENTORY_ITEM_ID
, MAX( MSI.RN) RN2
, MAX( MP.RN) RN1
FROM MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSI
WHERE MSI.ORGANIZATION_ID= MP.ORGANIZATION_ID GROUP BY INVENTORY_ITEM_ID) Y
WHERE X.INVENTORY_ITEM_ID= Y.INVENTORY_ITEM_ID
Columns
Name |
INVENTORY_ITEM_ID |
FROM_UNIT_OF_MEASURE |
FROM_UOM_CODE |
FROM_UOM_CLASS |
TO_UNIT_OF_MEASURE |
TO_UOM_CODE |
TO_UOM_CLASS |
CONVERSION_RATE |
DISABLE_DATE |
RN3 |
RN2 |
RN1 |