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