Skip to main content
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…
admin
July 22, 2020
Support

SQLConnect Shortcuts

Here is a list of shortcuts - keystroke combinations - that can help you do a number of tasks quickly in OracleCloudTools SQLConnect applications. For…
admin
May 15, 2020