PROBINSTCAPTURE_IDRO_SLD_2_RGN_VW(SQL View) |
Index Back |
|---|---|
Sold to Region ViewInput view for Sold to Region - Order Capture ACE report |
| SELECT K.PROBINST , E.CAPTURE_ID , C.REGION_ID FROM PS_BO_SRCH_ADD C , PS_RO_BOID D , PS_RO_HEADER E , PS_RO_BAM_RUN_CTL J , PS_RO_BAM_RUN_INST K WHERE D.CAPTURE_ID = E.CAPTURE_ID AND E.UID20F_SOLD = D.UID20 AND D.BO_ID = C.BO_ID AND D.PROFILE_CM_SEQ = C.PROFILE_CM_SEQ AND C.ROLE_TYPE_ID = D.ROLE_TYPE_ID AND J.OPRID=K.OPRID AND J.RUN_CNTL_ID=K.RUN_CNTL_ID AND E.CAPTURE_DATE >= J.START_DATE AND E.CAPTURE_DATE <= J.END_DATE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | CAPTURE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Field use to store the capture ID in order capture. |
| 3 | REGION_ID | Character(15) | VARCHAR2(15) NOT NULL | This field stores the region id value. |