BO_IDLANGUAGE_CDRD_PTNR_SRCHLVW(SQL View) |
Index Back |
|---|---|
Partner Search ViewPartner Search View for Partner Company component. |
| SELECT A.BO_ID , F.LANGUAGE_CD , B.BO_NAME , B.BO_NAME_UPPER , B.BO_NAME_AC , A.DUNS_NUMBER , A.COMPANYID , A.SETID , D.PARTNER_PGM_ID , F.PARTNER_PGM_NAME FROM PS_RD_COMPANY A , PS_BO_NAME B , PS_RD_PARTNER C , PS_RD_PR_PGM D , PS_RD_PR_PROG E , PS_RD_PR_PROG_LNG F WHERE A.BO_ID = B.BO_ID AND A.BO_ID = C.BO_ID AND A.BO_ID = D.BO_ID AND B.PRIMARY_IND = 'Y' AND D.PRIMARY_IND = 'Y' AND D.PARTNER_PGM_ID = E.PARTNER_PGM_ID AND D.SETID = E.SETID AND F.SETID = E.SETID AND F.PARTNER_PGM_ID = E.PARTNER_PGM_ID |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 4 | BO_NAME_UPPER | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 5 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 6 | DUNS_NUMBER | Character(20) | VARCHAR2(20) NOT NULL | DUNS Number |
| 7 | COMPANYID | Character(15) | VARCHAR2(15) NOT NULL | Company ID |
| 8 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 9 | PARTNER_PGM_ID | Character(15) | VARCHAR2(15) NOT NULL | Partner Program ID |
| 10 | PARTNER_PGM_NAME | Character(50) | VARCHAR2(50) NOT NULL | Partner Program name |