Retail Merchandising System (MOSC)

MOSC Banner

Need to understand the significance of Display id field in ORPM

edited Oct 19, 2010 4:36AM in Retail Merchandising System (MOSC) 2 commentsAnswered
Hi All,

I need a clarification pertaining to the display id field which we are having in OPRM tables. RPM_CLEARANCE, RPM_PRICE_CHANGE,RPM_PROMOTION. In literal terms, its the id that would be used by the end user to search the respective price events. But i still want to understand the significance of having a seperate column for eg. clearance_display_id. Why can't we make the functionality only with clearance_id?

Based on my understanding, the clearance_display_id is getting used in the below way:

1. Create a clearance and don't approve. RPM_CLEARANCE table will have a record inserted.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center