PROD_NOTREJ_VW

(SQL View)
 Index Back

Product Not Rejected View


SELECT A.SETID ,A.PRODUCT_ID ,A.DESCR ,A.DESCR254 ,A.PRODUCT_KIT_FLAG FROM PS_PROD_ITEM A WHERE A.EFF_STATUS = 'A' AND NOT EXISTS ( SELECT 'x' FROM ps_message_tbl ms , ps_prod_msg pm WHERE pm.setid = a.setid AND pm.product_id = a.product_id AND ms.setid = ( SELECT setid FROM ps_set_cntrl_rec WHERE setcntrlvalue = pm.setid AND recname = 'MESSAGE_TBL') AND ms.message_cd = pm.message_cd AND ms.message_action = 'H' AND ms.eff_status = 'A' AND %EffdtCheck(message_tbl ms2, ms, %CurrentDateIn))

  • Related Language Record: PROD_ITEM_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: PROD_ITEM

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    5 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit