SADBPVCONSR5LNG

(SQL View)
 Index Back

BPV Contact view

FS 15062004

SELECT A.EXT_ORG_ID , B.DESCR , A.SAD_INT_CONTR_NLD , B.LANGUAGE_CD , C.ADDRESS3 , C.POSTAL FROM PS_SAD_BPV_CTR_NLD A , PS_ORG_LOC_LANG B , PS_SAD_BPV_OLD_NLD C WHERE A.SAD_PLAN_SEL_NLD IN ('O','A') AND A.EXT_ORG_ID = B.EXT_ORG_ID AND A.ORG_LOCATION = B.ORG_LOCATION AND %EffdtCheck(ORG_LOC_LANG B1 , B, %CurrentDateIn) AND A.EXT_ORG_ID = C.EXT_ORG_ID(+) AND A.ORG_LOCATION = C.ORG_LOCATION(+) AND 'BUSN' = C.ADDRESS_TYPE(+)

  • Related Language Record for SAD_BPV_CON_SR5

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    3 SAD_INT_CONTR_NLD Character(16) VARCHAR2(16) NOT NULL Internal contract
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 SAD_BPV_STREET_NLD Character(55) VARCHAR2(55) NOT NULL Street
    6 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal