MU_JPM_CAT_VWLN

(SQL View)
 Index Back

Prompt view for JPM Sections

View used as a prompt for JPM sections in order to select JPM_CAT_ITEM_ID

SELECT A.JPM_CAT_TYPE , A.JPM_CAT_ITEM_ID , A.LANGUAGE_CD , A.JPM_DESCR90 FROM PS_JPM_CAT_ITM_LNG 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)

  • Related Language Record for MU_JPM_CAT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MU_SECTION Character(20) VARCHAR2(20) NOT NULL Section
    2 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 JPM_DESCR90 Character(90) VARCHAR2(90) NOT NULL jpm