RO_QUOT_PROP_VW(SQL View) |
Index Back |
|---|---|
Quote Proposal ViewView of quotes joined to the proposal in RO_ASSOCIATION, for all non-expired quotes. Used in the AE job to expire quotes. |
| SELECT A.CAPTURE_ID , A.STATUS_CODE ,A.QUOTE_EXPIRE_DT , B.PROPOSAL_ID , B.VERSION_ID , B.UID20F_LINE FROM PS_RO_HEADER A , PS_RO_ASSOCIATION B WHERE A.CAPTURE_TYPE_CD='QUO' AND A.QUOTE_EXPIRE_DT >= %CurrentDateIn AND A.CAPTURE_ID=B.CAPTURE_ID AND B.TYPE='PROP' AND A.STATUS_CODE <> 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAPTURE_ID | Character(20) | VARCHAR2(20) NOT NULL | Field use to store the capture ID in order capture. |
| 2 | STATUS_CODE | Number(5,0) | INTEGER NOT NULL | Status Code |
| 3 | QUOTE_EXPIRE_DT | Date(10) | DATE | Quote Expire Date |
| 4 | PROPOSAL_ID | Character(25) | VARCHAR2(25) NOT NULL | This field is used to store the proposal ID. |
| 5 | VERSION_ID | Character(7) | VARCHAR2(7) NOT NULL | Version ID of Proposal |
| 6 | UID20F_LINE | Character(20) | VARCHAR2(20) NOT NULL | Foreign UID................................................................... |