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
Description: Item demand history report
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 | |
---|---|---|---|
Category Set |
|
LOV Oracle | |
Categories From |
|
Char | |
To |
|
Char | |
Items From |
|
Char | |
To 2 |
|
Char | |
Bucket Type |
|
LOV Oracle | |
History Start Date |
|
Date |