RF_IPRDCSHS_LVW

(SQL View)
 Index Back

Installed Product Case History

This is a related language view of the cases that are associated with the installed product.

SELECT B.SETID , B.INST_PROD_ID , A.BUSINESS_UNIT , A.CASE_ID , C.LANGUAGE_CD , C.RC_SHORT_DESCR FROM PS_RC_CASE A , PS_RF_INST_PROD B , PS_RC_STATUS_LNG C WHERE A.INST_PROD_ID = B.INST_PROD_ID AND B.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'RF_INST_PROD') AND C.SETID = ( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.RECNAME = 'RC_STATUS_TBL') AND C.RC_STATUS = A.RC_STATUS

  • Related Language Record for RF_IPRDCSHIS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    2 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    4 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.
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables