RF_SO_ENT_LVW

(SQL View)
 Index Back

Service Order Entitlements

This related language view is for retrieving service order entitlements.

SELECT A.SETID , A.AGREEMENT_CODE , A.AGR_RENEWAL_NUM , A.AGREEMENT_LINE , A.ENTITLE_NAME , L.LANGUAGE_CD , L.DESCR FROM PS_RF_AG_LINE_ENTL A , PS_RF_ENTITLEMENTS B , PS_RF_ENTITLE_LANG L WHERE B.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.SETID AND C.RECNAME = 'RF_ENTITLEMENTS') AND A.ENTITLE_NAME = B.ENTITLE_NAME AND B.SETID = L.SETID AND B.ENTITLE_NAME = L.ENTITLE_NAME

  • Related Language Record for RF_SO_ENT

    • # 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 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement
    3 AGR_RENEWAL_NUM Number(4,0) SMALLINT NOT NULL This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
    4 AGREEMENT_LINE Character(10) VARCHAR2(10) NOT NULL This field records the value for the agreement line number
    5 ENTITLE_NAME Character(10) VARCHAR2(10) NOT NULL This field represents the name of the entitlement

    Prompt Table: RF_ENTITLEMENTS

    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description