RSFM_PRODGRP_VW

(SQL View)
 Index Back

Sales Product Groups

Product Groups for a Sales User

SELECT DISTINCT PG.SETID , SU.PERSON_ID , PG.PRODUCT_GROUP , PG.DESCR , PG.DESCRSHORT , PG.EFF_STATUS , SU.MARKET , PG.SYNCID , PG.SYNCDTTM FROM PS_PROD_GROUP_TBL PG , PS_RSF_SUSER SU , PS_SET_CNTRL_REC SC WHERE PG.MARKET = 'GBL' AND SC.SETCNTRLVALUE = SU.BUSINESS_UNIT AND SC.SETID = PG.SETID AND SC.RECNAME = 'PROD_GROUP_TBL' AND PG.EFFDT = ( SELECT MAX(Y.EFFDT) FROM PS_PROD_GROUP_TBL Y WHERE Y.SETID = PG.SETID AND Y.PRODUCT_GROUP = PG.PRODUCT_GROUP AND Y.EFFDT <= %CurrentDateIn) AND PG.SYNCID = ( SELECT MAX(SYNCID) FROM PS_PROD_GROUP_TBL Z WHERE Z.SETID = PG.SETID AND Z.PRODUCT_GROUP = PG.PRODUCT_GROUP AND Z.EFFDT = PG.EFFDT )

  • Related Language Record: RSFM_PRDGRP_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.

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    3 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    7 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    8 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    9 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time