INV Item - Web Option Attribute Details (Oracle Fusion SQL)

Supply Chain & Manufacturing (SCM) Inventory (INV-Fusion-SQL's)
1

This INV Item - Web Option Attributes query presents web-related attributes for inventory items, such as minimum license quantities, dual UOM setup, and unit of measure details. It helps track and manage items intended for e-commerce or digital transactions.

#sqlquery

SELECT
--SQL4Fusion (An Orbit Analytics Project)
--Displays item configuration attributes relevant to web sales and licensing.
	HAOU.NAME INVENTORY_ORGANIZATION_NAME,
    ESIB.MINIMUM_LICENSE_QUANTITY,
    ESIB.PRIMARY_UOM_CODE,
    IIUV.UNIT_OF_MEASURE SECONDARY_UOM_CODE,
    ESIB.SECONDARY_DEFAULT_IND IS_SECONDARY_UOM_DEFAULT,
	ESIB.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_HIGH_DEVIATION,
	ESIB.DUAL_UOM_DEVIATION_LOW DUAL_UOM_LOW_DEVIATION,
    ESIB.INVENTORY_ITEM_STATUS_CODE ITEM_STATUS_CODE,
    ESIB.CREATION_DATE ITEM_CREATION_DATE,
    ESIB.INVENTORY_ITEM_ID,
    HAOU.ORGANIZATION_ID INVENTORY_ORG_ID
FROM
    EGP_SYSTEM_ITEMS_B          ESIB,
    HR_ALL_ORGANIZATION_UNITS   HAOU,
	INV_ITEM_UOMS_V             IIUV
WHERE 1=1
	AND HAOU.ORGANIZATION_ID        =       ESIB.ORGANIZATION_ID
    AND IIUV.INVENTORY_ITEM_ID(+)   =       ESIB.INVENTORY_ITEM_ID
    AND ESIB.SECONDARY_UOM_CODE     =       IIUV.UOM_CODE(+)