EXT_ORG_SRCH_LN

(SQL View)
 Index Back

External Org Search View

This search view is used to include the city, state, and country address fields as alternate search keys. It was created to be used on external organization summary panels. This is the related language record for EXT_ORG_SRCH.

SELECT A.EXT_ORG_ID , A1.LANGUAGE_CD , A.EFFDT , A1.DESCR FROM PS_EXT_ORG_TBL A ,PS_EXT_ORG_LANG A1 WHERE A.EXT_ORG_ID = A1.EXT_ORG_ID AND A.EFFDT = A1.EFFDT AND A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_EXT_ORG_TBL A2 WHERE A.EXT_ORG_ID = A2.EXT_ORG_ID AND A2.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record for EXT_ORG_SRCH EXT_ORG_SRCH1 EXT_ORG_VW1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Default Value: 0

    Prompt Table: EXT_ORG_TBL

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description