BO_ID_CUSTROLE_TYPE_ID_CUSTBO_ID_CONTACTROLE_TYPE_ID_CNTCTLANGUAGE_CDRBF_CUST_LNG(SQL View) |
Index Back |
|---|---|
My Processes InformationView to display the Processes for Agent Facing and Self Service - My Processes |
| SELECT A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , C.LANGUAGE_CD , D.DESCR , C.PRCS_TYPE_DESC , E.RBB_DESCR FROM PS_RBB_BO_ASSOCTN A , PS_RBB_INST_HDR B , PS_RBF_PRCS_LNG C , PSOPERATIONLANG D , PS_RBB_TRNSTYP_LNG E WHERE A.RBB_BPEL_INST_ID=B.RBB_BPEL_INST_ID AND B.MARKET = C.MARKET AND B.RBB_TRNSTYPE_ID=C.RBB_TRNSTYPE_ID AND B.RBB_SERV_OPR_ID = D.IB_OPERATIONNAME AND B.RBB_TRNSTYPE_ID=E.RBB_TRNSTYPE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID_CUST |
Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 2 | ROLE_TYPE_ID_CUST |
Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 3 | BO_ID_CONTACT |
Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 4 | ROLE_TYPE_ID_CNTCT |
Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | PRCS_TYPE_DESC | Character(50) | VARCHAR2(50) NOT NULL | The Field is used to store the Process type description |
| 8 | RBB_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description of BPEL related setup objects. |