CDT_RMA_LN_LVW

(SQL View)
 Index Back

CDT RMA Line View Language


SELECT r.business_unit , r.rma_id , r.rma_line_nbr , p.language_cd , p.descr FROM ps_rma_line r , ps_set_cntrl_rec sc , PS_PROD_ITEM_LNG p WHERE sc.setcntrlvalue = r.business_unit AND sc.recname = 'PROD_ITEM_LNG' AND sc.setid = p.setid AND r.product_id = p.product_id

  • Related Language Record for CDT_RMA_LINE_VW

    • # 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_FS_NONVW

    2 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number

    Prompt Table: RMA_HEADER

    3 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number

    Default Value: 1

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description