RA_PROD_OFFR_VW

(SQL View)
 Index Back

Product Offer Detail View


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 FROM PS_RA_OFFER A , PS_RA_OFFER_PRCSET B , PS_RA_OFFER_PRODCT C , PS_PROD_ITEM D 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

  • Related Language Record: RA_PRODOFFR_LNG

    • # 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.
    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