BO_IDROLE_TYPE_IDLANGUAGE_CDBO_PRI_ADD_LVW(SQL View) |
Index Back |
|---|---|
Primary add for a Bus ObjectRelated language record of BO_PRI_ADD_VW. Primary address for a Bus Object |
| SELECT A.BO_ID ,A.ROLE_TYPE_ID ,C.LANGUAGE_CD ,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_COUNTRYTBL_LANG C ,PS_STATE_TBL_LANG D WHERE A.PRIMARY_IND = 'Y' AND A.CM_USE_START_DT <= %CurrentDateIn AND A.CM_USE_END_DT > %CurrentDateIn AND A.ROLE_TYPE_ID = ( SELECT MIN(B.ROLE_TYPE_ID) FROM PS_BO_SRCH_ADD B WHERE A.BO_ID = B.BO_ID AND ROLE_TYPE_ID > 0 ) 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 ,C.LANGUAGE_CD ,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_COUNTRYTBL_LANG C ,PS_STATE_TBL_LANG D WHERE A.CM_USE_START_DT <= %CurrentDateIn AND A.CM_USE_END_DT > %CurrentDateIn AND A.ROLE_TYPE_ID = ( SELECT MIN(B.ROLE_TYPE_ID) FROM PS_BO_SRCH_ADD B WHERE A.BO_ID = B.BO_ID AND ROLE_TYPE_ID > 0 ) 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 |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | CM_CONCAT | Character(100) | VARCHAR2(100) NOT NULL | Concatenated Contact Method |
| 5 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 6 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 7 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 8 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 9 | COUNTRY2 | Character(3) | VARCHAR2(3) NOT NULL | Country field used in the response synchronous message. |
| 10 | DESCR30_1 | Character(30) | VARCHAR2(30) NOT NULL | Short Description...................... |
| 11 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 12 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 13 | DESCR30_2 | Character(30) | VARCHAR2(30) NOT NULL | Short Description.................... |
| 14 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 15 | CITY_AC | Character(30) | VARCHAR2(30) NOT NULL | CITY_AC |