0

Materialized views

Hi Team,

I have created two MV's (CUST_TRX_V,SALES_BY_CUSTOMER_MV) in the Customer Schema of my Incorta Application. Two MV's are created, i can see the records for CUST_TRX, but i can not see the records for SALES_BY_CUSTOMER_MV. 

SALES_BY_CUSTOMER_MV is dependent on first MV(CUST_TRX_V). 

Query is:

select

ooh.header_id,

ool.line_id,

ctv.customer_id,

ctv.customer_name,

ool.ORDERED_QUANTITY "ORDER_QUANTITY",

ool.UNIT_SELLING_PRICE "UNIT_SELLING_PRICE",

ool.ORDERED_QUANTITY * ool.UNIT_SELLING_PRICE "ORDER_AMOUNT"

from

Customer.CUST_TRX_V ctv,

Customer.oe_order_headers_all ooh,

Customer.oe_order_lines_all ool

where

ctv.order_number=ool.cust_po_number

AND

ooh.header_id = ool.header_id

 

Any one please help me on this.

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 3 mths agoLast active
  • 7Views
  • 1 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!