RBT_PER_CAS_LNG

(SQL View)
 Index Back

My Cases View

SELECT CAS.CASE_ID ,ACCT.RBTACCTNO ,CAS.RC_STATUS ,CAS.RC_SUMMARY ,CAS.BO_ID_CONTACT ,OPR.OPRID ,CAS.CASE_TYPE ,TCAS.RBTBILLID ,TCAS.DESCR100 ,TCAS.RBTDISPUTEAMT ,TCAS.RBTDISPSTATUS FROM PSOPRALIAS OPR ,PS_RD_PERSON PER ,PS_RC_CASE CAS ,PS_RBT_ACCOUNT ACCT ,PS_RCTCASE TCAS WHERE PER.PERSON_ID = OPR.PERSON_ID AND CAS.BO_ID_CONTACT=PER.BO_ID AND CAS.CASE_ID=TCAS.CASE_ID AND CAS.BUSINESS_UNIT=TCAS.BUSINESS_UNIT AND TCAS.RBTACCTID=ACCT.RBTACCTID AND EXISTS ( SELECT TCAS1.CASE_ID FROM PS_RCTCASE TCAS1 ,PS_RC_CASE CAS1 WHERE TCAS1.CASE_ID=CAS1.CASE_ID AND TCAS1.BUSINESS_UNIT=CAS1.BUSINESS_UNIT) UNION SELECT CAS3.CASE_ID ,' ' AS RBTACCTNO ,CAS3.RC_STATUS ,CAS3.RC_SUMMARY ,CAS3.BO_ID_CONTACT ,OPR3.OPRID ,CAS3.CASE_TYPE ,' ' AS RBTBILLID ,' ' AS DESCR100 ,0 AS RBTDISPUTEAMT ,' ' AS RBTDISPSTATUS FROM PSOPRALIAS OPR3 ,PS_RD_PERSON PER3 ,PS_RC_CASE CAS3 WHERE PER3.PERSON_ID = OPR3.PERSON_ID AND CAS3.BO_ID_CONTACT=PER3.BO_ID AND NOT EXISTS ( SELECT TCAS2.CASE_ID FROM PS_RCTCASE TCAS2 ,PS_RC_CASE CAS2 WHERE TCAS2.CASE_ID=CAS2.CASE_ID AND TCAS2.BUSINESS_UNIT=CAS2.BUSINESS_UNIT)

SELECT CAS.CASE_ID ,TCAS.LANGUAGE_CD ,TCAS.DESCR254 FROM PS_RC_CASE CAS , PS_RC_CAS_DSPTE_LN TCAS WHERE CAS.CASE_ID=TCAS.CASE_ID(+) AND CAS.BUSINESS_UNIT=TCAS.BUSINESS_UNIT(+)

  • Related Language Record for RBT_PER_CASE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.

    Default Value: 999999999999999

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254