LM_SRCHACTC2LNG

(SQL View)
 Index Back

Search: Rel Lang View

Related Language View for Activity / Catalog Item search view. This view includes catalog items that does not have any activities. Here is how the view is constructed. Indicates if relaled language exists. --------------------------------------(5)----------(5A)--------(5B) Catalog...........................Y.............N------------Y Message Catalog ...........Y.............Y------------N

SELECT 0 , CIT5.LM_CI_ID , M314LNG5.LANGUAGE_CD , M314LNG5.MESSAGE_TEXT , ' ' , CITLNG5.LM_CS_LONG_NM , CITLNG5.LM_CS_DESCR FROM PS_LM_CI_TBL CIT5 LEFT OUTER JOIN PSMSGCATLANG M314LNG5 ON M314LNG5.MESSAGE_SET_NBR = 18088 AND M314LNG5.MESSAGE_NBR = 314 , PS_LM_CI_LANG CITLNG5 WHERE %Sql(LM_ELIG_NOT_APPL_SQL,CIT5) AND CIT5.LM_CI_ID = CITLNG5.LM_CI_ID AND CIT5.EFFDT = CITLNG5.EFFDT AND CITLNG5.LANGUAGE_CD = M314LNG5.LANGUAGE_CD UNION SELECT 0 , CIT5A.LM_CI_ID , M314LNG5A.LANGUAGE_CD , M314LNG5A.MESSAGE_TEXT , ' ' , CIT5A.LM_CS_LONG_NM , CIT5A.LM_CS_DESCR FROM PS_LM_CI_TBL CIT5A LEFT OUTER JOIN PSMSGCATLANG M314LNG5A ON M314LNG5A.MESSAGE_SET_NBR = 18088 AND M314LNG5A.MESSAGE_NBR = 314 WHERE %Sql(LM_ELIG_NOT_APPL_SQL,CIT5A) AND NOT EXISTS ( SELECT 1 FROM PS_LM_CI_LANG CITLNG5A WHERE CIT5A.LM_CI_ID = CITLNG5A.LM_CI_ID AND CIT5A.EFFDT = CITLNG5A.EFFDT AND CITLNG5A.LANGUAGE_CD = M314LNG5A.LANGUAGE_CD) UNION SELECT 0 , CITLNG5B.LM_CI_ID , CITLNG5B.LANGUAGE_CD , M3145B.MESSAGE_TEXT , ' ' , CITLNG5B.LM_CS_LONG_NM , CITLNG5B.LM_CS_DESCR FROM PS_LM_CI_TBL CIT5B LEFT OUTER JOIN PSMSGCATDEFN M3145B ON M3145B.MESSAGE_SET_NBR = 18088 AND M3145B.MESSAGE_NBR = 314 , PS_LM_CI_LANG CITLNG5B WHERE %Sql(LM_ELIG_NOT_APPL_SQL,CIT5B) AND CIT5B.LM_CI_ID = CITLNG5B.LM_CI_ID AND CIT5B.EFFDT = CITLNG5B.EFFDT AND NOT EXISTS ( SELECT 1 FROM PSMSGCATLANG M314LNG5B WHERE M314LNG5B.MESSAGE_SET_NBR = 18088 AND M314LNG5B.MESSAGE_NBR = 314 AND M314LNG5B.LANGUAGE_CD = CITLNG5B.LANGUAGE_CD)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
2 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
5 LM_DM_SHRT_NM Character(10) VARCHAR2(10) NOT NULL Short Name - Short Name of a Delivery Method Type
6 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
7 LM_CS_DESCR Character(254) VARCHAR2(254) NOT NULL Description - Describes an object with further detail