Projects - EBS (MOSC)

MOSC Banner

Cancelled Draft Invoice Links to EI's

edited Mar 29, 2014 12:00PM in Projects - EBS (MOSC) 1 commentAnswered

When I cancel an invoice, the line details delink from pa_cust_rev_dist_lines_all.  The cancellation invoice subsequently also does nto ahve a link to these items in this table.  I need to be able for both the original invoice and cancellation invoice get to the EI details so that I can write a program that will pick this up; can someone guide me how I can do this?

Example

Proj1

Inv 1

I cancel Inv 1 and now have

Cancellation Inv 2

I need to be able to write a query to get to the EI for both Inv 1 and Inv 2

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