[Home] [Help]
View: MRP_I2_PART_SUPPLIER_V
Product: | MRP - Master Scheduling/MRP |
Description: | A Rhythm view supporting information regarding the approved vendor list as defined in the autosource rules |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PM.PART_NUMBER
, PM.INVENTORY_ITEM_ID
, ISV.ORGANIZATION_ID
, PM.LEADTIME + NVL(PM.POSTPROCESSING_LEADTIME
, 0)
, PM.MINIMUM_ORDER_QUANTITY
, PM.MAXIMUM_ORDER_QUANTITY
, PM.FIXED_DAYS_SUPPLY
, PM.INCREMENTAL_LOT_SIZE
, PM.UOM
, ISV.VENDOR_NAME
FROM MRP_RHX_ITEM_SUPPLIERS_V ISV
, MRP_I2_PART_MASTER_V PM
WHERE PM.ORGANIZATION_ID = ISV.ORGANIZATION_ID
AND PM.INVENTORY_ITEM_ID = ISV. INVENTORY_ITEM_ID
AND NVL(ISV.END_DATE
, MRP_I2_ERP.GET_START_DATE(PM.ORGANIZATION_ID)) > MRP_I2_ERP.GET_START_DATE(PM.ORGANIZATION_ID)
AND ISV.START_DATE <= MRP_I2_ERP.GET_START_DATE(PM.ORGANIZATION_ID) UNION ALL SELECT PM.PART_NUMBER
, PM.INVENTORY_ITEM_ID
, PM.ORGANIZATION_ID
, PM.LEADTIME + NVL(PM.POSTPROCESSING_LEADTIME
, 0)
, PM.MINIMUM_ORDER_QUANTITY
, PM.MAXIMUM_ORDER_QUANTITY
, PM.FIXED_DAYS_SUPPLY
, PM.INCREMENTAL_LOT_SIZE
, PM.UOM
, SUBSTR(MRP_I2_ERP.GET_PARAMETER('MRP_I2_L_UNDEFINED_VENDOR'
, PM.ORGANIZATION_ID
, 1)
, 1
, 80)
FROM MRP_I2_PART_MASTER_V PM
WHERE PM.MAKE_OR_BUY_CODE = 2
AND NOT EXISTS (SELECT NULL
FROM MRP_RHX_ITEM_SUPPLIERS_V ISV
WHERE PM.ORGANIZATION_ID = ISV.ORGANIZATION_ID
AND PM.INVENTORY_ITEM_ID = ISV. INVENTORY_ITEM_ID
AND NVL(ISV.END_DATE
, MRP_I2_ERP.GET_START_DATE(PM.ORGANIZATION_ID)) > MRP_I2_ERP.GET_START_DATE(PM.ORGANIZATION_ID)
AND ISV.START_DATE <= MRP_I2_ERP.GET_START_DATE(PM.ORGANIZATION_ID))
Columns
Name |
PART_NUMBER |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
LEADTIME |
MINIMUM_ORDER_QUANTITY |
MAXIMUM_ORDER_QUANTITY |
FIXED_DAYS_SUPPLY |
INCREMENTAL_LOT_SIZE |
UOM |
VENDOR_NAME |