what is the replacement for org_id column of AR_VAT_TAX_ALL in ZX_RATES_B of R12
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