RF_SM_ORDER_VW

(SQL View)
 Index Back

IP SM Order View

This view returns all the service management orders of the given installed product.

SELECT I.SETID , I.INST_PROD_ID , H.CAPTURE_ID , L.BUSINESS_UNIT , H.DESCR50 , H.CAPTURE_DATE , H.STATUS_CODE , L.LINE_ACTION FROM PS_RF_INST_PROD I ,PS_RO_HEADER H ,PS_RO_LINE L WHERE I.INST_PROD_ID=L.INST_PROD_ID AND H.CAPTURE_ID=L.CAPTURE_ID AND I.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE= H.BUSINESS_UNIT AND D.RECNAME = 'RF_INST_PROD') AND H.CAPTURE_TYPE_CD= 'SM' AND H.BULK_ORDER_FLAG='N' AND H.RO_MULTILINE='N'

  • Related Language Record: RF_SM_ORDER_LVW

    • # 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.
    2 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
    3 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    6 CAPTURE_DATE Date(10) DATE Order capture date used for orders and quotes
    7 STATUS_CODE Number(5,0) INTEGER NOT NULL Status Code

    Prompt Table: RO_DEFN_HDSTAT

    8 LINE_ACTION Character(4) VARCHAR2(4) NOT NULL Actions available on an Order - ie Change Features, Renew, Cancel.

    Prompt Table: RO_DEFN_LNACTN