EODP_QRYRFE_LVW

(SQL View)
 Index Back

Query References view

Query References View

SELECT A.EODP_QUERYNAME , Q1.EODP_QRY_CHILD , D.EODP_QUERY_DESCR , A2.XLATLONGNAME , (CASE WHEN A.EODP_OPRID = ' ' THEN ( SELECT MESSAGE_TEXT FROM PSMSGCATLANG WHERE MESSAGE_SET_NBR = 124 AND MESSAGE_NBR = 322 AND LANGUAGE_CD = CTG.LANGUAGE_CD) ELSE A.EODP_OPRID END) , A.RECNAME , A.FIELDNAME , CTG.LANGUAGE_CD , CTG.EODP_CTGRY_DESC , CLS.EODP_CFCN_NAME , B.EODP_PERS_IDFR , B.EODP_SNSTV , C.EODP_PROD_DESCR , A1.EODP_QRY_INFO FROM PS_EODP_RECFIELD B , PS_EODP_CTR_CD_LNG CTG , PSXLATITEMLANG A2, PS_EODP_CLSFCN_LNG CLS ,PS_EODP_QRYDSC_LVW D, PS_EODP_QRY_REFLNG A1,PS_EODP_QRY_REF A LEFT OUTER JOIN PS_EODP_QRYDTL_REF Q1 ON A.EODP_OPRID = Q1.EODP_OPRID AND A.EODP_QUERYNAME = Q1.EODP_QUERYNAME AND A.EODP_QUERY_TYPE = Q1.EODP_QUERY_TYPE AND A.RECNAME = Q1.RECNAME AND A.FIELDNAME = Q1.FIELDNAME LEFT OUTER JOIN PS_EODP_QRY_RF_LVW C ON A.EODP_QUERYNAME = C.EODP_QUERYNAME WHERE A.RECNAME = B.RECNAME AND A.FIELDNAME = B.FIELDNAME AND A.EODP_QUERY_TYPE = 'STD' AND A.EODP_QUERYNAME = D.EODP_QUERYNAME AND B.EODP_CTGRY_CD = CTG.EODP_CTGRY_CD AND B.EODP_CLFNCD = CLS.EODP_CLFNCD AND A.EODP_OPRID = A1.EODP_OPRID AND A.EODP_QUERYNAME = A1.EODP_QUERYNAME AND A.EODP_QUERY_TYPE = A1.EODP_QUERY_TYPE AND A.RECNAME = A1.RECNAME AND A.FIELDNAME = A1.FIELDNAME AND A2.FIELDNAME = 'EODP_QUERY_TYPE' AND A2.FIELDVALUE = A.EODP_QUERY_TYPE AND A2.LANGUAGE_CD = CTG.LANGUAGE_CD AND %EffdtCheck(PSXLATITEMLANG A3, A2, %CurrentDateIn) AND CTG.LANGUAGE_CD = CLS.LANGUAGE_CD AND CLS.LANGUAGE_CD = D.LANGUAGE_CD AND D.LANGUAGE_CD = A1.LANGUAGE_CD UNION SELECT A.EODP_QUERYNAME , Q1.EODP_QRY_CHILD , D.EODP_QUERY_DESCR , A2.XLATLONGNAME , (CASE WHEN A.EODP_OPRID = ' ' THEN ( SELECT MESSAGE_TEXT FROM PSMSGCATLANG WHERE MESSAGE_SET_NBR = 124 AND MESSAGE_NBR = 322 AND LANGUAGE_CD = CTG.LANGUAGE_CD) ELSE A.EODP_OPRID END) , A.RECNAME , A.FIELDNAME , CTG.LANGUAGE_CD , CTG.EODP_CTGRY_DESC , CLS.EODP_CFCN_NAME , B.EODP_PERS_IDFR , B.EODP_SNSTV , C.EODP_PROD_DESCR , A1.EODP_QRY_INFO FROM PS_EODP_RECFIELD B , PS_EODP_CTR_CD_LNG CTG , PSXLATITEMLANG A2, PS_EODP_CLSFCN_LNG CLS ,PS_EODP_QRYDSC_LVW D , PS_EODP_QRY_REF A LEFT OUTER JOIN PS_EODP_QRY_REFLNG A1 ON A.EODP_OPRID = A1.EODP_OPRID AND A.EODP_QUERYNAME = A1.EODP_QUERYNAME AND A.EODP_QUERY_TYPE = A1.EODP_QUERY_TYPE AND A.RECNAME = A1.RECNAME AND A.FIELDNAME = A1.FIELDNAME LEFT OUTER JOIN PS_EODP_QRYDTL_REF Q1 ON A.EODP_OPRID = Q1.EODP_OPRID AND A.EODP_QUERYNAME = Q1.EODP_QUERYNAME AND A.EODP_QUERY_TYPE = Q1.EODP_QUERY_TYPE AND A.RECNAME = Q1.RECNAME AND A.FIELDNAME = Q1.FIELDNAME LEFT OUTER JOIN PS_EODP_QRY_RF_LVW C ON A.EODP_QUERYNAME = C.EODP_QUERYNAME WHERE A.RECNAME = B.RECNAME AND A.FIELDNAME = B.FIELDNAME AND A.EODP_QUERY_TYPE IN ('CONN', 'COMP') AND A.EODP_QUERYNAME = D.EODP_QUERYNAME AND B.EODP_CTGRY_CD = CTG.EODP_CTGRY_CD AND B.EODP_CLFNCD = CLS.EODP_CLFNCD AND A2.FIELDNAME = 'EODP_QUERY_TYPE' AND A2.FIELDVALUE = A.EODP_QUERY_TYPE AND A2.LANGUAGE_CD = CTG.LANGUAGE_CD AND %EffdtCheck(PSXLATITEMLANG A3, A2, %CurrentDateIn) AND CTG.LANGUAGE_CD = CLS.LANGUAGE_CD AND CLS.LANGUAGE_CD = D.LANGUAGE_CD

  • Related Language Record for EODP_QRYRF_E_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EODP_QUERYNAME Character(30) VARCHAR2(30) NOT NULL Query Name Field
    2 EODP_QRY_CHILD Character(30) VARCHAR2(30) NOT NULL Child Query Name
    3 EODP_QUERY_DESCR Character(30) VARCHAR2(30) NOT NULL Query Description
    4 EODP_QRY_TYP_DSC Character(30) VARCHAR2(30) NOT NULL Query Type
    5 EODP_OWNER Character(30) VARCHAR2(30) NOT NULL Field for Query Owner
    PUB=Public
    6 EODP_RECNAME Character(15) VARCHAR2(15) NOT NULL Record Name
    7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 EODP_CTGRY_DESC Character(100) VARCHAR2(100) NOT NULL Category Name
    10 EODP_CFCN_NAME Character(100) VARCHAR2(100) NOT NULL Classification Name
    11 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
    A=All
    N=No
    Y=Yes
    12 EODP_SNSTV Character(1) VARCHAR2(1) NOT NULL Sensitive
    A=All
    N=No
    Y=Yes
    13 EODP_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description
    14 EODP_QRY_INFO Character(254) VARCHAR2(254) NOT NULL Information