PV_DC_XREF_VW

(SQL View)
 Index Back

Direct Connect Suppliers View


SELECT A.MSGNODENAME FROM PS_PV_NODES A WHERE A.PROPNAME = 'KEYWORDS' UNION SELECT PV_TPO_NODE FROM PS_PV_MS_SUPPLIER WHERE PV_TPO_NODE <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MERCHANTID Character(30) VARCHAR2(30) NOT NULL Merchant ID