INV Item demand history

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Item demand history report
Application: Inventory
Source: Item demand history report (XML)
Short Name: INVPRFDH_XML
DB package: INV_INVPRFDH_XMLP_PKG
Run INV Item demand history and other Oracle EBS reports with Blitz Report™ on our demo environment
select 
  null      ITEM_FLEXDAT,
  msi.concatenated_segments          item,
  msi.DESCRIPTION,
  msi.PRIMARY_UOM_CODE    uom,
  mdh.PERIOD_START_DATE   starting_date,
  mdh.SALES_ORDER_DEMAND  sales_orders,
  mdh.INTERORG_ISSUE      interorg_issues,
  mdh.STD_WIP_USAGE       WIP_issues,
  mdh.MISCELLANEOUS_ISSUE miscellaneous_issues, 
	INV_INVPRFDH_XMLP_PKG.f_totalformula(mdh.SALES_ORDER_DEMAND, mdh.INTERORG_ISSUE, mdh.STD_WIP_USAGE, mdh.MISCELLANEOUS_ISSUE) F_Total
from  mtl_system_items_kfv                msi,
         MTL_DEMAND_HISTORIES  mdh
where 
 msi.INVENTORY_ITEM_ID  = mdh.INVENTORY_ITEM_ID
and    mdh.ORGANIZATION_ID = :P_org
and    mdh.PERIOD_TYPE           = :P_period_type
and    msi.ORGANIZATION_ID   = :p_org
and  (  (:p_start_date is NOT NULL and 
          mdh.PERIOD_START_DATE >=  :p_start_date
        )  OR 
        ( :p_start_date is NULL ) 
        ) 
AND  &P_ITEM_WHERE
&C_CAT_WHERE
order by  
&P_ITEM_FLEXORD  ,
MDH.PERIOD_START_DATE DESC
Parameter Name SQL text Validation
Category Set 
 
 LOV Oracle
Categories From 
 
 Char
To 
 
 Char
Items From 
 
 Char
To 2 
 
 Char
Bucket Type 
 
 LOV Oracle
History Start Date 
 
 Date
Download
Related Blitz Reports
ECC Inventory Management, Inventory Trace Sales Orders WIP Required Components PO Headers and Lines 11i XXT OF: PO Headers and Lines ECC Discrete Manufacturing, Work Orders INV Min-max planning ECC Discrete Completions, Assembly Completion Transactions INV Item Supply/Demand ECC Project Manufacturing Genealogy & Trace, Sales Orders
Blitz Report™

Blitz Report™ provides multiple benefits: