APPS.AR_INVOICE_UTILS dependencies on AR_MEMO_LINES

Line 4519: FROM ar_memo_lines m

4515: WHERE gt.memo_line_id IS NOT NULL
4516: AND gt.line_type = 'LINE'
4517: AND NOT EXISTS (
4518: SELECT 'X'
4519: FROM ar_memo_lines m
4520: WHERE m.memo_line_id = gt.memo_line_id
4521: AND m.line_type = 'LINE'
4522: AND sysdate between start_date and nvl(end_date,sysdate) );
4523:

Line 4528: /* 4536358 - changed ar_memo_lines_all_tl to

4524: /*Bug 3844408*/
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:

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

Line 5952: FROM ar_memo_lines_vl m

5948: BEGIN
5949: UPDATE ar_trx_lines_gt gt
5950: set gt.unit_selling_price =
5951: ( SELECT m.unit_std_price
5952: FROM ar_memo_lines_vl m
5953: WHERE m.memo_line_id = gt.memo_line_id
5954: AND gt.memo_line_id IS NOT NULL
5955: AND sysdate between m.start_date and nvl(m.end_date,sysdate))
5956: WHERE gt.unit_selling_price IS NULL;

Line 5961: FROM ar_memo_lines_vl m

5957:
5958: UPDATE ar_trx_lines_gt gt
5959: set gt.uom_code =
5960: ( SELECT m.uom_code
5961: FROM ar_memo_lines_vl m
5962: WHERE m.memo_line_id = gt.memo_line_id
5963: AND gt.memo_line_id IS NOT NULL
5964: AND sysdate between m.start_date and nvl(m.end_date,sysdate))
5965: WHERE gt.uom_code IS NULL;