ITEMLINEVW3LNG is the language record related to ITEM_LINE_VW3 A related language record enables text fields on a table to be translated into various languages for use in other countries.

ITEMLINEVW3LNG

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT ,A.EMPLID ,A.EXT_ORG_ID ,A.ITEM_TERM ,x.ITEM_TYPE ,x.LANGUAGE_CD ,x.DESCR FROM PS_ITEM_LINE_SF A , PS_ITEM_SF B , PS_BUS_UNIT_TBL_SF C , PS_ITEM_TYPE_TBL D , PS_ITEM_TYPE_LNG x WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.COMMON_ID = A.COMMON_ID AND B.SA_ID_TYPE = A.SA_ID_TYPE AND B.ITEM_NBR = A.ITEM_NBR AND B.ITEM_TYPE = D.ITEM_TYPE AND D.SETID=( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.RECNAME='ITEM_TYPE_TBL' AND E.SETCNTRLVALUE=C.INSTITUTION) AND D.EFFDT=( SELECT MAX(Y.EFFDT) FROM PS_ITEM_TYPE_TBL Y WHERE Y.SETID = D.SETID AND Y.ITEM_TYPE = D.ITEM_TYPE AND Y.EFFDT <= %CurrentDateIn) AND D.EFF_STATUS = 'A' AND d.setid = x.setid AND d.item_type=x.item_type AND d.effdt = x.effdt

  • Related Language Record for ITEM_LINE_VW3

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    4 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term
    5 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description