JPM_CAT_ITM2LVW (SQL View)	Index Back
Cat Item Prompt for Cat Item 2 Related Language version. Defines all of the Catalog Items for a particular Catalog Type

JPM_CAT_ITM2LVW

(SQL View)

Cat Item Prompt for Cat Item 2

Related Language version. Defines all of the Catalog Items for a particular Catalog Type

SELECT DISTINCT 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 AND B.EFFDT <= %CurrentDateIn AND B.EFF_STATUS = 'A')

Related Language Record for JPM_CAT_ITM2_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 JPM_DESCR90 Character(90) VARCHAR2(90) NOT NULL jpm

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	JPM_DESCR90	Character(90)	VARCHAR2(90) NOT NULL	jpm