RB_BUS_CMCT_LVW (SQL View)	Index Back
Status for a Business Object This view returns the status of the company for Company SES- Language Record.

RB_BUS_CMCT_LVW

(SQL View)

Status for a Business Object

This view returns the status of the company for Company SES- Language Record.

SELECT A.BO_ID ,C.LANGUAGE_CD , A.CUST_ID , B.XLATLONGNAME FROM PS_BC A , PSXLATITEM B ,PSXLATITEMLANG C WHERE B.FIELDNAME='CUST_STATUS' AND B.FIELDVALUE=A.CUST_STATUS AND B.FIELDNAME=C.FIELDNAME AND B.FIELDVALUE=C.FIELDVALUE

Related Language Record for RB_BUS_CMCNT_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID

4 STATUS_DESC Character(20) VARCHAR2(20) NOT NULL Status description. Used in Call Center actions framework for displaying the related object status.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
4	STATUS_DESC	Character(20)	VARCHAR2(20) NOT NULL	Status description. Used in Call Center actions framework for displaying the related object status.