RC_ASSET_VW2

(SQL View)
 Index Back

Installed Assets Prompt View

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

SELECT A.SETID , A.PRODUCT_ID , E.BO_ID , D.DEPTID , A.ASSETTAG , C.DESCR FROM PS_RF_INST_PROD A , PS_RF_INST_PROD_ST B , PS_PROD_ITEM 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 AND A.ASSETTAG <> ' '

  • Related Language Record: RC_ASSETLVW2

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