[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 |