CA_WC_RATES_VW

(SQL View)
 Index Back

Rates

To be used in Workcenter

SELECT HDR.CONTRACT_NUM , DTL.CONTRACT_LINE_NUM , BUSINESS_UNIT , HDR.DESCR , DTL.DESCR , DTL.BUSINESS_UNIT_PC , EFFDT , EFF_STATUS , RATE_TMPL_OPTION , HDR.SOLD_TO_CUST_ID , CUST.NAME1 , PRODUCT_ID FROM PS_CA_CONTR_HDR HDR , PS_CUSTOMER CUST , PS_SET_CNTRL_GROUP GRP , PS_CA_DETAIL 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 DTL.CHG_STATUS <> 'X' 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: CA_WC_RATES_LVW

    • # 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_CA_NONVW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    6 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

    Prompt Table: SP_BU_PC_NONVW

    7 EFFDT Date(10) DATE Effective Date
    8 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    9 RATE_TMPL_OPTION Character(4) VARCHAR2(4) NOT NULL Rate Option
    CRTP=Contract Rate Plan
    NSTD=Contract Rate Set
    TMPL=Rate Set
    URTP=Rate Plan
    10 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

    Prompt Table: CUST_SLD_VW

    11 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    12 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID