INV Item - Order Management Attributes (Oracle Fusion SQL)

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

This INV item - order management attributes query retrieves comprehensive attributes of inventory items relevant to order management, including indicators such as customer order eligibility, returnability, sales product classification, and shipping status.

#sqlquery

SELECT
  --SQL4Fusion (An Orbit Analytics Project)
  --This query provides detailed attributes of inventory items related to order management.
  HAOU.NAME ORGANIZATION_NAME,
  ESIB.ITEM_NUMBER,
  ESIB.ATP_COMPONENTS_FLAG ITEM_ATP_COMPONENTS,
  ESIB.ATP_FLAG ITEM_CHECK_ATP,
  ESIB.CUSTOMER_ORDER_ENABLED_FLAG ITEM_CUSTOMER_ORDER_ENABLED,
  ESIB.CUSTOMER_ORDER_FLAG CUSTOMER_ORDERED_ITEM,
  ESIB.ELIGIBILITY_COMPATIBILITY_RULE,
  ESIB.INTERNAL_ORDER_ENABLED_FLAG ITEM_INTERNAL_ORDER_ENABLED,
  ESIB.INTERNAL_ORDER_FLAG INTERNAL_ORDERED_ITEM,
  ESIB.PICK_COMPONENTS_FLAG ITEM_PICK_COMPONENT_FLAG,
  ESIB.RETURNABLE_FLAG ITEM_RETURNABLE,
  ESIB.SALES_PRODUCT_TYPE,
  ESIB.SHIP_MODEL_COMPLETE_FLAG ITEM_SHIP_MODEL_COMPLETE,
  ESIB.SHIPPABLE_ITEM_FLAG SHIPPABLE_ITEM,
  ESIB.PRIMARY_UOM_CODE,
  IIUV.UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE,
  IIUV.UOM_TYPE SECONDARY_UOM_TYPE,
  IIUV.DESCRIPTION SECONDARY_UOM_DESCRIPTION,
  ESIB.SECONDARY_DEFAULT_IND  ITEM_DEFAULTING_CONTROL,
  ESIB.DUAL_UOM_DEVIATION_HIGH,
  ESIB.DUAL_UOM_DEVIATION_LOW,
  ESIB.INVENTORY_ITEM_STATUS_CODE
FROM
  HR_ALL_ORGANIZATION_UNITS HAOU,
  EGP_SYSTEM_ITEMS_B ESIB,  
  INV_ITEM_UOMS_V IIUV
WHERE
  1 = 1
  AND HAOU.ORGANIZATION_ID = ESIB.ORGANIZATION_ID
  AND ESIB.INVENTORY_ITEM_ID =IIUV.INVENTORY_ITEM_ID(+) 
  AND ESIB.SECONDARY_UOM_CODE = IIUV.UOM_CODE(+)