RBW_BPEL_PRC_VW (SQL View)	Index Back
BPEL process View Client Summary view for BPEL processes for a Customer

RBW_BPEL_PRC_VW

(SQL View)

BPEL process View

Client Summary view for BPEL processes for a Customer

SELECT A.BO_ID_CUST , H.RBB_BPEL_INST_ID , O.DESCR , ord.CAPTURE_ID , led.LEAD_ID , cas.CASE_ID , H.RBB_START_DTTM , H.RBB_STATUS , rbb.RBB_TRNSTYPE_ID , rbb.RBB_DESCR FROM PS_RBB_BO_ASSOCTN A , PS_RBB_INST_HDR H , PSOPERATION O , PS_RBB_INST_HDR hdr1 , PS_RBB_INST_HDR hdr2 , PS_RBB_INST_HDR hdr3 , PS_RBB_TRNSTYP_DFN rbb , PS_RBB_RC_BPLINST cas , PS_RBB_RSF_BPLINST led , PS_RBB_RO_BPLINST ord WHERE A.RBB_BPEL_INST_ID = H.RBB_BPEL_INST_ID AND O.IB_OPERATIONNAME = %Substring(H.RBB_SERV_OPR_ID,1,30) AND H.RBB_TRNSTYPE_ID = rbb.RBB_TRNSTYPE_ID AND H.RBB_BPEL_INST_ID = hdr1.RBB_BPEL_INST_ID AND hdr1.RBB_BPEL_INST_ID = ord.RBB_BPEL_INST_ID (+) AND H.RBB_BPEL_INST_ID = hdr2.RBB_BPEL_INST_ID AND hdr2.RBB_BPEL_INST_ID = led.RBB_BPEL_INST_ID (+) AND H.RBB_BPEL_INST_ID = HDR3.RBB_BPEL_INST_ID AND hdr3.RBB_BPEL_INST_ID = cas.RBB_BPEL_INST_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 RBB_BPEL_INST_ID Character(100) VARCHAR2(100) NOT NULL Business Process Instance ID

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 APPLICATION_NUMBER Character(20) VARCHAR2(20) NOT NULL Field use to store the application number for Lead, Opportunity, Case and Order Capture

5 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.

6 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.

7 RBB_START_DTTM DateTime(26) TIMESTAMP Business Process Start Date and Time

8 RBB_STATUS Character(1) VARCHAR2(1) NOT NULL Current Status of the BPEL Instance in Peoplesoft System
C=Completed
F=Failed
P=In Progress
Q=Queued
X=Cancelled

9 RBB_TRNSTYPE_ID Character(25) VARCHAR2(25) NOT NULL Field to store Transaction Type ID

10 RBB_DESCR Character(50) VARCHAR2(50) NOT NULL Description of BPEL related setup objects.

#	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	RBB_BPEL_INST_ID	Character(100)	VARCHAR2(100) NOT NULL	Business Process Instance ID
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	APPLICATION_NUMBER	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the application number for Lead, Opportunity, Case and Order Capture
5	LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
6	CASE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
7	RBB_START_DTTM	DateTime(26)	TIMESTAMP	Business Process Start Date and Time
8	RBB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Current Status of the BPEL Instance in Peoplesoft System C=Completed F=Failed P=In Progress Q=Queued X=Cancelled
9	RBB_TRNSTYPE_ID	Character(25)	VARCHAR2(25) NOT NULL	Field to store Transaction Type ID
10	RBB_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description of BPEL related setup objects.