CA_RNW_CYC_LANG

(SQL View)
 Index Back

CA-Renewal Cycles

PSIRS-KK

SELECT A.RNW_PKG_ID , B.RNW_CYCLE_NBR , LANG.LANGUAGE_CD , A.DESCR , D.NAME1 FROM PS_CA_RNW_PKG A , PS_CA_RNW_CYCLE B , PS_CA_CONTR_HDR C , PS_CUSTOMER D , PS_CUSTOMER_LANG LANG WHERE A.RNW_PKG_ID = B.RNW_PKG_ID AND A.TARGET_CONTRACT = C.CONTRACT_NUM AND C.SOLD_TO_CUST_ID = D.CUST_ID AND %Join(COMMON_KEYS, CUSTOMER D, CUSTOMER_LANG LANG) AND D.CUST_STATUS <> 'T'

  • Related Language Record for CA_RNW_CYC_VW

  • Parent record: CA_RNW_PKG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RNW_PKG_ID Character(10) VARCHAR2(10) NOT NULL PSIRS-KK
    2 RNW_CYCLE_NBR Number(6,0) INTEGER NOT NULL PSIRS-KK

    Default Value: 1

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