RI_IPSTATLOVW

(SQL View)
 Index Back

Installed Product Search View

Search View for Industry Vertical version of Installed Product

SELECT A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , B.BO_ID , D.INST_PROD_STATUS , A.SETID , A.INST_PROD_ID , L.LANGUAGE_CD , PL.DESCR , L.RB_XLATLONGNAME , Z.OPRID FROM PS_RF_INST_PROD A , PS_PROD_ITEM E , PS_PROD_ITEM_LNG PL , PS_RF_ISTATXLAT_VW F ,PS_RF_ISTATXLT_LVW L , PS_RF_INST_PROD_ST D , PS_RF_SITE_360_VW B , PS_SEC_SETID_OPR Z WHERE A.SETID = B.SETCNTRLVALUE (+) AND A.SITE_ID = B.SITE_ID (+) AND E.SETID = ( SELECT X.SETID FROM PS_SET_CNTRL_REC X WHERE X.SETCNTRLVALUE = A.SETID AND X.RECNAME = 'PROD_ITEM') AND A.SETID = Z.SETID AND D.SETID = A.SETID AND D.INST_PROD_ID = A.INST_PROD_ID AND E.PRODUCT_ID = A.PRODUCT_ID AND PL.SETID = E.SETID AND PL.PRODUCT_ID = E.PRODUCT_ID AND PL.LANGUAGE_CD = L.LANGUAGE_CD AND F.SETID = A.SETID AND F.FIELDVALUE = D.INST_PROD_STATUS AND F.INST_PROD_TYPE = A.INST_PROD_TYPE AND F.INST_PROD_TYPE = '002' AND F.SETID = L.SETID AND F.INST_PROD_TYPE = L.INST_PROD_TYPE AND F.FIELDVALUE = L.FIELDVALUE

  • Related Language Record for RI_IP_STATOVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    2 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
    3 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    4 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    5 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID
    6 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.

    Prompt Table: RF_ISTATXLTS_VW

    7 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

    8 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
    9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 RB_XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Installed Product Status

    Prompt Table: RF_ISTATXLTS_VW

    12 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).