Solved

_REP Field Definitions (Report Views)

Userlevel 4

+9

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

icon

Best answer by CallumW 2 September 2022, 18:23

Userlevel 6

+15

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

Sign up