RBB_BPEL_INST_IDQUO=Quote
SO=Order
RBF_RO_BPLINSTV(SQL View) |
Index Back |
|---|---|
Capture Business ProcessView Order Capture bpel instances |
| SELECT bpel.RBB_BPEL_INST_ID , hdr.RBB_TRNSTYPE_ID , bpel.CAPTURE_ID , bpel.CAPTURE_TYPE_CD FROM PS_RBB_RO_BPLINST bpel , PS_RBB_INST_HDR hdr WHERE bpel.RBB_BPEL_INST_ID = hdr.RBB_BPEL_INST_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RBB_BPEL_INST_ID |
Character(100) | VARCHAR2(100) NOT NULL | Business Process Instance ID |
| 2 | RBB_TRNSTYPE_ID | Character(25) | VARCHAR2(25) NOT NULL | Field to store Transaction Type ID |
| 3 | CAPTURE_ID | Character(20) | VARCHAR2(20) NOT NULL | Field use to store the capture ID in order capture. |
| 4 | CAPTURE_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Capture Type
QUO=Quote SO=Order |