Skip to main content

How can I find out the source of a field in an _REP view?
 

For example, if I’m looking at CUSTOMER_ORDER_CONF_REP view - where does the CATALOG_NO field come from?

 

The SQL tab in oracle developer only references the result key lines which doesn’t really help me.

 

Thanks in advance,

Mike

 

 

Look at the _RPI package

 

Which in this case would be CUSTOMER_ORDER_CONF_RPI

 

And for completeness, CATALOG_NO comes from CUSTOMER_ORDER_LINE_TAB

 

 

Callum

Reply


Terms & ConditionsCookie settings