BO_PRI_ADD_VW

(SQL View)
Index Back

Primary add for a Bus Object

Primary address for a Bus Object for Person and Company SES

SELECT A.BO_ID ,A.ROLE_TYPE_ID ,A.CM_CONCAT , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 ,A.COUNTRY ,C.DESCR , A.CITY , A.STATE ,D.DESCR , A.POSTAL , A.CITY_AC FROM PS_BO_SRCH_ADD A , PS_COUNTRY_TBL C ,PS_STATE_TBL D WHERE A.PRIMARY_IND = 'Y' AND A.CM_USE_START_DT <= %CurrentDateIn AND A.CM_USE_END_DT > %CurrentDateIn AND A.COUNTRY=C.COUNTRY AND A.STATE=D.STATE AND A.COUNTRY=D.COUNTRY AND A.ROLE_TYPE_ID <> 4 UNION SELECT A.BO_ID ,86 ,A.CM_CONCAT , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 ,A.COUNTRY ,C.DESCR , A.CITY , A.STATE ,D.DESCR , A.POSTAL , A.CITY_AC FROM PS_BO_SRCH_ADD A , PS_COUNTRY_TBL C ,PS_STATE_TBL D WHERE A.CM_USE_START_DT <= %CurrentDateIn AND A.CM_USE_END_DT > %CurrentDateIn AND A.COUNTRY=C.COUNTRY AND A.STATE=D.STATE AND A.COUNTRY=D.COUNTRY AND A.ROLE_TYPE_ID = 4 AND A.cm_purpose_type_id=32

  • Related Language Record: BO_PRI_ADD_LVW
  • # 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 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID
    3 CM_CONCAT Character(100) VARCHAR2(100) NOT NULL Concatenated Contact Method
    4 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    5 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    6 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    7 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    8 COUNTRY2 Character(3) VARCHAR2(3) NOT NULL Country field used in the response synchronous message.
    9 DESCR30_1 Character(30) VARCHAR2(30) NOT NULL Short Description......................
    10 CITY Character(30) VARCHAR2(30) NOT NULL City
    11 STATE Character(6) VARCHAR2(6) NOT NULL State
    12 DESCR30_2 Character(30) VARCHAR2(30) NOT NULL Short Description....................
    13 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    14 CITY_AC Character(30) VARCHAR2(30) NOT NULL CITY_AC