[Home] [Help]
View: MRP_PO_FLEX_FENCES_V
Product: | MRP - Master Scheduling/MRP |
Description: | Purchasing flex fences view |
Implementation/DBA Data: |
APPS.MRP_PO_FLEX_FENCES_V
|
View Text
SELECT DISTINCT SUP.COMPILE_DESIGNATOR
, SUP.INVENTORY_ITEM_ID
, SUP.ORGANIZATION_ID
, SUP.USING_ORGANIZATION_ID
, SUP.SUPPLIER_ID
, SUP.SUPPLIER_SITE_ID
, FENCE.NUMBER_OF_DAYS
, FENCE.TOLERANCE
FROM PO_SUPPLIER_ITEM_TOLERANCE FENCE
, MRP_PO_SUPPLIERS_V SUP
WHERE FENCE.ASL_ID = SUP.ASL_ID
AND FENCE.USING_ORGANIZATION_ID = SUP.USING_ORGANIZATION_ID
Columns
Name |
COMPILE_DESIGNATOR |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
USING_ORGANIZATION_ID |
SUPPLIER_ID |
SUPPLIER_SITE_ID |
DAYS_EARLY |
TOLERANCE |