[Home] [Help]
View: MRP_I2_ONHAND_INVENTORY_V
Product: | MRP - Master Scheduling/MRP |
Description: | A Rhythm view supporting information regarding onhand inventory |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PM.PART_NUMBER
, PM.ORGANIZATION_ID
, GREATEST(SUM(Q.NETTABLE_QUANTITY)
, 0)
, Q.ATTRIBUTE_ALIAS
FROM MRP_RHX_ONHAND_QUANTITIES_V Q
, MRP_I2_PART_MASTER_V PM
WHERE MRP_I2_ERP.GET_PARAMETER('SCHEDULING_ONLY'
, PM.ORGANIZATION_ID) <> 'Y'
AND Q.AVAILABILITY_TYPE = 1
AND Q.ORGANIZATION_ID = PM.ORGANIZATION_ID
AND Q.INVENTORY_ITEM_ID = PM.INVENTORY_ITEM_ID GROUP BY PM.PART_NUMBER
, PM.ORGANIZATION_ID
, Q.ATTRIBUTE_ALIAS
Columns
Name |
PART_NUMBER |
ORGANIZATION_ID |
QOH |
ATTRIBUTE_ALIAS |