CO_VOLBEN_VW (SQL View)	Index Back
VOLBEN Cat Supplier VW Selects suppliers where the merchant enabled is checked 'y' and the category is 'VOLBEN'

CO_VOLBEN_VW

(SQL View)

VOLBEN Cat Supplier VW

Selects suppliers where the merchant enabled is checked 'y' and the category is 'VOLBEN'

SELECT A.MERCHANTID FROM PSMERCHANTID A , PSMERCHANTCAT B WHERE A.MERCHANTID = B.MERCHANTID AND A.MERCHINSTALLED = 'Y' AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PSMERCHANTID C WHERE C.MERCHANTID = B.MERCHANTID AND C.EFFDT <= %CurrentDateIn) AND B.MERCHANTCAT = 'DISPRK'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MERCHANTID Character(30) VARCHAR2(30) NOT NULL Merchant ID