Payables and Cash Management - EBS (MOSC)

MOSC Banner

replace of columns in R12 for ae_headers_all

edited Nov 22, 2012 11:14PM in Payables and Cash Management - EBS (MOSC) 4 commentsAnswered

Hi Team,

 In 11i  we are using in query ap_ae_headers_all (source_table  , gl_transfer_flag ,gl_transfer_run_id)  . Can i know what is the replace of this columns in R12.

And moreover using this belwo query , Could you please help what is the replacememt in R12

SELECT acaa.allocated_amount
                                FROM   ap_invoice_distributions_all axa,
                         ap_chrg_allocations_all      acd                  WHERE  axa.item_dist_id      =:invocie_id

                  AND    aida.invoice_id        =:invocie_id                  AND   axa.cancellation_flag = 'Y'
                  AND    line_type_lookup_code  = 'TAX'
                  AND    acd.charge_dist_id    = axa.parent_reversal_id;

Thanks & Regards

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