RF_IPRDSRH_ASVW

(SQL View)
 Index Back

Installed Assets Search View

This view returns all Installed Assets. It is used as the Search view for the Installed Assets configurable search component.

SELECT A.SETID , A.INST_PROD_ID , A.ASSET_OWNER , A.PRODUCT_GROUP , A.PRODUCT_ID , P.DESCR , A.INV_ITEM_ID , A.SERIAL_ID , A.ASSETTAG , D.BO_NAME_DISPLAY , D.BO_NAME_AC , F.EMPLID , A.DEPTID , E.DESCR , A.LOCATION , G.DESCR , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , A.BO_ID_PTNR_CMP , A.ROLETYPE_PTNR_CMP , A.BO_ID_PTNR_CNT , A.ROLETYPE_PTNR_CNT , A.SYNCID , A.SYNCDTTM FROM PS_RF_INST_PROD A , PS_BO_NAME D , PS_RF_ASSET_DPT_VW E , PS_RF_ASSET_LOC_VW G , PS_RD_PERSON F , PS_PROD_ITEM P WHERE A.BO_ID_CONTACT = D.BO_ID(+) AND D.PRIMARY_IND(+) = 'Y' AND A.SETID = E.SETCNTRLVALUE(+) AND A.DEPTID = E.DEPTID(+) AND A.SETID = G.SETCNTRLVALUE(+) AND A.LOCATION = G.LOCATION(+) AND A.PERSON_ID = F.PERSON_ID(+) AND A.INST_PROD_TYPE = '001' AND P.SETID = ( SELECT R.SETID FROM PS_SET_CNTRL_REC R WHERE R.SETCNTRLVALUE = A.SETID AND R.RECNAME = 'PROD_ITEM') AND P.PRODUCT_ID = A.PRODUCT_ID

  • Related Language Record: RF_IPRDSRH_ALVW

    • # 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.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
    3 ASSET_OWNER Character(1) VARCHAR2(1) NOT NULL This field is used by the Installed Product component for product type `Asset� to determine the Owner of the Asset. There are four allowable types: 1) Department, which designates an asset owned by department; 2) Employee, which designates an asset owned by employee, 3) Location, which designates an asset owned by location and 4) None, which designates an asset is created with out any employee/department/location.
    D=Department
    E=Employee
    L=Location
    N=None
    4 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
    5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: RF_IPRD_PRD_VW2

    6 DESCR_PRODUCT Character(30) VARCHAR2(30) NOT NULL Description
    7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: RF_IPRD_ITM_VW2

    8 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product

    Prompt Table: RF_IPRD_SN_VW2

    9 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag

    Prompt Table: RF_IPRD_AT_VW2

    10 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
    11 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    12 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    13 DEPTID Character(15) VARCHAR2(15) NOT NULL Department

    Prompt Table: RF_IPRD_DEPT_VW

    14 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    15 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.

    Prompt Table: RF_IPRD_LOC_VW

    16 DESCR_LOCATION Character(30) VARCHAR2(30) NOT NULL Description
    17 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    18 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    19 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    20 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
    21 BO_ID_PTNR_CMP Signed Number(32,0) DECIMAL(31) NOT NULL Partner Company Business Object ID.
    22 ROLETYPE_PTNR_CMP Number(12,0) DECIMAL(12) NOT NULL Role Type Partner Company
    23 BO_ID_PTNR_CNT Signed Number(32,0) DECIMAL(31) NOT NULL Partner Contact Business Object ID.
    24 ROLETYPE_PTNR_CNT Number(12,0) DECIMAL(12) NOT NULL Role Type Partner Contact
    25 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    26 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time