RSF_OPP_PRDGP_V

(SQL View)
 Index Back

Opportunity Prod Group Vw

View to get the product group descriptions for opportunity

SELECT DISTINCT C.OPPORTUNITY_ID , A.PRODUCT_GROUP , A.SETID , A.DESCR FROM PS_PROD_GROUP_TBL A , PS_RSF_OPP_PRODUCT B , PS_RSF_OPPORTUNITY C WHERE A.PRODUCT_GROUP = B.PRODUCT_GROUP AND A.SETID = C.PROD_SETID AND B.OPPORTUNITY_ID = C.OPPORTUNITY_ID AND A.EFFDT >= ( SELECT MAX(EFFDT) FROM PS_PROD_GROUP_TBL X WHERE A.PRODUCT_GROUP = X.PRODUCT_GROUP AND A.SETID = X.SETID AND X.EFFDT <= %CurrentDateIn)

  • Related Language Record: RSF_OP_PRDGP_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
    2 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
    3 PROD_SETID Character(5) VARCHAR2(5) NOT NULL Product SET ID
    4 PRODGROUPDESCR Character(30) VARCHAR2(30) NOT NULL Description