Receivables - EBS (MOSC)

MOSC Banner

Need help on 11i ar_location_values which is an obsolete table in R12

edited Jul 28, 2017 11:29AM in Receivables - EBS (MOSC) 4 commentsAnswered

Hi,

  We are in the process of upgrating the customer 11i instance to R12.2.6.  Can someone please help me what has to be the table and columns to replace this 11i table.

SELECT alv.location_segment_value

INTO    loc_value

FROM   ar.ar_location_values alv

WHERE 1 = 1

AND   alv.location_segment_qualifier = loc_seg_qualifier

AND   alv.location_segment_id = loc_seg_id;

Thanks in advance.

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