RA_SO_QUO_COUNT(SQL View) |
Index Back |
---|---|
No. of Customers for a WaveUsed in another View RA_WHATIFQRY_VW for BAM analysis report. List of Order Statuses as of 10/09/02 ..sent by Jon Ruggiero ------------------------------------------------------------------------------------------------ 1 Cancelled 500 Pending 1000 Open 2000 In Process 6000 Complete 8500 Fulfillment Hold 9000 Hold |
SELECT CASE WHEN A.RA_PROMOTION_CODE = ' ' THEN B.RA_PROMOTION_CODE WHEN A.RA_PROMOTION_CODE <> ' ' THEN A.RA_PROMOTION_CODE END ,B.CAPTURE_ID ,A.CAPTURE_TYPE_CD FROM PS_RO_HEADER A , PS_RO_LINE B WHERE (A.RA_PROMOTION_CODE <> ' ' OR B.RA_PROMOTION_CODE <> ' ') AND A.CAPTURE_ID = B.CAPTURE_ID AND A.CAPTURE_TYPE_CD IN ('SO','QUO') AND A.STATUS_CODE <> 1 GROUP BY A.RA_PROMOTION_CODE,B.RA_PROMOTION_CODE, B.CAPTURE_ID,A.CAPTURE_TYPE_CD |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RA_PROMOTION_CODE | Character(35) | VARCHAR2(35) NOT NULL | Marketing - campaign wave promotion code |
2 | CAPTURE_ID | Character(20) | VARCHAR2(20) NOT NULL | Field use to store the capture ID in order capture. |
3 | CAPTURE_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Capture Type
QUO=Quote SO=Order |