OM_MCP_PPROD_VW

(SQL View)
Index Back

Price Mass Maintena

View for Price List Filter

SELECT DISTINCT B.OPRID , A.PRODUCT_ID ,A.DESCR FROM PS_PROD_ITEM A , PS_OM_MCP_PPRC_DTL B WHERE A.SETID = B.SETID AND A.PRODUCT_ID = B.PRODUCT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description