RSF_TSK3_LVW

(SQL View)
 Index Back

View for Oppy Task

Task view for Lead and Oppy Component.

SELECT c.person_id_owner ,f.language_cd , c.descr60 , c.descrlong FROM ps_rb_tsk_txn a , ps_rsf_opportunity b , ps_rb_tsk c , ps_rsf_person_vw d ,ps_rb_tsk_lang f WHERE a.rel_txn_syncid = b.syncid AND a.task_id = c.task_id AND a.rb_transaction_id = 'OPPRT' AND a.txn_market = 'GBL' AND c.person_id_owner = d.contact_id AND f.task_id=c.task_id UNION ALL SELECT c.person_id_owner ,f.language_cd , c.descr60 , c.descrlong FROM ps_rb_tsk_txn a , PS_RSF_LEAD b , ps_rb_tsk c , ps_rsf_person_vw d , ps_bo_name e ,ps_rb_tsk_lang f WHERE a.rel_txn_syncid = b.syncid AND a.task_id = c.task_id AND a.rb_transaction_id = 'LEAD' AND a.txn_market = 'GBL' AND c.person_id_owner = d.contact_id AND e.bo_id = b.bo_id_contact AND b.bo_id_contact <> 0 AND f.task_id=c.task_id UNION ALL SELECT c.person_id_owner ,f.language_cd , c.descr60 , c.descrlong FROM ps_rb_tsk_txn a , PS_RSF_LEAD b , ps_rb_tsk c , ps_rsf_person_vw d ,ps_rb_tsk_lang f WHERE a.rel_txn_syncid = b.syncid AND a.task_id = c.task_id AND a.rb_transaction_id = 'LEAD' AND a.txn_market = 'GBL' AND c.person_id_owner = d.contact_id AND b.bo_id_contact = 0 AND f.task_id=c.task_id

  • Related Language Record for RSF_TSK3_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

    Prompt Table: RB_WORKER_SRCH

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    4 DESCRLONG Long Character CLOB Long Description