RC_REL_DETL_VW5(SQL View) |
Index Back |
---|---|
Related Case Customer NameCustomer name on the related case page. |
SELECT A.BO_ID , B.BO_NAME , B.BO_NAME_DISPLAY FROM PS_BO A , PS_BO_NAME B WHERE A.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BO_ID_SITE | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
2 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
3 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |