ORIGINAP_BI_LNG

(SQL View)
Index Back

IU-Interface AP Origin Def RLR


SELECT AP.BUSINESS_UNIT_GL , L.SETID , L.ORIGIN , L.LANGUAGE_CD , L.DESCRSHORT FROM PS_ORIGIN_PO_LANG L , PS_BUS_UNIT_TBL_AP AP WHERE L.SETID = ( SELECT S.SETID FROM PS_SET_CNTRL_REC S WHERE SETCNTRLVALUE = AP.BUSINESS_UNIT AND RECNAME = 'ORIGIN_AP_EFFVW')

  • Related Language Record for ORIGINAP_BI_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    3 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description