JPM_RELITEM_VW

(SQL View)
 Index Back

Items with related items

Get a list of profile items that have related child profile items.

SELECT A.JPM_PROFILE_ID , A.JPM_CAT_TYPE , A.JPM_CAT_ITEM_ID FROM PS_JPM_JP_CRITM_VW A WHERE EXISTS ( SELECT 'X' FROM PS_JPM_JP_CRITM_VW B WHERE B.JPM_PROFILE_ID = A.JPM_PROFILE_ID AND B.JPM_PARENT_KEY_ID = A.JPM_ITEM_KEY_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 JPM_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
2 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.
3 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.