CA_CONTR_HDR_VW

(SQL View)
Index Back

Contract Header Search View

This is the Self-Service iClient version of the Contract Header Search View.

SELECT CONTRACT_NUM , CUST.NAME1 , BUSINESS_UNIT , CONTR_LEGAL_ENTITY , REGION_CD , CONTRACT_SIGN_DT , CONTRACT_SIGN_DT , CONTRACT_SIGN_DT , HDR.CONTRACT_ADMIN FROM PS_CA_CONTR_HDR HDR , PS_CUST_SLD_VW CUST , PS_SET_CNTRL_GROUP D WHERE HDR.SOLD_TO_CUST_ID = CUST.CUST_ID AND HDR.CA_RQST_SRC <> 'OND' AND D.REC_GROUP_ID = ( SELECT REC_GROUP_ID FROM PS_REC_GROUP_REC WHERE RECNAME = 'CUSTOMER') AND CUST.SETID = D.SETID AND HDR.BUSINESS_UNIT = D.SETCNTRLVALUE

  • Related Language Record: CA_CONTR_HD_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Default Value: NEXT

    2 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT

    Prompt Table: SP_BU_CA_NONVW

    4 CONTR_LEGAL_ENTITY Character(15) VARCHAR2(15) NOT NULL Contract Legal Entity

    Prompt Table: CA_LEGAL_ENTITY

    5 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

    Prompt Table: CA_REGION_CD_VW

    6 CONTRACT_SIGN_DT Date(10) DATE Contract Signed
    7 FROM_DT Date(10) DATE From Date
    8 TO_DT Date(10) DATE To Contract Sign Date
    9 CONTRACT_ADMIN Character(40) VARCHAR2(40) NOT NULL Contract Administrator defined on CABU.

    Prompt Table: MEMBER_VW