RO_QUO_CONV_VW

(SQL View)
 Index Back

Is Quote Converted Order?

Input view for Enterprise Order Revenue ACE report. This is for all business units.

SELECT K.PROBINST , A.CAPTURE_ID , 1 FROM PS_RO_HEADER A , PS_RO_ASSOCIATION B , PS_RO_BAM_RUN_CTL D , PS_RO_BAM_RUN_INST K WHERE A.CAPTURE_ID = B.CAPTURE_ID AND A.CAPTURE_TYPE_CD = 'QUO' AND B.TYPE IN ('ROSO','ROS2') AND A.CAPTURE_DATE >= D.START_DATE AND A.CAPTURE_DATE <= D.END_DATE AND A.BULK_ORDER_FLAG <> 'Y' AND EXISTS ( SELECT 'X' FROM PS_RO_HEADER C , PS_RO_ASSOCIATION D , PS_RO_BAM_RUN_CTL X WHERE C.CAPTURE_ID = D.CAPTURE_ID_REL AND C.CAPTURE_TYPE_CD = 'SO' AND C.CAPTURE_DATE >= X.START_DATE AND C.CAPTURE_DATE <= X.END_DATE AND C.ROW_ADDED_DTTM >= A.ROW_ADDED_DTTM AND C.BUSINESS_UNIT = X.BUSINESS_UNIT ) AND D.OPRID=K.OPRID AND D.RUN_CNTL_ID=K.RUN_CNTL_ID

# 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 TOTAL_COUNT Number(7,0) INTEGER NOT NULL Total Count