ORIGINAP_BI_VW

(SQL View)
 Index Back

IU-Interface AP Origin Def


SELECT DISTINCT AP.BUSINESS_UNIT_GL , G.SETID , G.ORIGIN , G.DESCRSHORT FROM PS_ORIGIN_AP_EFFVW G , PS_BUS_UNIT_TBL_AP AP WHERE G.SETID = ( SELECT S.SETID FROM PS_SET_CNTRL_REC S WHERE SETCNTRLVALUE = AP.BUSINESS_UNIT AND RECNAME = 'ORIGIN_AP_EFFVW')

  • Related Language Record: ORIGINAP_BI_LNG

    • # 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

    Prompt Table: SP_SETID_NONVW

    3 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description