JPM_CAT_GMVWLNG

(SQL View)
Index Back

JPM Catalog Item Group Member

JPM Catalog Item Group Membership

SELECT A.JPM_CAT_TYPE ,A.JPM_CAT_GROUP_TYPE ,A.JPM_CAT_GROUP ,A.JPM_CAT_ITEM_ID ,B.LANGUAGE_CD ,B.JPM_DESCR90 FROM PS_JPM_CAT_GMEMB A , PS_JPM_CAT_ITM_LNG B WHERE A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID AND B.EFFDT =( SELECT MAX(C.EFFDT) FROM PS_JPM_CAT_ITEMS C WHERE C.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND C.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID AND C.EFF_STATUS = 'A' AND C.EFFDT <= %CurrentDateIn)

  • Related Language Record for JPM_CAT_GMEM_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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.

    Prompt Table: JPM_CAT_GTYP_VW

    2 JPM_CAT_GROUP_TYPE Character(12) VARCHAR2(12) NOT NULL Defines Catalog Group Types

    Prompt Table: JPM_CAT_GTYPE

    3 JPM_CAT_GROUP Character(12) VARCHAR2(12) NOT NULL Content Group

    Prompt Table: JPM_CAT_GROUPS

    4 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

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