Receivables - EBS (MOSC)

MOSC Banner

what is the replacement for org_id column of AR_VAT_TAX_ALL in ZX_RATES_B of R12

edited Aug 31, 2015 10:00AM in Receivables - EBS (MOSC) 1 commentAnswered

Hi ,we are using org_id in where condition of one query in our package , we commented the line org_id=ln_org_id as there is no org_id column in ZX_RATES_B . Due to this, we are getting multiple records, how can we eradicate this issue , do we need to set MO_GLOBAL.set_policy_context in our package so that it will return as it used to return for the AR_VAT_TAX_ALL. please suggest

SELECT tax_rate_id

INTO lt_trx_line_tbl(ln_trx_line_tbl_index).vat_tax_id

FROM   zx_rates_b

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