[Home] [Help]
View: MRP_AP_VENDORS_V
| Product: | MRP - Master Scheduling/MRP |
| Description: | |
| Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SN.VENDOR_ID SR_TP_ID
, SN.VENDOR_END_DATE_ACTIVE DISABLE_DATE
, 1 PARTNER_TYPE
, SN.VENDOR_NAME PARTNER_NAME
, V.VENDOR_NUMBER PARTNER_NUMBER
, SN.RN RN1
FROM MRP_AP_VENDORS_SN SN
, PO_VENDORS_VIEW V
WHERE V.VENDOR_ID= SN.VENDOR_ID
Columns
| Name |
| SR_TP_ID |
| DISABLE_DATE |
| PARTNER_TYPE |
| PARTNER_NAME |
| PARTNER_NUMBER |
| RN1 |