FO_ASSGN_OSL_VW

(SQL View)
 Index Back

Service Order Line


SELECT A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A.ACTIVITY_ID , A.QTY_INTEGER , A.CUST_ID , A.ADDRESS_SEQ_NUM , A.START_DT , A.END_DT , A.DESCR , A.SO_LINE_STATUS FROM %Table(RS_SO_LINE) A , %Table(RS_SO_STATUS) S WHERE A.SO_LINE_STATUS = 'U' AND A.BUSINESS_UNIT = S.BUSINESS_UNIT AND A.SO_ID = S.SO_ID AND S.SO_STATUS = 'U' AND S.LASTUPDDTTM = ( SELECT MAX(LASTUPDDTTM) FROM %Table(RS_SO_STATUS) S2 WHERE S2.BUSINESS_UNIT = S.BUSINESS_UNIT AND S2.SO_ID = S.SO_ID)

  • Parent record: RS_SO_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
    3 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
    4 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    5 QTY_INTEGER Number(11,0) DECIMAL(11) NOT NULL Quantity Rounded to 0 Decimals
    6 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.
    7 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: RS_CUST_VW

    8 START_DT Date(10) DATE Start Date
    9 END_DT Date(10) DATE End Date
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 SO_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
    A=Closed
    C=Cancel
    O=Open

    Default Value: O