RF_SITE_NM_VW

(SQL View)
 Index Back

RF Site Name view

Site Name view for Service Order Site prompt

SELECT DISTINCT A.BUSINESS_UNIT , D.BO_NAME_DISPLAY , B.BO_NAME FROM PS_RF_SO_HDR A , PS_BO_NAME D , PS_RD_SITE C , PS_BO_NAME B WHERE A.BO_ID_CUST = D.BO_ID(+) AND D.PRIMARY_IND(+) = 'Y' AND A.SITE_ID = C.SITE_ID AND B.BO_ID = C.BO_ID AND C.SETID = ( SELECT R.SETID FROM PS_SET_CNTRL_REC R WHERE R.RECNAME = 'RD_SITE' AND A.BUSINESS_UNIT = R.SETCNTRLVALUE) AND B.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
3 BO_NAME_3 Character(50) VARCHAR2(50) NOT NULL BO Name 3