RO_SLD2RGN_VW (SQL View)	Index Back
Sold to Region This view is used by Interactive Reports to help BAM query for Order Revenue and Order Metrics

RO_SLD2RGN_VW

(SQL View)

Sold to Region

This view is used by Interactive Reports to help BAM query for Order Revenue and Order Metrics

SELECT K.PROBINST , E.CAPTURE_ID , C.REGION_ID FROM PS_BO_SRCH_ADD C , PS_RO_BOID D , PS_RO_HEADER E , PS_RO_BAM_RUN_CTL J , PS_RO_BAM_OM_INST K WHERE D.CAPTURE_ID = E.CAPTURE_ID AND E.UID20F_SOLD = D.UID20 AND D.BO_ID = C.BO_ID AND D.PROFILE_CM_SEQ = C.PROFILE_CM_SEQ AND C.ROLE_TYPE_ID = D.ROLE_TYPE_ID AND J.OPRID=K.OPRID AND J.RUN_CNTL_ID=K.RUN_CNTL_ID AND E.CAPTURE_DATE >= J.START_DATE AND E.CAPTURE_DATE <= J.END_DATE

# 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 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.

#	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	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value.