LM_LC_HDR_LVW

(SQL View)
 Index Back

Component Header lang view

Related language record for Component Header view

SELECT A.LM_ACT_ID ,C.LM_LC_ID ,B.LANGUAGE_CD ,B.LM_CS_LONG_NM ,E.LM_LC_TYPE_LONG ,D.LM_LC_LONG_NM ,D.LM_LC_DESCR FROM PS_LM_ACT_CI_VW A , PS_LM_ACT_CI_LVW B , PS_LM_LC_VW C , PS_LM_LC_LVW D , PS_LM_LC_TYPE_LVW E WHERE A.LM_ACT_ID = B.LM_ACT_ID AND B.LM_ACT_ID = C.LM_ACT_ID AND C.LM_LC_TYPE_ID = E.LM_LC_TYPE_ID AND C.LM_LC_ID = D.LM_LC_ID AND B.LANGUAGE_CD = D.LANGUAGE_CD AND D.LANGUAGE_CD = E.LANGUAGE_CD UNION ALL SELECT A.LM_ACT_ID ,C.LM_LC_ID ,C.LANGUAGE_CD ,A.LM_CS_LONG_NM ,D.LM_LC_TYPE_LONG ,C.LM_LC_LONG_NM ,C.LM_LC_DESCR FROM PS_LM_ACT_CI_VW A , PS_LM_LC_VW B , PS_LM_LC_LVW C , PS_LM_LC_TYPE_LVW D WHERE A.LM_ACT_ID = B.LM_ACT_ID AND B.LM_LC_ID = C.LM_LC_ID AND B.LM_LC_TYPE_ID = D.LM_LC_TYPE_ID AND C.LANGUAGE_CD = D.LANGUAGE_CD AND NOT EXISTS ( SELECT 'X' FROM PS_LM_ACT_CI_LVW E WHERE E.LM_ACT_ID = A.LM_ACT_ID AND E.LANGUAGE_CD = C.LANGUAGE_CD) UNION ALL SELECT A.LM_ACT_ID ,C.LM_LC_ID ,B.LANGUAGE_CD ,B.LM_CS_LONG_NM ,D.LM_LC_TYPE_LONG ,C.LM_LC_LONG_NM ,C.LM_LC_DESCR FROM PS_LM_ACT_CI_VW A , PS_LM_ACT_CI_LVW B , PS_LM_LC_VW C , PS_LM_LC_TYPE_LVW D WHERE A.LM_ACT_ID = B.LM_ACT_ID AND A.LM_ACT_ID = C.LM_ACT_ID AND C.LM_LC_TYPE_ID = D.LM_LC_TYPE_ID AND B.LANGUAGE_CD = D.LANGUAGE_CD AND NOT EXISTS ( SELECT 'X' FROM PS_LM_LC_LVW E WHERE E.LM_LC_ID = C.LM_LC_ID AND E.LANGUAGE_CD = B.LANGUAGE_CD) UNION ALL SELECT A.LM_ACT_ID ,C.LM_LC_ID ,B.LANGUAGE_CD ,B.LM_CS_LONG_NM ,E.LM_LC_TYPE_LONG ,D.LM_LC_LONG_NM ,D.LM_LC_DESCR FROM PS_LM_ACT_CI_VW A , PS_LM_ACT_CI_LVW B , PS_LM_LC_VW C , PS_LM_LC_LVW D , PS_LM_LC_TYPE_VW E WHERE A.LM_ACT_ID = B.LM_ACT_ID AND A.LM_ACT_ID = B.LM_ACT_ID AND C.LM_LC_ID = D.LM_LC_ID AND C.LM_LC_TYPE_ID = E.LM_LC_TYPE_ID AND B.LANGUAGE_CD = D.LANGUAGE_CD AND NOT EXISTS ( SELECT 'X' FROM PS_LM_LC_TYPE_LVW F WHERE F.LM_LC_TYPE_ID = E.LM_LC_TYPE_ID AND F.LANGUAGE_CD = B.LANGUAGE_CD) UNION ALL SELECT A.LM_ACT_ID ,B.LM_LC_ID ,C.LANGUAGE_CD ,A.LM_CS_LONG_NM ,C.LM_LC_TYPE_LONG ,B.LM_LC_LONG_NM ,B.LM_LC_DESCR FROM PS_LM_ACT_CI_VW A , PS_LM_LC_VW B , PS_LM_LC_TYPE_LVW C WHERE A.LM_ACT_ID = B.LM_ACT_ID AND B.LM_LC_TYPE_ID = C.LM_LC_TYPE_ID AND NOT EXISTS ( SELECT 'X' FROM PS_LM_ACT_CI_LVW D WHERE D.LM_ACT_ID = A.LM_ACT_ID AND D.LANGUAGE_CD = C.LANGUAGE_CD) AND NOT EXISTS ( SELECT 'X' FROM PS_LM_LC_LVW E WHERE E.LM_LC_ID = B.LM_LC_ID AND E.LANGUAGE_CD = C.LANGUAGE_CD) UNION ALL SELECT A.LM_ACT_ID ,C.LM_LC_ID ,B.LANGUAGE_CD ,B.LM_CS_LONG_NM ,D.LM_LC_TYPE_LONG ,C.LM_LC_LONG_NM ,C.LM_LC_DESCR FROM PS_LM_ACT_CI_VW A , PS_LM_ACT_CI_LVW B , PS_LM_LC_VW C , PS_LM_LC_TYPE_VW D WHERE A.LM_ACT_ID = B.LM_ACT_ID AND A.LM_ACT_ID = C.LM_ACT_ID AND C.LM_LC_TYPE_ID = D.LM_LC_TYPE_ID AND NOT EXISTS ( SELECT 'X' FROM PS_LM_LC_LVW E WHERE E.LM_LC_ID = C.LM_LC_ID AND E.LANGUAGE_CD = B.LANGUAGE_CD) AND NOT EXISTS ( SELECT 'X' FROM PS_LM_LC_TYPE_LVW F WHERE F.LM_LC_TYPE_ID = D.LM_LC_TYPE_ID AND F.LANGUAGE_CD = B.LANGUAGE_CD) UNION ALL SELECT A.LM_ACT_ID ,B.LM_LC_ID ,C.LANGUAGE_CD ,A.LM_CS_LONG_NM ,D.LM_LC_TYPE_LONG ,C.LM_LC_LONG_NM ,C.LM_LC_DESCR FROM PS_LM_ACT_CI_VW A , PS_LM_LC_VW B , PS_LM_LC_LVW C , PS_LM_LC_TYPE_VW D WHERE A.LM_ACT_ID = B.LM_ACT_ID AND B.LM_LC_TYPE_ID = D.LM_LC_TYPE_ID AND NOT EXISTS ( SELECT 'X' FROM PS_LM_ACT_CI_LVW E WHERE E.LM_ACT_ID = A.LM_ACT_ID AND E.LANGUAGE_CD = C.LANGUAGE_CD) AND NOT EXISTS ( SELECT 'X' FROM PS_LM_LC_TYPE_LVW F WHERE F.LM_LC_TYPE_ID = D.LM_LC_TYPE_ID AND F.LANGUAGE_CD = C.LANGUAGE_CD)

  • Related Language Record for LM_LC_HDR_VW

    • # 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_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    5 LM_LC_TYPE_LONG Character(200) VARCHAR2(200) NOT NULL Learning Component Type Long Name
    6 LM_LC_LONG_NM Character(200) VARCHAR2(200) NOT NULL Learning Component Long Name
    7 LM_LC_DESCR Long Character CLOB Learning Component Description