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
 
LOV Oracle
To
 
Items From
 
To
 
Categories From
 
Category Set
 
LOV Oracle