RA_QRYDEFN_SRCH

(SQL View)
 Index Back

Campaign Management Query view

Campaign Management Query Definition view

SELECT Q.QRYNAME , Q.DESCR , Q.LASTUPDDTTM FROM PSQRYDEFN Q WHERE Q.OPRID = ' ' AND Q.QRYTYPE = 1 AND NOT EXISTS ( SELECT 'X' FROM PSQRYBIND B WHERE B.OPRID = Q.OPRID AND B.QRYNAME = Q.QRYNAME AND B.USECOUNT > 0) AND NOT EXISTS ( SELECT 'X' FROM PSQRYSELECT S WHERE S.OPRID = Q.OPRID AND S.QRYNAME = Q.QRYNAME AND S.SELECTTYPE IN (1, 3) AND NOT EXISTS ( SELECT 'X' FROM PSQRYRECORD R WHERE R.OPRID = S.OPRID AND R.QRYNAME = S.QRYNAME AND R.SELNUM = S.SELNUM AND R.JOINTYPE = 1 AND R.RECNAME = 'BO_BASIC_IND'))

  • Related Language Record: RA_QRYDEFN_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.