PC_TIP_VW(SQL View) |
Index Back |
---|---|
SQL ViewUsed to display transactions in progress graphs. |
SELECT A.TIP_STAGE , A.DESCR80 FROM PS_PC_TIP_STG_WRK A , PS_INSTALLATION B WHERE A.AP = B.AP OR A.EX = B.EX OR A.INV = B.INV OR A.PC = B.PC OR A.PO = B.PO OR A.GM = B.GM OR A.GL = B.GL OR A.BI = B.BI OR A.CA = B.CA OR A.AR = B.AR |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TIP_STAGE | Character(7) | VARCHAR2(7) NOT NULL | Transactions In Progress |
2 | DESCR80 | Character(80) | VARCHAR2(80) NOT NULL | Description |