RI_ASETSTATLCVW

(SQL View)
 Index Back

Installed Product Search View

Search View for Industry Vertical version of Installed Product

SELECT A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , 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 , M.DESCR , L.RB_XLATLONGNAME FROM PS_RF_INST_PROD A ,PS_RF_SITE_360_VW B , PS_PROD_ITEM E , PS_RF_ISTATXLAT_VW F ,PS_RF_ISTATXLT_LVW L , PS_RF_INST_PROD_ST D , PS_SEC_SETID_CLS Z , PSOPRDEFN Y , PS_PROD_ITEM_LNG M 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 E.SETID = M.SETID AND E.PRODUCT_ID = M.PRODUCT_ID AND L.LANGUAGE_CD = M.LANGUAGE_CD AND A.SETID = Z.SETID AND Z.OPRCLASS = Y.ROWSECCLASS AND D.SETID = A.SETID AND D.INST_PROD_ID = A.INST_PROD_ID AND E.PRODUCT_ID = A.PRODUCT_ID 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 = '001' AND F.SETID = L.SETID AND F.INST_PROD_TYPE = L.INST_PROD_TYPE AND F.FIELDVALUE = L.FIELDVALUE

  • Related Language Record for RI_ASET_STATCVW

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