JPM_CAT_ITM2_VW

(SQL View)
 Index Back

Cat Item Prompt for Cat Item 2

Defines all of the Catalog Items for a particular Catalog Type

SELECT DISTINCT A.JPM_CAT_TYPE , A.JPM_CAT_ITEM_ID , A.JPM_DESCR90 FROM PS_JPM_CAT_ITEMS A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_JPM_CAT_ITEMS B WHERE A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID AND B.EFFDT <= %CurrentDateIn AND A.EFF_STATUS = 'A')

  • Related Language Record: JPM_CAT_ITM2LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_CAT_TYPE2 Character(12) VARCHAR2(12) NOT NULL Secondary content item type (as in a related item- such as a child or a supporting item of another item).
    2 JPM_CAT_ITEM_ID2 Character(12) VARCHAR2(12) NOT NULL Secondary content item id (as in a related item- such as a child or a supporting item of another item).
    3 JPM_DESCR90 Character(90) VARCHAR2(90) NOT NULL jpm