Rlat all view with language table joined

JPM_RLATALL_LVW

(SQL View)

SELECT DISTINCT C.JPM_RLAT_NAME , B.LANGUAGE_CD , B.DESCR FROM PS_JPM_PROFILE A , PS_JPM_RLAT_SEL_LN B , PS_JPM_JP_X_RLAT C , PS_JPM_RLAT_SEL D , PS_JPM_PROFILE_LNG E WHERE C.JPM_RLAT_NAME = B.JPM_RLAT_NAME AND C.JPM_RLAT_NAME = D.JPM_RLAT_NAME AND A.JPM_PROFILE_ID = C.JPM_PROFILE_ID AND C.JPM_RLAT_NAME = D.JPM_RLAT_NAME AND A.JPM_PROFILE_ID = E.JPM_PROFILE_ID AND B.LANGUAGE_CD = E.LANGUAGE_CD AND D.JPM_JP_RLTN_ENABLD = 'Y' AND C.JPM_JP_XRLAT_TYPE = 'PIDO' AND A.EMPLID = ' '

Related Language Record for JPM_RLAT_ALL_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JPM_RLAT_NAME Character(30) VARCHAR2(30) NOT NULL Name of the relationship being established between JPM Data and External Data. Example - JOB CODE might be used to indicate that the relationship is between a JPM Profile of Job and External Data such as the Job Code on the Job Code table.

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JPM_RLAT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Name of the relationship being established between JPM Data and External Data. Example - JOB CODE might be used to indicate that the relationship is between a JPM Profile of Job and External Data such as the Job Code on the Job Code table.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description