[Home] [Help]
View: MRP_AP_UOM_CONVERSIONS_V
Product: | MRP - Master Scheduling/MRP |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT X.UNIT_OF_MEASURE
, X.UOM_CODE
, X.UOM_CLASS
, X.INVENTORY_ITEM_ID
, X.CONVERSION_RATE
, X.DEFAULT_CONVERSION_FLAG
, X.DISABLE_DATE
, 0 RN3
, 0 RN2
, X.RN RN1
FROM MRP_AP_UOM_CNVS_SN X
WHERE X.INVENTORY_ITEM_ID= 0 UNION ALL SELECT X.UNIT_OF_MEASURE
, X.UOM_CODE
, X.UOM_CLASS
, X.INVENTORY_ITEM_ID
, X.CONVERSION_RATE
, X.DEFAULT_CONVERSION_FLAG
, X.DISABLE_DATE
, X.RN RN3
, Y.RN2 RN2
, Y.RN1 RN1
FROM MRP_AP_UOM_CNVS_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 |
UNIT_OF_MEASURE |
UOM_CODE |
UOM_CLASS |
INVENTORY_ITEM_ID |
CONVERSION_RATE |
DEFAULT_CONVERSION_FLAG |
DISABLE_DATE |
RN3 |
RN2 |
RN1 |