[Home] [Help]
View: MRP_AP_CUSTOMER_SITES_V
Product: | MRP - Master Scheduling/MRP |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT RC.CUSTOMER_NAME TP_NAME
, RSUA.SITE_USE_CODE TP_SITE_CODE
, RC.CUSTOMER_ID SR_TP_ID
, RSUA.SITE_USE_ID SR_TP_SITE_ID
, RSUA.LOCATION
, RAA.ADDRESS1||'
, '||RAA.ADDRESS2||'
, '||RAA.ADDRESS3||'
, '||RAA.ADDRESS4||'
, '|| RAA.CITY||'
, '||RAA.STATE||'
, '||RAA.POSTAL_CODE||'
, '||RAA.PROVINCE||'
, '|| RAA.COUNTRY PARTNER_ADDRESS
, 2 PARTNER_TYPE
, RSUA.RN RN3
, RAA.RN RN2
, RC.RN RN1
FROM MRP_AP_RA_CSTMS_SN RC
, MRP_AP_RA_ADDRS_SN RAA
, MRP_AP_RA_SITES_SN RSUA
WHERE RSUA.ADDRESS_ID= RAA.ADDRESS_ID
AND RAA.CUSTOMER_ID= RC.CUSTOMER_ID
Columns
Name |
TP_NAME |
TP_SITE_CODE |
SR_TP_ID |
SR_TP_SITE_ID |
LOCATION |
PARTNER_ADDRESS |
PARTNER_TYPE |
RN3 |
RN2 |
RN1 |