PTIASPRPTNOPrompt Table: PTIASPRPTHEAD
LANGUAGE_CDPTIASPTFPBUGSVW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIASPRPTNO |
Number(10,0) | DECIMAL(10) NOT NULL |
BUG Number
Prompt Table: PTIASPRPTHEAD |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | PTIASPSPVERS | Number(5,0) | INTEGER NOT NULL | Numeric value for Patch Database Version Number |