XX_BAD_VIEW_VW(SQL View) |
Index Back |
|---|---|
Internal Utiltiy - Bad ViewInternal utility for CRM development |
| SELECT R1.RECNAME , R1.DEPTH , R1.BUILDSEQNO , R2.RECNAME , R2.DEPTH , R2.BUILDSEQNO FROM PS_XX_RECORD_REL REL , PS_XX_RECNAME R1 , PS_XX_RECNAME R2 WHERE R1.RECNAME = REL.RECNAME1 AND R2.RECNAME = REL.RECNAME2 AND R2.RECTYPE = 1 AND R1.BUILDSEQNO <= R2.BUILDSEQNO |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME1 | Character(15) | VARCHAR2(15) NOT NULL | Record Name 1 |
| 2 | DEPTH1 | Number(3,0) | SMALLINT NOT NULL | Depth |
| 3 | BUILDSEQNO1 | Number(5,0) | INTEGER NOT NULL | Sequence Number for build. |
| 4 | RECNAME2 | Character(15) | VARCHAR2(15) NOT NULL | Record Name |
| 5 | DEPTH2 | Number(3,0) | SMALLINT NOT NULL | Depth |
| 6 | BUILDSEQNO2 | Number(5,0) | INTEGER NOT NULL | Sequence Number for build. |