FO_RF_SRCH3_VW

(SQL View)
 Index Back

Order search view by Customer


SELECT DISTINCT C.SETID , C.CONTACT_ID , C.NAME1 FROM PS_RS_SO_HDR A , PS_RS_SO_STATUS B , PS_CONTACT C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID AND B.LASTUPDDTTM = ( SELECT MAX(LASTUPDDTTM) FROM PS_RS_SO_STATUS B1 WHERE B.BUSINESS_UNIT = B1.BUSINESS_UNIT AND B.SO_ID = B1.SO_ID) AND A.MANAGER_CONTACT_ID = C.CONTACT_ID AND A.SYSTEM_SOURCE = 'STF' AND EXISTS ( SELECT 'x' FROM PS_FO_EVENT_LS_HDR Z WHERE Z.FO_EVENT_LST = A.FO_EVENT_LST) AND B.SO_STATUS = 'U' AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_CONTACT D WHERE C.SETID = D.SETID AND C.CONTACT_ID = D.CONTACT_ID AND D.EFFDT <= %CurrentDateIn AND D.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 MANAGER_CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Order Contact
3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

Prompt Table: FO_CNT_ALT_SRCH