SAD_DET_LOV_VW

(SQL View)
 Index Back

Organization Location Table

FS 03052004

SELECT B.EXT_ORG_ID , B.ORG_LOCATION , B.EFFDT , B.EFF_STATUS , B.DESCR , B.DESCRSHORT , A.SAD_ADDR_PRI_NLD , A.SAD_BPV_OTYPE_NLD , A.SAD_DEBNR_FZ_NLD , A.SAD_KC_RELNR_NLD , B.EMAILID , B.URL_ADDRESS , A.DESCRLONG FROM PS_ORG_LOCATION B , PS_SAD_BPV_LOC_NLD A WHERE B.EXT_ORG_ID = A.EXT_ORG_ID(+) AND B.ORG_LOCATION = A.ORG_LOCATION(+)

  • Related Language Record: SADDETLOVVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SAD_EO_ID_DET_NLD Character(11) VARCHAR2(11) NOT NULL Outsourcing company
    2 SAD_ORGLC_DTL_NLD Number(3,0) SMALLINT NOT NULL Outsourcing location
    3 EFFDT Date(10) DATE Effective Date
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 SAD_ADDR_PRI_NLD Character(1) VARCHAR2(1) NOT NULL Main address
    8 SAD_BPV_OTYPE_NLD Character(4) VARCHAR2(4) NOT NULL Organization type
    9 SAD_DEBNR_FZ_NLD Character(20) VARCHAR2(20) NOT NULL Customer nbr FZ
    10 SAD_KC_RELNR_NLD Character(20) VARCHAR2(20) NOT NULL Relation nbr knowledge centre
    11 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    12 URL_ADDRESS Character(254) VARCHAR2(254) NOT NULL URL Address
    13 DESCRLONG Long Character CLOB Long Description