CA_DETAIL_VW5

(SQL View)
 Index Back

Contract Lines

Contract Lines

SELECT HDR.BUSINESS_UNIT , HDR.CONTRACT_NUM , CD.CONTRACT_LINE_NUM , CD.PRODUCT_ID , CD.DESCR , CD.PRICING_STRUCTURE , HDR.CONTRACT_ADMIN FROM PS_CA_CONTR_HDR HDR , PS_CA_DETAIL CD WHERE HDR.CONTRACT_NUM = CD.CONTRACT_NUM AND HDR.CA_RQST_SRC IN ('GOV','STD','FED') AND CD.PRICING_STRUCTURE = 'RATE'

  • Related Language Record: CA_DETAIL_VW_LG

    • # 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_CA.BUSINESS_UNIT

    Prompt Table: SP_BU_CA_NONVW

    2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: CA_CNTR_SRCH_VW

    3 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

    Prompt Table: CA_DETAIL

    4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 PRICING_STRUCTURE Character(4) VARCHAR2(4) NOT NULL Price Type
    AMT=Amount
    PCT=Percent
    RATE=Rate
    RCR=Recurring
    7 CONTRACT_ADMIN Character(40) VARCHAR2(40) NOT NULL Contract Administrator defined on CABU.

    Prompt Table: MEMBER_VW