DBA Data[Home] [Help]

APPS.AR_INVOICE_UTILS dependencies on AR_MEMO_LINES_TL

Line 4529: ar_memo_lines_tl. Removed rownum = 1. This was

4525: /*This update should be fired only when the description isn't populated
4526: initially*/
4527:
4528: /* 4536358 - changed ar_memo_lines_all_tl to
4529: ar_memo_lines_tl. Removed rownum = 1. This was
4530: just masking issues that would arise due to
4531: cartesian join. */
4532:
4533: UPDATE ar_trx_lines_gt gt

Line 4535: FROM ar_memo_lines_tl

4531: cartesian join. */
4532:
4533: UPDATE ar_trx_lines_gt gt
4534: SET description = ( SELECT description
4535: FROM ar_memo_lines_tl
4536: WHERE memo_line_id = gt.memo_line_id
4537: AND language = USERENV('LANG')
4538: AND rownum = 1)
4539: WHERE gt.memo_line_id IS NOT NULL