DBA Data[Home] [Help]

APPS.AR_INVOICE_UTILS dependencies on AR_MEMO_LINES_TL

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

4419: /*This update should be fired only when the description isn't populated
4420: initially*/
4421:
4422: /* 4536358 - changed ar_memo_lines_all_tl to
4423: ar_memo_lines_tl. Removed rownum = 1. This was
4424: just masking issues that would arise due to
4425: cartesian join. */
4426:
4427: UPDATE ar_trx_lines_gt gt

Line 4429: FROM ar_memo_lines_tl

4425: cartesian join. */
4426:
4427: UPDATE ar_trx_lines_gt gt
4428: SET description = ( SELECT description
4429: FROM ar_memo_lines_tl
4430: WHERE memo_line_id = gt.memo_line_id
4431: AND language = USERENV('LANG')
4432: AND rownum = 1)
4433: WHERE gt.memo_line_id IS NOT NULL