Oracle Queries

On Hand Quantity Query in Oracle SCM Cloud

select ESI.ITEM_NUMBER , IODV.ORGANIZATION_NAME, ESI.DESCRIPTION , IOP.ORGANIZATION_CODE , SUM(IOQD.TRANSACTION_QUANTITY) TRX_QTY, UOMT.UNIT_OF_MEASURE , IOQD.SUBINVENTORY_CODE , IOQD.LOT_NUMBER, IIL.SEGMENT1, IIL.SEGMENT2, IIL.SEGMENT3, IIL.SEGMENT4 from INV_ONHAND_QUANTITIES_DETAIL IOQD , EGP_SYSTEM_ITEMS ESI…
July 22, 2020