BUSINESS_UNITOMPB_BOOK_DEFN_IDOMPB_BOOK_IDOMPB_INSTANCESOLD_TO_CUST_IDPRODUCT_IDPRODUCT_UOMSEQ_NBREOEP_RANGE_IDLANGUAGE_CDOMPB_ADJFMRG_LV(SQL View) |
Index Back |
|---|---|
Customer Price Book Form RangeCustomer 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 , X.LANGUAGE_CD , X.XLATLONGNAME FROM PS_OMPB_FORM_RANGE R , PS_OMPB_PRC_ADJST A , PSXLATITEMLANG 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.EFFDT = ( SELECT MIN(X1.EFFDT) FROM PSXLATITEM X1 WHERE X.FIELDNAME = X1.FIELDNAME AND X.FIELDVALUE = X1.FIELDVALUE AND X.EFFDT <= %CurrentDateIn) |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |