RBF_APP_BPEL_VW (SQL View)	Index Back
Link to Business Process Used in 360 to determine if Application (Order) is linked to a Business Process

RBF_APP_BPEL_VW

(SQL View)

Link to Business Process

Used in 360 to determine if Application (Order) is linked to a Business Process

SELECT o.CAPTURE_ID , l.PRODUCT_ID , bpel.RBB_SERV_OPR_ID , bpel.RBF_SERV_CAN_ID FROM PS_RO_HEADER o , PS_RO_LINE l , PS_RBT_PROD_BUSPRJ bpel WHERE O.CAPTURE_ID = l.CAPTURE_ID AND l.PRODUCT_ID = bpel.PRODUCT_ID AND bpel.SETID = ( SELECT X.SETID FROM PS_SET_CNTRL_REC X WHERE X.SETCNTRLVALUE = o.BUSINESS_UNIT AND X.RECNAME = 'RO_DEFN')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.

2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

3 RBB_SERV_OPR_ID Character(100) VARCHAR2(100) NOT NULL Service Operation ID

4 RBF_SERV_CAN_ID Character(100) VARCHAR2(100) NOT NULL Service Operation ID to Cancel a BPEL process.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
2	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
3	RBB_SERV_OPR_ID	Character(100)	VARCHAR2(100) NOT NULL	Service Operation ID
4	RBF_SERV_CAN_ID	Character(100)	VARCHAR2(100) NOT NULL	Service Operation ID to Cancel a BPEL process.