PTIAMMCINPBYDB

(SQL View)
Index Back

SELECT DISTINCT C.DBNAME , B.PTIASPPRDID , C.PTIASPPRDCD FROM PS_PTIASPPRD B , PS_PTIASPINSTPRD C WHERE 1=1 AND B.PTIASPPRDCD = C.PTIASPPRDCD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
2 PTIASPPRDID Number(8,0) INTEGER NOT NULL Product ID
3 PTIASPPRDCD Character(8) VARCHAR2(8) NOT NULL Product