RO_BAM_REGION

(SQL View)
 Index Back

Get sold to customer region id

This view gives the Sold to Customer Region identification numbers.

SELECT H.CAPTURE_ID , A.REGION_ID , R.DESCR FROM PS_RO_HEADER H , PS_RO_BOID B , PS_BO_SRCH_ADD A , PS_RB_REGION R WHERE H.CAPTURE_ID = B.CAPTURE_ID AND H.UID20F_SOLD = B.UID20 AND B.BO_ID = A.BO_ID AND B.PROFILE_CM_SEQ = A.PROFILE_CM_SEQ AND A.ROLE_TYPE_ID = B.ROLE_TYPE_ID AND R.REGION_CATEGORY = 'GEOG' AND R.REGION_ID = A.REGION_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
2 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description