RF_REPSITES_VW

(SQL View)
 Index Back

Sites for a Representatives

Sites for a Business Representative

SELECT DISTINCT A.SETID , B.BO_ID , E.BO_ID , A.SITE_ID , E.BO_NAME_DISPLAY , E.BO_NAME_AC , %Substring(B.BO_NAME_DISPLAY, 1, 50) , B.BO_NAME_AC , %Substring(C.BO_NAME_DISPLAY, 1, 50) , C.BO_NAME_AC FROM PS_RD_SITE A , PS_BO_NAME B , PS_BO_NAME C , PS_BO_REL D , PS_BO_NAME E , PS_BO_REL F , PS_BO_REL G , PS_BO H WHERE D.REL_TYPE_ID IN (11, 12) AND D.BO_ID_1 = B.BO_ID AND D.BO_ID_2 = A.BO_ID AND A.BO_ID = C.BO_ID AND F.REL_TYPE_ID IN (9, 10, 13, 14) AND B.BO_ID = F.BO_ID_1 AND E.BO_ID = F.BO_ID_2 AND G.REL_TYPE_ID IN (4, 17) AND E.BO_ID = G.BO_ID_1 AND A.BO_ID = G.BO_ID_2 AND H.BO_ID = A.BO_ID AND H.MERGE_STATUS <> 'I'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
2 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
3 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
4 SITE_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: RD_SITE

5 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
6 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
7 BO_NAME_2 Character(50) VARCHAR2(50) NOT NULL BO Name 2
8 NAME_AC_SRCH Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
9 BO_NAME_1 Character(50) VARCHAR2(50) NOT NULL BO Name 1
10 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)