RB_MB_QUE_VW(SQL View) |
Index Back |
---|---|
Queue viewCRM ERMS view used to show mail box queue list |
SELECT A.DEFAULT_WORKLIST , A.MAILBOX_ID FROM PS_RB_MAILBOX_DEFN A WHERE A.EFF_STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GROUP_NAME | Character(30) | VARCHAR2(30) NOT NULL | Contact Management - Group Name |
2 | MAILBOX_ID | Character(30) | VARCHAR2(30) NOT NULL | Mail Box Id is an Id associated with Mail Boxes |