CAPTURE_IDRSF_QTE_ORDR_VW(SQL View) |
Index Back |
|---|
| SELECT CAPTURE_ID , CAPTURE_ID_REL FROM PS_RO_ASSOCIATION A WHERE EXISTS ( SELECT 'X' FROM PS_RO_HEADER B WHERE CAPTURE_TYPE_CD = 'SO' AND A.CAPTURE_ID = B.CAPTURE_ID) AND EXISTS ( SELECT 'X' FROM PS_RO_HEADER C WHERE CAPTURE_TYPE_CD = 'QUO' AND A.CAPTURE_ID_REL = C.CAPTURE_ID) AND TYPE IN ('ROQ2', 'ROQU') |
| # | 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 | CAPTURE_ID_REL | Character(20) | VARCHAR2(20) NOT NULL | This field stores relative capture IDs. |