CDT_RMA_I_LNLVW

(SQL View)
 Index Back

CDT RMA Line View

Date Initials Issue Description 03/07/01 dms SP2 (F-CJORGENS-3) CSR Desktop 06/26/01 JJM F-FSELK-11 Proj. Gemini chartfield changes

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_MASTER_ITM_LANG p WHERE sc.setcntrlvalue = r.business_unit AND sc.recname = 'MASTER_ITM_LANG' AND sc.setid = p.setid AND r.inv_item_id = p.inv_item_id

  • Related Language Record for CDT_RMA_I_LN_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