SPF_SRC_REQ_VW

(SQL View)
 Index Back

Wo - Relealted Requisition

Wo - Related Requisition view 01/29/12 /SMO/ 13374770 :ENSURED THAT REVIEW & SOURCE PAGE SEARCH CRITERIAS ARE WORKING FINE.

SELECT DISTINCT C.BUSINESS_UNIT , A.REQ_ID ,D.OPRID , C.SP_REQ_ID FROM PS_PV_REQ_LN_XREF A ,PS_SPF_REQ_LINE C , PSOPRDEFN D WHERE A.SP_BUSINESS_UNIT = C.BUSINESS_UNIT AND A.SP_REQ_ID = C.SP_REQ_ID AND A.SP_LINE_NBR =C.LINE_NBR AND (C. RECRUITER = ( SELECT PERSON_ID FROM PSOPRALIAS WHERE OPRALIASTYPE ='SPP' AND OPRID = D.OPRID) OR D.OPRID IN ( SELECT B.OPRID FROM PS_SPB_MEM_BY_TEAM A , PSOPRALIAS B WHERE A.TEAM_ID = C.TEAM_ID AND A.TEAM_TYPE = 'SC' AND B.PERSON_ID = A.PERSON_ID AND B.OPRALIASTYPE = 'SPP' AND B.OPRID = D.OPRID))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 SP_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID