CA_RNW_CYC_VW

(SQL View)
Index Back

CA-Renewal Cycles


SELECT A.RNW_PKG_ID , B.RNW_CYCLE_NBR , A.DESCR , A.TARGET_CONTRACT , A.RNW_PKG_STATUS , C.SOLD_TO_CUST_ID , D.NAME1 , A.CURRENT_CYCLE_NBR , B.RNW_CYCLE_STATUS , B.RNW_CYCLE_START_DT , B.PRODUCT_ID FROM PS_CA_RNW_PKG A , PS_CA_RNW_CYCLE B , PS_CA_CONTR_HDR C , PS_CUSTOMER D 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 D.CUST_STATUS <> 'T'

  • Related Language Record: CA_RNW_CYC_LANG
  • 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

    Prompt Table: CA_RNW_PKG

    2 RNW_CYCLE_NBR Number(6,0) INTEGER NOT NULL PSIRS-KK

    Default Value: 1

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 TARGET_CONTRACT Character(25) VARCHAR2(25) NOT NULL PSIRS-KK

    Prompt Table: CA_CNTR_SRCH_VW

    5 RNW_PKG_STATUS Character(4) VARCHAR2(4) NOT NULL PSIRS-KK
    CAN=Canceled
    PND=Pending
    PRG=In Progress
    6 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

    Prompt Table: CUST_SLD_VW

    7 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    8 CURRENT_CYCLE_NBR Number(6,0) INTEGER NOT NULL PSIRS-KK
    9 RNW_CYCLE_STATUS Character(4) VARCHAR2(4) NOT NULL PSIRS-KK
    DON=Done
    PND=Pending
    RDY=Ready

    Default Value: PND

    10 RNW_CYCLE_START_DT Date(10) DATE PSIRS-KK
    11 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID