SPF_SRCLOC_VW

(SQL View)

SELECT DISTINCT A.REGION_CD ,A.LOCATION ,B.DESCR FROM PS_SPB_REGIONLOCAT A , PS_SPF_REQ_LINE C , PS_SET_CNTRL_GROUP S , PS_SET_CNTRL_GROUP SC ,PS_LOCATION_TBL L ,PS_SHIPTO_TBL B WHERE C.BUSINESS_UNIT = S.SETCNTRLVALUE AND S.REC_GROUP_ID = 'FS_37' AND A.SETID = S.SETID AND SC.REC_GROUP_ID = 'PO_04' AND B.SETID = SC.SETID AND A.SETID = L.SETID AND A.LOCATION = L.LOCATION AND A.SETID = B.SETID AND A.LOCATION = B.SHIPTO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

2 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
2	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description