Skip to main content
Solved

_REP Field Definitions (Report Views)

  • September 2, 2022
  • 1 reply
  • 178 views

mfrejik
Sidekick (Customer)
Forum|alt.badge.img+9
  • Sidekick (Customer)
  • 29 replies

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

 

 

Best answer by CallumW

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

1 reply

CallumW
Superhero (Partner)
Forum|alt.badge.img+16
  • Superhero (Partner)
  • 129 replies
  • Answer
  • September 2, 2022

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