CA_PV_SUM_LVW

(SQL View)
 Index Back

Main vw for Online PV Summ

This is the main view to bring in all other details to be used in Online summary page

SELECT CHDR.BUSINESS_UNIT , CD.CONTRACT_NUM , CD.CONTRACT_LINE_NUM ,CUST.LANGUAGE_CD ,CHDR.DESCR ,CUST.NAME1 FROM PS_CA_CONTR_HDR CHDR , PS_CA_DETAIL CD , PS_SET_CNTRL_REC REC , PS_CUSTOMER_LANG CUST WHERE CHDR.CONTRACT_NUM=CD.CONTRACT_NUM AND CHDR.SOLD_TO_CUST_ID = CUST.CUST_ID AND CHDR.BUSINESS_UNIT = REC.SETCNTRLVALUE AND REC.RECNAME = 'CUSTOMER' AND REC.SETID = CUST.SETID

  • Related Language Record for CA_PV_OSUM_VW CA_PV_SUM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    3 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 NAME1_CUST Character(40) VARCHAR2(40) NOT NULL Customer Name1