RA_SO_QUO_COUNT

(SQL View)
Index Back

No. of Customers for a Wave

Used 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