JPM_SRCH_GTP_V2 (SQL View)	Index Back
Prof Type members of Prof Grp Selects distinct profile type members of searchable Profile Group Types.

JPM_SRCH_GTP_V2

(SQL View)

Prof Type members of Prof Grp

Selects distinct profile type members of searchable Profile Group Types.

SELECT DISTINCT JPM_JP_TYPE FROM PS_JPM_JP_GTYPE A , PS_JPM_JP_GTYP_MBR C WHERE A.JPM_JP_GRP_TYPE = C.JPM_JP_GRP_TYPE AND A.JPM_JP_SRCH_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type