OMPB_COND_VW

(SQL View)
 Index Back

Customer Price Book Conditions

Customer Price Book Conditions

SELECT I.BUSINESS_UNIT , I.OMPB_BOOK_DEFN_ID , I.OMPB_BOOK_ID , I.OMPB_INSTANCE , C.SEQ_NBR , C.FIELDNAME , C.OMPB_COND_OPR , C.OMPB_COND_VAL , C.OMPB_COND_TO FROM PS_OMPB_INSTANCE I , PS_OMPB_CONDITION C WHERE %Join(COMMON_KEYS, OMPB_INSTANCE I, OMPB_CONDITION C)

  • Parent record: OMPB_BOOK_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 OMPB_BOOK_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Customer Price Book Definition ID
    3 OMPB_BOOK_ID Character(30) VARCHAR2(30) NOT NULL Customer Price Book ID
    4 OMPB_INSTANCE Number(10,0) DECIMAL(10) NOT NULL price book instance
    5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: OMPB_CNDFLD_DVW

    7 OMPB_COND_OPR Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
    <=<
    <==<=
    <>=not =
    ===
    >=>
    >==>=
    ALL=all
    BEG=begins with
    BET=between
    CON=contains
    IN=in
    8 OMPB_COND_VAL Character(128) VARCHAR2(128) NOT NULL Conditon value

    Prompt Table: %EDITTABLE20

    9 OMPB_COND_TO Character(128) VARCHAR2(128) NOT NULL Conditon value

    Prompt Table: %EDITTABLE20