BUSINESS_UNITCASE_IDRF_RMA_CASE_VW(SQL View) |
Index Back |
|---|---|
RMA Case ViewRetrieves any open support cases, including the customer information. |
| SELECT A.BUSINESS_UNIT ,A.CASE_ID ,A.BO_ID_CUST ,C.SETID ,C.CUST_ID ,B.BO_NAME_DISPLAY ,B.BO_NAME_AC ,A.PRODUCT_ID ,A.RC_STATUS ,A.RC_PRIORITY FROM PS_RC_CASE A , PS_BO_NAME B , PS_BC C , PS_RC_STATUS_TBL D WHERE C.BO_ID = A.BO_ID_CUST AND B.BO_ID = C.BO_ID AND D.RC_STATUS = A.RC_STATUS AND D.SETID = ( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.RECNAME = 'RC_STATUS_TBL') AND B.PRIMARY_IND = 'Y' AND A.RC_VERTICAL='SW' AND D.STATUS_CATEGORY = 'O' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | 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. |
| 3 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 5 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 6 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 7 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 8 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 9 | RC_STATUS | Character(5) | VARCHAR2(5) NOT NULL | Case Status |
| 10 | RC_PRIORITY | Character(5) | VARCHAR2(5) NOT NULL | Case Priority |