LM_SRCHACTC3LNG

(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. -------------------------------------(7a)---------(7b)----------(7c) Delivery Method............Y............Y.............N Catalog..........................Y............N.............Y Message........................N............N............N -

SELECT ACT7.LM_ACT_ID , ACT7.LM_CI_ID , CITLNG7.LANGUAGE_CD , DMTYPLNG7.LM_DM_LONG_NM , DMTYPLNG7.LM_DM_SHRT_NM , CITLNG7.LM_CS_LONG_NM , CITLNG7.LM_CS_DESCR FROM PS_LM_ACT ACT7 , PS_LM_DMTHD_TBL DMALL7 , PS_LM_DMTH_TYP_TBL DMTYP7 , PS_LM_DMTH_TYP_LNG DMTYPLNG7 , PS_LM_CI_TBL CIT7 , PS_LM_CI_LANG CITLNG7 WHERE %Sql(LM_SRCHACTCI_NOMSG_RLNG_SQL,ACT7,DMALL7,DMTYP7,CIT7) AND CIT7.LM_CI_ID = CITLNG7.LM_CI_ID AND CIT7.EFFDT = CITLNG7.EFFDT AND CITLNG7.LANGUAGE_CD = DMTYPLNG7.LANGUAGE_CD AND DMTYP7.LM_DMTHD_TYPE_ID = DMTYPLNG7.LM_DMTHD_TYPE_ID UNION SELECT ACT7A.LM_ACT_ID , ACT7A.LM_CI_ID , DMTYPLNG7A.LANGUAGE_CD , DMTYPLNG7A.LM_DM_LONG_NM , DMTYPLNG7A.LM_DM_SHRT_NM , CIT7A.LM_CS_LONG_NM , CIT7A.LM_CS_DESCR FROM PS_LM_ACT ACT7A , PS_LM_DMTHD_TBL DMALL7A , PS_LM_DMTH_TYP_TBL DMTYP7A , PS_LM_DMTH_TYP_LNG DMTYPLNG7A , PS_LM_CI_TBL CIT7A WHERE %Sql(LM_SRCHACTCI_NOMSG_RLNG_SQL,ACT7A,DMALL7A,DMTYP7A,CIT7A) AND DMTYP7A.LM_DMTHD_TYPE_ID = DMTYPLNG7A.LM_DMTHD_TYPE_ID AND NOT EXISTS ( SELECT 1 FROM PS_LM_CI_LANG CITLNG7A WHERE CIT7A.LM_CI_ID = CITLNG7A.LM_CI_ID AND CIT7A.EFFDT = CITLNG7A.EFFDT AND CITLNG7A.LANGUAGE_CD = CITLNG7A.LANGUAGE_CD) UNION SELECT ACT7B.LM_ACT_ID , ACT7B.LM_CI_ID , CITLNG7B.LANGUAGE_CD , DMTYP7B.LM_DM_LONG_NM , DMTYP7B.LM_DM_SHRT_NM , CITLNG7B.LM_CS_LONG_NM , CITLNG7B.LM_CS_DESCR FROM PS_LM_ACT ACT7B , PS_LM_DMTHD_TBL DMALL7B , PS_LM_DMTH_TYP_TBL DMTYP7B , PS_LM_CI_TBL CIT7B , PS_LM_CI_LANG CITLNG7B WHERE %Sql(LM_SRCHACTCI_NOMSG_RLNG_SQL,ACT7B,DMALL7B,DMTYP7B,CIT7B) AND CIT7B.LM_CI_ID = CITLNG7B.LM_CI_ID AND CIT7B.EFFDT = CITLNG7B.EFFDT AND NOT EXISTS ( SELECT 1 FROM PS_LM_DMTH_TYP_LNG DMTYPLNG7B WHERE DMTYP7B.LM_DMTHD_TYPE_ID = DMTYPLNG7B.LM_DMTHD_TYPE_ID AND DMTYPLNG7B.LANGUAGE_CD = CITLNG7B.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