PRODKIT_PRC_VW

(SQL View)
Index Back

Component List Price View


SELECT DISTINCT PC.SETID , PP.CURRENCY_CD , PP.PRODUCT_ID , PP.LIST_PRICE , PP.UNIT_OF_MEASURE , PP.BUSINESS_UNIT_IN , PP.EFFDT FROM PS_PROD_PRICE PP , PS_PRODKIT_COMPS PC WHERE PP.SETID = PC.SETID AND PP.PRODUCT_ID = PC.PROD_COMPONENT_ID AND PP.UNIT_OF_MEASURE = PC.UNIT_OF_MEASURE AND (PP.EFFDT = ( SELECT MAX(EFFDT) FROM PS_PROD_PRICE PP2 WHERE PP2.SETID = PP.SETID AND PP2.PRODUCT_ID = PP.PRODUCT_ID AND PP2.BUSINESS_UNIT_IN = PP.BUSINESS_UNIT_IN AND PP2.UNIT_OF_MEASURE = PP.UNIT_OF_MEASURE AND PP2.CURRENCY_CD = PP.CURRENCY_CD AND PP2.EFFDT <= %CurrentDateIn) OR (PP.EFFDT <= PC.DATE_OBSOLETE AND PP.EFFDT > %CurrentDateIn))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
2 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
3 PROD_COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL Field is used to store components of a product
4 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
5 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
CS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
6 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
7 EFFDT Date(10) DATE Effective Date

Default Value: %date