FND Design Data [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