JPM_LOC_ITEMLVW

(SQL View)
 Index Back

Catalog Items - Talent Mgmt

Defines all of the Catalog Items for a particular Catalog Type

SELECT L.JPM_CAT_ITEM_ID , L.LANGUAGE_CD ,L.JPM_DESCR90 FROM PS_JPM_CAT_ITEMS I , PS_JPM_CAT_ITM_LNG L WHERE L.JPM_CAT_TYPE='LOCATION' AND %EffdtCheck(JPM_CAT_ITEMS L1, L, %CurrentDateIn) AND I.JPM_CAT_TYPE = L.JPM_CAT_TYPE AND I.JPM_CAT_ITEM_ID = L.JPM_CAT_ITEM_ID AND I.EFFDT = L.EFFDT AND I.EFF_STATUS = 'A'

  • Related Language Record for JPM_LOC_ITEM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.

    Prompt Table: JPM_CAT_ITEMS

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 JPM_DESCR90 Character(90) VARCHAR2(90) NOT NULL jpm