RC_RSLNSOLVWLNG (SQL View)	Index Back
Solution attachments View to pull up the solution attachments for matching SOLUTION_ID in resolution.

RC_RSLNSOLVWLNG

(SQL View)

Solution attachments

View to pull up the solution attachments for matching SOLUTION_ID in resolution.

SELECT A.BUSINESS_UNIT , A.CASE_ID , A.RSLN_SEQ_NBR , B.ATTACH_SEQ_NBR , B1.LANGUAGE_CD , B1.DESCRIPTION FROM PS_RC_RESOLUTION A , PS_RC_SOLN_ATTACH B , PS_RC_SOLN_ATH_LNG B1 WHERE A.SOLUTION_ID = B.SOLUTION_ID AND B.SETID = B1.SETID AND B.SOLUTION_ID = B1.SOLUTION_ID AND B.ATTACH_SEQ_NBR = B1.ATTACH_SEQ_NBR

Related Language Record for RC_RSLN_SOLN_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 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.

3 RSLN_SEQ_NBR Number(8,0) INTEGER NOT NULL Resolution Sequence Number

4 ATTACH_SEQ_NBR Number(6,0) INTEGER NOT NULL Attachment Sequence Number

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

6 DESCRIPTION Character(35) VARCHAR2(35) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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.
3	RSLN_SEQ_NBR	Number(8,0)	INTEGER NOT NULL	Resolution Sequence Number
4	ATTACH_SEQ_NBR	Number(6,0)	INTEGER NOT NULL	Attachment Sequence Number
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	DESCRIPTION	Character(35)	VARCHAR2(35) NOT NULL	Description