OMPB_ADJFMRG_VW

(SQL View)
 Index Back

Customer Price Book Form Range

Customer Price Book Formula Range

SELECT R.BUSINESS_UNIT , R.OMPB_BOOK_DEFN_ID , R.OMPB_BOOK_ID , R.OMPB_INSTANCE , A.SOLD_TO_CUST_ID , A.PRODUCT_ID , A.UNIT_OF_MEASURE , A.SEQ_NBR , R.EOEP_RANGE_ID , A.OMPB_ACTIVE_ROW , X.XLATLONGNAME , R.PRICE_TYPE , R.EOEP_MIN_AMOUNT , R.EOEP_MAX_AMOUNT FROM PS_OMPB_FORM_RANGE R , PS_OMPB_PRC_ADJST A , PSXLATITEM X WHERE %Join(COMMON_KEYS, OMPB_PRC_ADJST A, OMPB_FORM_RANGE R) AND A.EOEP_RULE_ID = R.EOEP_RULE_ID AND A.EOEP_FORMULA_ID = R.EOEP_FORMULA_ID AND A.OMPB_ACTIVE_ROW = R.OMPB_ACTIVE_ROW AND X.FIELDNAME = 'PRICE_TYPE' AND X.FIELDVALUE = R.PRICE_TYPE AND X.EFF_STATUS = 'A' AND X.EFFDT = ( SELECT MIN(X1.EFFDT) FROM PSXLATITEM X1 WHERE X.FIELDNAME = X1.FIELDNAME AND X.FIELDVALUE = X1.FIELDVALUE AND X.EFFDT <= %CurrentDateIn)

  • Related Language Record: OMPB_ADJFMRG_LV

  • Parent record: OMPB_PRCADJ_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 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    7 PRODUCT_UOM Character(3) VARCHAR2(3) NOT NULL Product Unit of Measure
    8 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    9 EOEP_RANGE_ID Number(10,0) DECIMAL(10) NOT NULL Range ID
    10 OMPB_ACTIVE_ROW Character(1) VARCHAR2(1) NOT NULL Flag to indicate if the row in the extract table is avtive/valid data. This is not really the same as effective date/status related.
    1=Active Row
    2=Inactive Row
    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    12 PRICE_TYPE Character(2) VARCHAR2(2) NOT NULL Price Type
    P=Extended Price
    Q=Quantity
    V=Volume
    W=Weight
    13 EOEP_MIN_AMOUNT Signed Number(19,4) DECIMAL(17,4) NOT NULL Minimum Amount
    14 EOEP_MAX_AMOUNT Signed Number(19,4) DECIMAL(17,4) NOT NULL Maximum Amount