407: DEV NOTE:
408:
409: 1) What happens to legacy tax lines? By that I mean tax lines that
410: are autotax=N and predate etax. Are they converted? Can I assume
411: that the fab-five columns in zx_lines will be populated?
412:
413: sent email 04/06/05 to harsh/isaac
414: RESP: Harsh says legacy lines are converted too. Yes, those columns
415: will be populated.
486: 0 -- 4698302
487: FROM
488: RA_CUSTOMER_TRX_LINES orig_line,
489: RA_CUSTOMER_TRX_LINES orig_tax,
490: ZX_LINES orig_etax
491: WHERE
492: orig_line.customer_trx_line_id = p_original_line_id
493: AND orig_line.customer_trx_line_id = orig_tax.link_to_cust_trx_line_id
494: AND orig_tax.line_type = 'TAX'
577: zxt.taxable_amt,
578: tax_rate_id,
579: zxt.tax_line_id,
580: plin.org_id
581: FROM ZX_LINES zxt,
582: RA_CUSTOMER_TRX_LINES plin
583: WHERE plin.request_id = p_request_id
584: AND zxt.application_id = 222
585: AND zxt.entity_code = 'TRANSACTIONS'
592:
593: IF l_rows > 0
594: THEN
595: /* Stamp transaction lines with tax_classification
596: from ZX_LINES_DET_FACTORS */
597: arp_etax_util.set_default_tax_classification(p_request_id);
598:
599: /* adjust for inclusive tax */
600: arp_etax_util.adjust_for_inclusive_tax(null, p_request_id, 'INV');