INV Item demand history

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Item demand history report (XML)
Short Name: INVPRFDH_XML
DB package: INV_INVPRFDH_XMLP_PKG
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
Precision
 
LOV Oracle
Category Structure
 
Number
Organization
 
Number
History Start Date
 
Date
Bucket Type