INV Item demand history

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