PL_I_MG_DPP_LVW

(SQL View)
Index Back

relative language record

relative language record of PL_I_MSG_DPP_VW

SELECT DISTINCT G.BU_GROUP , D.PLANNER_CD , A.INV_ITEM_ID ,E.LANGUAGE_CD , E.DESCR FROM PS_DEM_CHG_INF_INV A , PS_PL_GROUP_IN G , PS_SET_CNTRL_REC C , PS_BU_ITEMS_INV D ,PS_MASTER_ITM_LANG E WHERE A.DESTIN_BU = G.BUSINESS_UNIT AND A.INV_ITEM_ID = E.INV_ITEM_ID AND A.DESTIN_BU = C.SETCNTRLVALUE AND C.RECNAME = 'MASTER_ITEM_TBL' AND E.SETID = C.SETID AND A.DESTIN_BU = D.BUSINESS_UNIT AND A.INV_ITEM_ID = D.INV_ITEM_ID

  • Related Language Record for PL_I_MSG_DPP_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DEST_BU_GROUP Character(6) VARCHAR2(6) NOT NULL 08/16/01 EGS (CN#PL900-1.0): Added
    2 DEST_PLAN_CD Character(12) VARCHAR2(12) NOT NULL Destination Planner Code
    3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description