Payables and Cash Management - EBS (MOSC)

MOSC Banner

R12: AP_AE_LINES_ALL made obsolete ??

edited Dec 26, 2012 2:41AM in Payables and Cash Management - EBS (MOSC) 7 commentsAnswered
Hi,

With AP_AE_LINES_ALL being made obsolete in R12,what is the alternative of getting values for the column

AP_AE_LINES_ALL .subledger_doc_sequence_id

AP_AE_LINES_ALL .subledger_doc_sequence_value

--------------------------------------------------------

Are the columns

doc_sequence_id

and doc_sequence_value in

 XLA_AE_HEADERS a replacemnt for this ??

====================================================================

 

After going through TRMs,

we were able to build a R12 query like:

-----------------------------------------------------------

select f.name
        from xla.xla_ae_lines xlal,
          xla.xla_ae_headers xlah,
          fnd_document_sequences f         
   where     xlal.ae_line_num  = XX

       AND xlal.ae_header_id =  YY

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