Price List Alert View

OM_PWC_PLST_VW

(SQL View)
Index Back

SELECT DISTINCT A.SETID ,A.PRICE_LIST_ID , B.DESCR ,A.CURRENCY_CD ,A.PRODUCT_ID ,A.UNIT_OF_MEASURE ,A.START_DT ,A.END_DATE ,A.BREAK_QTY_LOW ,A.BREAK_QTY_HIGH ,A.LIST_PRICE , A.PRICE_PROTECTED , %DateDiff(END_DATE, %CurrentDateIn) , A.EFF_STATUS FROM %Table(EOEP_PRICE_LIST) A , %Table(EOEP_PRCLST_HDR) B WHERE A.SETID = B.SETID AND A.PRICE_LIST_ID = B.PRICE_LIST_ID AND A.CURRENCY_CD = B.CURRENCY_CD AND A.EFF_STATUS = 'A' AND %DateDiff(END_DATE, %CurrentDateIn) >=1

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

Prompt Table: SP_SETID_NONVW

2 PRICE_LIST_ID Character(10) VARCHAR2(10) NOT NULL Price List ID

Prompt Table: EOEP_PRLSTID_VW

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
6 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
7 START_DT Date(10) DATE Start Date
8 END_DATE Date(10) DATE End Date
9 BREAK_QTY_LOW Number(15,4) DECIMAL(14,4) NOT NULL Low Quantity/Amount

Default Value: 0

10 BREAK_QTY_HIGH Number(15,4) DECIMAL(14,4) NOT NULL Upper Quantity/Amount
11 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
12 PRICE_PROTECTED Character(1) VARCHAR2(1) NOT NULL Price Protected

Y/N Table Edit

13 OM_PWC_EXPIRE_DAYS Number(10,0) DECIMAL(10) NOT NULL Expiration Days
14 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive