RC_SLID_SITE_VW

(SQL View)
 Index Back

SERIAL ID by site View

Prompt for SERIAL ID by site. Uses only SITE as Key and lists all the SERIAL IDs for that SITE

SELECT DISTINCT A.SETID , A.SITE_ID , A.SERIAL_ID , A.INST_PROD_ID , C.DESCR FROM PS_RF_INST_PROD A , PS_RF_INST_PROD_ST B , PS_PROD_ITEM C 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 C.PRODUCT_ID = A.PRODUCT_ID AND A.SERIAL_ID <> ' ' AND A.SETID = ( SELECT R.SETID FROM PS_SET_CNTRL_REC R WHERE R.RECNAME = 'RD_SITE' AND A.SETID = R.SETCNTRLVALUE)

  • Related Language Record: RC_SLID_SITELVW

    • # 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 SITE_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
    3 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product
    4 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description