PTIASPTRANOLYVW

(SQL View)
 Index Back

Translation Language List


SELECT DISTINCT C.PTIASPRPTTAGVALUE , B.DBNAME , 'N' FROM PSXLATITEM A , PS_PTIASPTARGETLNG B , PS_PTIASPRPTTAGS C WHERE A.FIELDNAME = 'LANGUAGE_CD' AND A.FIELDVALUE = B.LANGUAGE_CD AND C.PTIASPRPTTAGNAME = 'Translations Only' AND C.PTIASPRPTTAGVALUE != 'Required At Upgrade' AND A.FIELDVALUE = C.PTIASPRPTTAGVALUE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIASPRPTTAGVALUE Character(254) VARCHAR2(254) NOT NULL TAG Value
2 DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
3 PTIASPSELECTTRANS Character(1) VARCHAR2(1) NOT NULL Translations Only flag

Default Value: N