RSF_RO_LE_PRD_V

(SQL View)
 Index Back

SFA Lead/Oppy OC View

Get all Captures related to a Lead/Oppy

SELECT B.LEAD_ID , C.PRODUCT_ID , C.UNIT_OF_MEASURE , A.CAPTURE_ID , A.DESCR50 , A.STATUS_CODE , A.CAPTURE_TYPE_CD , A.TOTAL_PRICE , A.QUOTE_EXPIRE_DT FROM PS_RO_HEADER A , PS_RO_ASSOCIATION B , PS_RO_LINE C WHERE A.CAPTURE_ID=B.CAPTURE_ID AND B.TYPE = 'SL' AND A.CAPTURE_ID = C.CAPTURE_ID AND A.ROW_LASTMANT_DTTM = ( SELECT MAX(D.ROW_LASTMANT_DTTM) FROM PS_RO_HEADER D , PS_RO_LINE F WHERE D.CAPTURE_ID = F.CAPTURE_ID AND F.CAPTURE_ID = C.CAPTURE_ID AND F.PRODUCT_ID = C.PRODUCT_ID AND F.UNIT_OF_MEASURE = C.UNIT_OF_MEASURE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
3 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
CS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
4 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
6 STATUS_CODE Number(5,0) INTEGER NOT NULL Status Code

Prompt Table: RO_DEFN_HDSTAT

7 CAPTURE_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Capture Type
QUO=Quote
SO=Order

Prompt Table: RO_TYPE

8 TOTAL_PRICE Signed Number(30,4) DECIMAL(28,4) NOT NULL Total Price
9 QUOTE_EXPIRE_DT Date(10) DATE Quote Expire Date