EOEC_COMPUPD_VL

(SQL View)
 Index Back

Mobile Component Update SrchVw

SELECT A.BCNAME , A.DESCR , B.EOEC_DATASETNAME , A.SEARCHRECNAME FROM PSBCDEFN A , PS_EOEC_COMPONENT B WHERE A.BCNAME = B.BCNAME

SELECT A.BCNAME , A.LANGUAGE_CD , A.DESCR , C.EOEC_DATASETNAME , B.SEARCHRECNAME FROM PSBCDEFNLANG A , PSBCDEFN B , PS_EOEC_COMPONENT C WHERE A.BCNAME = B.BCNAME AND B.BCNAME = C.BCNAME

  • Related Language Record for EOEC_COMPUPD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BCNAME Character(30) VARCHAR2(30) NOT NULL Business Component Name (see PSBCDEFN).

    Prompt Table: EOEC_COMPUPD_VW

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 EOEC_DATASETNAME Character(30) VARCHAR2(30) NOT NULL The name of one or more rules that will be used to filter a rowset.
    5 SEARCHRECNAME Character(15) VARCHAR2(15) NOT NULL Search Record Name