eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MRP_RHX_FIRM_PLANNED_ORDERS_V

Product:	MRP - Master Scheduling/MRP
Description:	An Integration Toolkit view supporting the information for firm planned orders
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT RECOM.TRANSACTION_ID
, ITEM.ITEM_NUMBER
, ITEM.INVENTORY_ITEM_ID
, RECOM.ORGANIZATION_ID
, RECOM.NEW_WIP_START_DATE
, RECOM.FIRM_DATE
, RECOM.FIRM_QUANTITY - NVL(RECOM.IMPLEMENTED_QUANTITY
, 0)
, RECOM.ALTERNATE_BOM_DESIGNATOR
, RECOM.ALTERNATE_ROUTING_DESIGNATOR
, RECOM.COMPILE_DESIGNATOR
, LUP.MEANING
FROM MRP_RECOMMENDATIONS RECOM
, MRP_RHX_PLANNED_ITEMS_V ITEM
, MFG_LOOKUPS LUP
WHERE RECOM.ORDER_TYPE = 5
AND RECOM.FIRM_PLANNED_TYPE = 1
AND ITEM.INVENTORY_ITEM_ID = RECOM.INVENTORY_ITEM_ID
AND ITEM.ORGANIZATION_ID = RECOM.ORGANIZATION_ID
AND LUP.LOOKUP_CODE = 5
AND UPPER(LUP.LOOKUP_TYPE) = 'MRP_ORDER_TYPE'
AND RECOM.FIRM_QUANTITY - NVL(RECOM.IMPLEMENTED_QUANTITY
, 0) > 0

Columns

Name
TRANSACTION_ID
ITEM_NUMBER
INVENTORY_ITEM_ID
ORGANIZATION_ID
NEW_WIP_START_DATE
FIRM_DATE
FIRM_QUANTITY
ALTERNATE_BOM_DESIGNATOR
ALTERNATE_ROUTING_DESIGNATOR
COMPILE_DESIGNATOR
JOB_TYPE_MEANING