SETIDINST_PROD_IDRO_QUED_IPRD_VW(SQL View) |
Index Back |
|---|---|
Related orders viewThis is a view that shows related orders. |
| SELECT iprod.SETID ,iprod.INST_PROD_ID , hdr.CAPTURE_ID , hdr.DESCR50 , hdr.STATUS_CODE , hdr.CAPTURE_DATE , hdr.DUE_DATE , hdr.RO_EXEC_DATE ,line.STATUS_CODE FROM PS_RO_HEADER hdr , PS_RO_LINE line , PS_RF_INST_PROD iprod WHERE hdr.CAPTURE_ID = line.CAPTURE_ID AND hdr.STATUS_CODE IN (950,1000) AND line.INST_PROD_ID=iprod.INST_PROD_ID AND line.STATUS_CODE IN (1000,2000) AND line.INST_PROD_ID <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | INST_PROD_ID |
Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the installed product ID (key field) |
| 3 | CAPTURE_ID | Character(20) | VARCHAR2(20) NOT NULL | Field use to store the capture ID in order capture. |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | STATUS_CODE | Number(5,0) | INTEGER NOT NULL | Status Code |
| 6 | CAPTURE_DATE | Date(10) | DATE | Order capture date used for orders and quotes |
| 7 | DUE_DATE | Date(10) | DATE | Delivery Due Date from PO |
| 8 | RO_EXEC_DATE | Date(10) | DATE | Field to control the execution date of the business projects for the order. Used by Future Dated Orders. |
| 9 | LINE_STATUS_CODE | Number(5,0) | INTEGER NOT NULL | Status Code |