[Home] [Help]
View: MRP_AP_SUPPLIER_FLEX_FENCES_V
| Product: | MRP - Master Scheduling/MRP |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT MAPSV.INVENTORY_ITEM_ID
, MAPSV.ORGANIZATION_ID
, MAPSV.USING_ORGANIZATION_ID
, MAPSV.VENDOR_ID
, MAPSV.VENDOR_SITE_ID
, PSIT.NUMBER_OF_DAYS FENCE_DAYS
, PSIT.TOLERANCE TOLERANCE_PERCENTAGE
, PSIT.RN RN5
, MAPSV.RN4 RN4
, MAPSV.RN3 RN3
, MAPSV.RN2 RN2
, MAPSV.RN1 RN1
FROM MRP_AP_PO_SUPPLIERS_V MAPSV
, MRP_AP_SUPP_ITOL_SN PSIT
WHERE PSIT.ASL_ID= MAPSV.ASL_ID
AND PSIT.USING_ORGANIZATION_ID= MAPSV.USING_ORGANIZATION_ID
Columns
| Name |
| INVENTORY_ITEM_ID |
| ORGANIZATION_ID |
| USING_ORGANIZATION_ID |
| VENDOR_ID |
| VENDOR_SITE_ID |
| FENCE_DAYS |
| TOLERANCE_PERCENTAGE |
| RN5 |
| RN4 |
| RN3 |
| RN2 |
| RN1 |