[Home] [Help]
View: MRP_AP_VENDOR_SITES_V
Product: | MRP - Master Scheduling/MRP |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PVV.VENDOR_NAME TP_NAME
, PVSA.VENDOR_SITE_CODE TP_SITE_CODE
, PVSA.VENDOR_ID SR_TP_ID
, PVSA.VENDOR_SITE_ID SR_TP_SITE_ID
, PVSA.ADDRESS_LINE1||'
, '||PVSA.ADDRESS_LINE2||'
, '||PVSA.ADDRESS_LINE3||'
, '|| PVSA.ADDRESS_LINE4||'
, '||PVSA.CITY||'
, '||PVSA.STATE||'
, '||PVSA.ZIP||'
, '|| PVSA.PROVINCE||'
, '||PVSA.COUNTRY PARTNER_ADDRESS
, 1 PARTNER_TYPE
, PVSA.RN RN2
, PVV.RN RN1
FROM MRP_AP_VNDR_SITES_SN PVSA
, MRP_AP_VENDORS_SN PVV
WHERE PVSA.VENDOR_ID= PVV.VENDOR_ID
Columns
Name |
TP_NAME |
TP_SITE_CODE |
SR_TP_ID |
SR_TP_SITE_ID |
PARTNER_ADDRESS |
PARTNER_TYPE |
RN2 |
RN1 |