INV Item - WIP Attribute Details (Oracle Fusion SQL)

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

This INV Item - Work in Progress Attributes query provides key WIP-related item attributes including supply subinventory, supply locator, overcompletion tolerance, and penalty costs. It supports configuration and tracking of items in manufacturing workflows, ensuring accurate costing and operational control.

#sqlquery

SELECT    
--SQL4Fusion (An Orbit Analytics Project)
--This query retrieves inventory supply details with unit of measure conversions
	HAOU.NAME INVENTORY_ORGANIZATION_NAME,
    ESIB.WIP_SUPPLY_SUBINVENTORY SUPPLY_SUBINVENTORY_CODE,
	ESIB.WIP_SUPPLY_LOCATOR_ID SUPPLY_LOCATOR_ID,
    ESIB.OVERCOMPLETION_TOLERANCE_VALUE OVERCOMPLETION_TOLERANCE,
    ESIB.INVENTORY_CARRY_PENALTY INVENTORY_CARRYING_PENALTY,
    ESIB.OPERATION_SLACK_PENALTY OPERATIONAL_SLACK_PENALTY,
	ESIB.PRIMARY_UOM_CODE PRIMARY_UNIT_OF_MEASURE,
	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(+)