RBT_PHNATTR_VW

(SQL View)
 Index Back

RBT_PHN_ATTR_VW

View containing Service Phone numbers for Comm customer SELECT DISTINCT A.BO_ID , A.ROLE_TYPE_ID , B.BO_ID_CNTCT , B.ROLE_TYPE_ID_CNTCT , J.ATTRIBUTE_VALUE , %subrec(RB_AUDIT_SBR,A) FROM PS_BO_ROLE A LEFT OUTER JOIN PS_RBT_CNT_SRCH_VW B ON B.BO_ID_CUST = A.BO_ID AND B.ROLE_TYPE_ID_CUST = A.ROLE_TYPE_ID LEFT OUTER JOIN PS_RF_INST_PROD I ON I.BO_ID_CUST = A.BO_ID AND I.ROLE_TYPE_ID_CUST = A.ROLE_TYPE_ID ,PS_RF_ATTR_INSP J WHERE J.INST_PROD_ID = I.INST_PROD_ID AND J.SETID = I.SETID AND J.ATTRIBUTE_ID = 'PS_PHONE_NUM'

SELECT DISTINCT CASE WHEN I.BO_ID_CONTACT > 0 THEN I.BO_ID_CONTACT WHEN I.BO_ID_CONTACT = 0 THEN I.BO_ID_CUST END , I.RBTNUMBER FROM PS_RF_INST_PROD I

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
2 RBTPHONENUMBER Character(15) VARCHAR2(15) NOT NULL Phone Number