CA_RNW_LNLNK_VW

(SQL View)
 Index Back

CA-Rnw Lines Linked to Cycle

Shows lines linked to cycles and some details of the cycle itself.

SELECT LNK.RNW_PKG_ID , LNK.RNW_CYCLE_NBR , LNK.CONTRACT_NUM , LNK.CONTRACT_LINE_NUM , CYC.RNW_CYCLE_START_DT , CYC.RNW_CYCLE_END_DT , CYC.PRODUCT_ID FROM PS_CA_RNW_LN_LINK LNK , PS_CA_RNW_CYCLE CYC WHERE CYC.RNW_PKG_ID = LNK.RNW_PKG_ID AND CYC.RNW_CYCLE_NBR = LNK.RNW_CYCLE_NBR

  • Parent record: CA_RNW_CYCLE

    • # 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
    3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: CA_CNTR_SRCH_VW

    4 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    5 RNW_CYCLE_START_DT Date(10) DATE NOT NULL PSIRS-KK
    6 RNW_CYCLE_END_DT Date(10) DATE NOT NULL PSIRS-KK
    7 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: CA_PROD_RNW_VW