RT_PROD_OFFR_V2

(SQL View)
 Index Back

Product Offer Detail View

View of Products from an Offer for Details display

SELECT A.SETID , A.RA_OFFER_ID , A.RA_OFFER_NAME , A.RA_OFFER_STATUS , A.PRICE_SET_ID , B.RA_DISCOUNT_TYPE , A.START_DATE , A.END_DATE , D.SETID , D.PRODUCT_ID , D.DESCR , D.MODEL_NBR , D.DESCR254 , E.DESCR_EXT , E.DESCRLONG_EXT FROM PS_RA_OFFER A , PS_RA_OFFER_PRCSET B , PS_RA_OFFER_PRODCT C , PS_PROD_ITEM D , PS_PROD_EXT_DESCR E WHERE A.SETID = B.SETID AND A.PRICE_SET_ID = B.PRICE_SET_ID AND A.RA_OFFER_ID = B.RA_OFFER_ID AND B.SETID = C.SETID AND B.PRICE_SET_ID = C.PRICE_SET_ID AND C.SETID = D.SETID AND C.PRODUCT_ID = D.PRODUCT_ID AND D.SETID = E.SETID(+) AND D.PRODUCT_ID = E.PRODUCT_ID(+)

  • Related Language Record: RT_PRODOFR_LNG2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Prompt Table: SP_SETID_NONVW

    2 RA_OFFER_ID Character(15) VARCHAR2(15) NOT NULL Marketing Offer ID
    3 RA_OFFER_NAME Character(50) VARCHAR2(50) NOT NULL Marketing Offer Name
    4 RA_OFFER_STATUS Character(4) VARCHAR2(4) NOT NULL Marketing Offer status
    ARCH=Archived
    CMPL=Completed
    DECL=Declined
    IREV=In Review
    NEW=New
    PLAN=Planning
    5 PRICE_SET_ID Character(10) VARCHAR2(10) NOT NULL Price Set ID
    6 RA_DISCOUNT_TYPE Character(4) VARCHAR2(4) NOT NULL Marketing - Offer - Discount Type
    GIVE=Giveaway
    NONE=No Discount
    STD=Standard Discount
    TIER=Tiered Pricing
    7 START_DATE Date(10) DATE Start Date for Gen Standing PO
    8 END_DATE Date(10) DATE End date field to store an end date.
    9 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID
    10 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    11 PRODUCT_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description
    12 MODEL_NBR Character(18) VARCHAR2(18) NOT NULL Model number field to store model number value.
    13 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    14 DESCR_EXT Character(50) VARCHAR2(50) NOT NULL External Description
    15 DESCRLONG_EXT Long Character CLOB Long External Description