AUC_EXT_BF_CMTS

(SQL View)
 Index Back

External Comments View

View to obtain auction comments

SELECT a.business_unit , a.auc_id , a.auc_round , a.auc_version , a.bid_factor_nbr , a.public_flg , a.allow_modify , a.award_view_flg , b.comments_2000 FROM ps_auc_comments a , PS_COMMENTS_TBL b WHERE a.line_nbr = 0 AND a.bid_factor_nbr > 0 AND a.comment_type = 'BF' AND b.oprid = a.oprid AND b.comment_id = a.comment_id AND b.random_cmmt_nbr = a.random_cmmt_nbr

  • Parent record: AUC_LINE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
    3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
    4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
    5 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
    6 PUBLIC_FLG Character(1) VARCHAR2(1) NOT NULL Send to Vendor

    Y/N Table Edit

    Default Value: N

    7 ALLOW_MODIFY Character(1) VARCHAR2(1) NOT NULL Allow Modify Comments

    Y/N Table Edit

    Default Value: Y

    8 AWARD_VIEW_FLG Character(1) VARCHAR2(1) NOT NULL Award View

    Y/N Table Edit

    Default Value: N

    9 COMMENTS_2000 Long Character CLOB Comment Text