CA_OFFRNW_LANG

(SQL View)
 Index Back

CA-OfferingIDs for RnwPkgs

PSIRS-KK This view lists the Offering IDs available for a Renewal Package cycle. Note: The Offering ID associated with a Renewal Package cycle does NOT have to be a renewable offering.

SELECT A.setid , A.product_id , LANG.LANGUAGE_CD , A.descr FROM PS_PROD_ITEM A , PS_PROD_ITEM_LNG LANG WHERE A.eff_status = 'A' AND A.pricing_structure <> 'RATE' AND a.renewable = 'Y' AND %Join(COMMON_KEYS, PROD_ITEM A , PROD_ITEM_LNG LANG )

  • Related Language Record for CA_PROD_RNW_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description