CA_RNW_SCH_LANG

(SQL View)
 Index Back

CA-Renewal Package

PSIRS-KK This tables stores the high level information about a Renewal Package.

SELECT B.BUSINESS_UNIT , A.TARGET_CONTRACT , A.RNW_PKG_ID , LANG.LANGUAGE_CD , A.DESCR , C.NAME1 FROM PS_CA_RNW_PKG A , PS_CA_CONTR_HDR B , PS_CUSTOMER C , PS_CUSTOMER_LANG LANG WHERE A.TARGET_CONTRACT = B.CONTRACT_NUM AND B.SOLD_TO_CUST_ID = C.CUST_ID AND %Join(COMMON_KEYS, CUSTOMER C, CUSTOMER_LANG LANG)

  • Related Language Record for CA_RNW_SCH_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 TARGET_CONTRACT Character(25) VARCHAR2(25) NOT NULL PSIRS-KK
    3 RNW_PKG_ID Character(10) VARCHAR2(10) NOT NULL PSIRS-KK

    Default Value: NEXT

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1