PTIASPTFPBUGSVW |
index back |
---|
SELECT BUG.PTIASPRPTNO ,T1.PTIASPRPTTAGVALUE ,TO_NUMBER(T2.PTIASPRPTTAGVALUE) FROM PS_PTIASPRPTHEAD BUG , PS_PTIASPRPTTAGS T1 , PS_PTIASPRPTTAGS T2 WHERE BUG.PTIASPRPTNO = T1.PTIASPRPTNO AND BUG.PTIASPRPTNO = T2.PTIASPRPTNO AND T1.PTIASPRPTTAGNAME = 'Translations Fix Pack' AND T2.PTIASPRPTTAGNAME = 'TFPImage' |
PeopleSoft Field Name | Field Type | Column Type | Description |
---|---|---|---|
![]() |
Number(10,0) | DECIMAL(10) NOT NULL |
BUG Number
Prompt Table: PTIASPRPTHEAD |
![]() |
Character(3) | VARCHAR2(3) NOT NULL | Language Code translate values |
PTIASPSPVERS | Number(5,0) | INTEGER NOT NULL | Numeric value for Patch Database Version Number |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |