EODP_IBSVCXLLVW

(SQL View)
 Index Back

Integration References LVW

Data Privacy Framework: Integration References Language View

SELECT A.IB_SERVICENAME ,B.DESCR ,A.IB_OPERATIONNAME ,C.DESCR ,A.DEFAULTVER ,X.XLATLONGNAME ,D.RECNAME ,E.RECDESCR ,F.FIELDNAME ,B.LANGUAGE_CD ,G.LONGNAME ,CTG.EODP_CTGRY_DESC , CLS.EODP_CFCN_NAME ,A.EODP_PERS_IDFR ,A.EODP_SNSTV ,H.EODP_OBJ_DESCR , D.MSGNAME ,D.IB_MSGVERSION ,D.PARAMETERNAME ,D.QUEUENAME ,IG.IB_INTGROUPNAME ,IG.DESCR FROM PSSERVICELANG B ,PSSERVICE B1 ,PSOPERATIONLANG C ,PS_EODP_IBMSG_REF D ,PSRECDEFNLANG E ,PS_EODP_MSGRECFLD F ,PSDBFLDLABLLANG G , PSDBFLDLABL G1 , PS_EODP_PROD_LVW H ,PS_EODP_IBSVC_REF I , PS_EODP_CTR_CD_LNG CTG , PS_EODP_CLSFCN_LNG CLS ,PSXLATITEMLANG X ,(PS_EODP_IBREFHDRVW A LEFT OUTER JOIN PS_EODP_INTGRPLVW2 IG ON A.IB_SERVICENAME=IG.IB_SERVICENAME) WHERE A.IB_SERVICENAME=B.IB_SERVICENAME AND A.IB_OPERATIONNAME=C.IB_OPERATIONNAME AND D.IB_OPERATIONNAME=A.IB_OPERATIONNAME AND D.VERSIONNAME=A.DEFAULTVER AND D.IB_OPERATIONNAME=C.IB_OPERATIONNAME AND D.RECNAME=E.RECNAME AND D.FIELDNAME=F.FIELDNAME AND D.RECNAME=F.RECNAME AND F.MSGNAME=D.MSGNAME AND A.RECNAME=F.RECNAME AND A.FIELDNAME=F.FIELDNAME AND D.IB_MSGVERSION=F.APMSGVER AND G.FIELDNAME=F.FIELDNAME AND G.FIELDNAME=G1.FIELDNAME AND G.LABEL_ID=G1.LABEL_ID AND G1.DEFAULT_LABEL=1 AND CTG.EODP_CTGRY_CD=A.EODP_CTGRY_CD AND CLS.EODP_CLFNCD=A.EODP_CLFNCD AND B.IB_SERVICENAME=B1.IB_SERVICENAME AND B1.OBJECTOWNERID=H.EODP_PRODUCT_CD AND A.IB_OPERATIONNAME=I.IB_OPERATIONNAME AND A.DEFAULTVER=I.DEFAULTVER AND A.IB_SERVICENAME=I.IB_SERVICENAME AND X.FIELDNAME='RTNGTYPE' AND X.FIELDVALUE=I.RTNGTYPE AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn) AND B.LANGUAGE_CD=C.LANGUAGE_CD AND B.LANGUAGE_CD=E.LANGUAGE_CD AND B.LANGUAGE_CD=H.LANGUAGE_CD AND B.LANGUAGE_CD=CTG.LANGUAGE_CD AND B.LANGUAGE_CD=CLS.LANGUAGE_CD AND B.LANGUAGE_CD=X.LANGUAGE_CD AND (B.LANGUAGE_CD=IG.LANGUAGE_CD OR IG.LANGUAGE_CD IS NULL) AND B.LANGUAGE_CD=G.LANGUAGE_CD

  • Related Language Record for EODP_IBSVC_XLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service Name (see PSSERVICE).
    2 IB_WSIL_SVC_DESCR Character(254) VARCHAR2(254) NOT NULL Service Description
    3 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
    4 EODP_SO_DESCR Character(30) VARCHAR2(30) NOT NULL Data Privacy Framework: Service Operation Description
    5 DEFAULTVER Character(30) VARCHAR2(30) NOT NULL Default Application Message Version
    6 EODP_RTNG_TYPE Character(30) VARCHAR2(30) NOT NULL Data Privacy Framework: Routing Type
    7 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    8 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
    9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    10 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    11 FIELDLABEL Character(60) VARCHAR2(60) NOT NULL Field Label
    12 EODP_CTGRY_DESC Character(100) VARCHAR2(100) NOT NULL Category Name
    13 EODP_CFCN_NAME Character(100) VARCHAR2(100) NOT NULL Classification Name
    14 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
    A=All
    N=No
    Y=Yes
    15 EODP_SNSTV Character(1) VARCHAR2(1) NOT NULL Sensitive
    A=All
    N=No
    Y=Yes
    16 EODP_OBJ_DESCR Character(30) VARCHAR2(30) NOT NULL Product
    17 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
    18 IB_MSGVERSION Character(30) VARCHAR2(30) NOT NULL Message Version
    19 PARAMETERNAME Character(15) VARCHAR2(15) NOT NULL Parameter Name
    20 QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
    21 IB_INTGROUPNAME Character(30) VARCHAR2(30) NOT NULL Integration Group Name (see PSIBGROUPDEFN).
    22 EODP_INTGRP_DESCR Character(30) VARCHAR2(30) NOT NULL Data Privacy Framework: Service Operation Description