RS_SO_SRCH_PLVW

(SQL View)
 Index Back

Service Order Comp Search View

Used as the Search record for the Service Order component. Contains platform specific code for Outer Join on Customer record.

SELECT A.BUSINESS_UNIT , A.SO_ID , B.SETID , A.CUST_ID , B.NAME1 , B.NAMESHORT , A.SO_STATUS , A.ENTERED_BY , A.ASSIGNED_TO , A.PROJECT_ID , A.DESCR60 FROM PS_RS_SOSTAT_VW A , PS_CUSTOMER B WHERE A.CUST_SETID = B.SETID (+) AND A.CUST_ID = B.CUST_ID (+)

  • Related Language Record: RS_SO_SRCH_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_CLSVW

    2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID

    Default Value: NEXT

    3 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

    Default Value: CUSTOMER.SETID

    4 CUST_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.

    Default Value: CUSTOMER.CUST_ID

    Prompt Table: CUSTOMER_FS

    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    6 NAMESHORT Character(10) VARCHAR2(10) NOT NULL Short Name
    7 SO_STATUS Character(1) VARCHAR2(1) NOT NULL Service Order Status
    C=Closed
    D=Draft
    I=In Process
    N=New
    O=Open
    X=Canceled
    8 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by

    Prompt Table: OPRID_VW

    9 ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL Assigned To

    Prompt Table: RS_OPR_NAME_VW

    10 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: SP_PROJ_NONVW

    11 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description