CA_WC_RATES_LVW

(SQL View)
 Index Back

Language View

To be used in Workcenter - Contract line missing rateset/plan exception

SELECT HDR.CONTRACT_NUM , DTL.CONTRACT_LINE_NUM ,DTL.LANGUAGE_CD , DTL.DESCR , CUST.NAME1 FROM PS_CA_CONTR_HDR HDR , PS_CUSTOMER_LANG CUST , PS_SET_CNTRL_GROUP GRP , PS_CA_DETAIL_LANG DTL , PS_CA_WC_RT_VW RT WHERE GRP.SETCNTRLVALUE = HDR.BUSINESS_UNIT AND GRP.REC_GROUP_ID = 'FS_23' AND GRP.SETID = CUST.SETID AND CUST.CUST_ID = HDR.SOLD_TO_CUST_ID AND HDR.CA_RQST_SRC <> 'OND' AND HDR.CA_PROC_STATUS = 'A' AND DTL.CONTRACT_NUM = HDR.CONTRACT_NUM AND RT.CONTRACT_NUM = DTL.CONTRACT_NUM AND RT.CONTRACT_LINE_NUM = DTL.CONTRACT_LINE_NUM AND (RT.PC_TEMPLATE_ID IS NULL OR RT.PC_TEMPLATE_ID = ' ') AND (RT.RATE_PLAN IS NULL OR RT.RATE_PLAN = ' ')

  • Related Language Record for CA_WC_RATES_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1