RF_SM_ORDER_LVW

(SQL View)
 Index Back

IP SM Order Language View

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

SELECT I.SETID , I.INST_PROD_ID , H.CAPTURE_ID , HL.LANGUAGE_CD , HL.DESCR50 FROM PS_RF_INST_PROD I ,PS_RO_HEADER H ,PS_RO_LINE L ,PS_RO_HEADER_LANG HL WHERE I.INST_PROD_ID=L.INST_PROD_ID AND H.CAPTURE_ID=L.CAPTURE_ID AND H.CAPTURE_ID=HL.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 for RF_SM_ORDER_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50