[Home] [Help]
View: IBE_SH_SHP_LIST_ITEMS_V
Product: | IBE - iStore |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SSI.SHP_LIST_ITEM_ID
, SSI.SHP_LIST_ID
, SSI.INVENTORY_ITEM_ID
, SSI.ORGANIZATION_ID
, SSI.UOM_CODE
, SSI.QUANTITY
, MSI.DESCRIPTION
, MSI.CONCATENATED_SEGMENTS
, MUM.UNIT_OF_MEASURE
FROM IBE_SH_SHP_LIST_ITEMS SSI
, MTL_SYSTEM_ITEMS_VL MSI
, MTL_UNITS_OF_MEASURE_VL MUM
WHERE SSI.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND SSI.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND SSI.UOM_CODE = MUM.UOM_CODE
Columns
Name |
SHP_LIST_ITEM_ID |
SHP_LIST_ID |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
UOM_CODE |
QUANTITY |
DESCRIPTION |
CONCATENATED_SEGMENTS |
UNIT_OF_MEASURE |