JPM_SRCH_CTYPVW

(SQL View)
 Index Back

JPM Search Criteria Cat Types

Populates search criteria with the intersection of the source and target profile types.

SELECT A.JPM_JP_TYPE ,B.JPM_JP_TYPE ,A.JPM_CAT_TYPE ,C.JPM_ROLE FROM PS_JPM_JP_SECTION A , PS_JPM_JP_SECTION B , PS_JPM_JP_ROLES C , PS_JPM_JP_ROLES D WHERE A.JPM_CAT_RLAT_CD <> 'C' AND %EffdtCheck(JPM_JP_SECTION A1, A, %CurrentDateIn) AND B.JPM_CAT_RLAT_CD <> 'C' AND %EffdtCheck(JPM_JP_SECTION B1, B, %CurrentDateIn) AND A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND EXISTS ( SELECT 'X' FROM PS_JPM_JP_PROPS E WHERE E.JPM_JP_TYPE = A.JPM_JP_TYPE AND %EffdtCheck(JPM_JP_PROPS E1, E, %CurrentDateIn) AND E.JPM_JP_SECTION_ID = A.JPM_JP_SECTION_ID AND E.JPM_SRCH_FLG = 'Y') AND A.JPM_JP_TYPE = C.JPM_JP_TYPE AND A.JPM_JP_SECTION_ID = C.JPM_JP_SECTION_ID AND A.EFFDT = C.EFFDT AND EXISTS ( SELECT 'X' FROM PS_JPM_JP_PROPS F WHERE F.JPM_JP_TYPE = B.JPM_JP_TYPE AND %EffdtCheck(JPM_JP_PROPS F1, F, %CurrentDateIn) AND F.JPM_JP_SECTION_ID = B.JPM_JP_SECTION_ID AND F.JPM_SRCH_FLG = 'Y') AND B.JPM_JP_TYPE = D.JPM_JP_TYPE AND B.JPM_JP_SECTION_ID = D.JPM_JP_SECTION_ID AND B.EFFDT = D.EFFDT AND C.JPM_ROLE = D.JPM_ROLE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 JPM_SOURCE_JP Character(12) VARCHAR2(12) NOT NULL Source Profile
2 JPM_TARGET_JP Character(12) VARCHAR2(12) NOT NULL Target Profile
3 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.
4 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).