[Home] [Help]
View: MRP_AP_SUPPLIER_CAPACITIES_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
, PSIC.FROM_DATE
, PSIC.TO_DATE
, PSIC.CAPACITY_PER_DAY CAPACITY
, PSIC.RN RN5
, MAPSV.RN4 RN4
, MAPSV.RN3 RN3
, MAPSV.RN2 RN2
, MAPSV.RN1 RN1
FROM MRP_AP_PO_SUPPLIERS_V MAPSV
, MRP_AP_SUPP_ICAP_SN PSIC
WHERE PSIC.ASL_ID= MAPSV.ASL_ID
AND PSIC.USING_ORGANIZATION_ID= MAPSV.USING_ORGANIZATION_ID
Columns
| Name |
| INVENTORY_ITEM_ID |
| ORGANIZATION_ID |
| USING_ORGANIZATION_ID |
| VENDOR_ID |
| VENDOR_SITE_ID |
| FROM_DATE |
| TO_DATE |
| CAPACITY |
| RN5 |
| RN4 |
| RN3 |
| RN2 |
| RN1 |