RC_ASSETLVW1

(SQL View)
Index Back

Installed Assets View

Returns all installed assets for a given employee. Used as prompt related language record on Case.

SELECT A.SETID , E.BO_ID , D.DEPTID , A.ASSETTAG , C.LANGUAGE_CD , C.DESCR FROM PS_RF_INST_PROD A , PS_RF_INST_PROD_ST B , PS_PROD_ITEM_LNG C , PS_RB_WORKER D , PS_RD_PERSON E WHERE A.SETID = B.SETID AND A.INST_PROD_ID = B.INST_PROD_ID AND B.INST_PROD_STATUS <> 'UNI' AND C.SETID = ( SELECT SC.SETID FROM PS_SET_CNTRL_REC SC WHERE SC.SETCNTRLVALUE = A.SETID AND SC.RECNAME = 'PROD_ITEM') AND A.PRODUCT_ID = C.PRODUCT_ID AND (A.PERSON_ID = D.PERSON_ID OR A.DEPTID = D.DEPTID ) AND D.PERSON_ID = E.PERSON_ID

  • Related Language Record for RC_ASSET_VW1
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID
    2 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    3 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
    4 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description