SPB_REPLREQ_VW (SQL View)	Index Back
Replace SC Requisition View Replace SC Requisition View

SPB_REPLREQ_VW

(SQL View)

Replace SC Requisition View

SELECT DISTINCT B.REQ_ID , A.BUSINESS_UNIT FROM PS_SPB_REPLASC_LOG A , PS_PV_REQ_LN_XREF B WHERE A.SP_REQ_ID = B.SP_REQ_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 REQ_ID_TO Character(10) VARCHAR2(10) NOT NULL Requisition ID To

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REQ_ID_TO	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID To
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit