APPS.AR_INVOICE_UTILS dependencies on AR_MEMO_LINES

Line 4413: FROM ar_memo_lines m

4409: WHERE gt.memo_line_id IS NOT NULL
4410: AND gt.line_type = 'LINE'
4411: AND NOT EXISTS (
4412: SELECT 'X'
4413: FROM ar_memo_lines m
4414: WHERE m.memo_line_id = gt.memo_line_id
4415: AND m.line_type = 'LINE'
4416: AND sysdate between start_date and nvl(end_date,sysdate) );
4417:

Line 4422: /* 4536358 - changed ar_memo_lines_all_tl to

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

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

Line 5825: FROM ar_memo_lines_vl m

5821: BEGIN
5822: UPDATE ar_trx_lines_gt gt
5823: set gt.unit_selling_price =
5824: ( SELECT m.unit_std_price
5825: FROM ar_memo_lines_vl m
5826: WHERE m.memo_line_id = gt.memo_line_id
5827: AND gt.memo_line_id IS NOT NULL
5828: AND sysdate between m.start_date and nvl(m.end_date,sysdate))
5829: WHERE gt.unit_selling_price IS NULL;

Line 5834: FROM ar_memo_lines_vl m

5830:
5831: UPDATE ar_trx_lines_gt gt
5832: set gt.uom_code =
5833: ( SELECT m.uom_code
5834: FROM ar_memo_lines_vl m
5835: WHERE m.memo_line_id = gt.memo_line_id
5836: AND gt.memo_line_id IS NOT NULL
5837: AND sysdate between m.start_date and nvl(m.end_date,sysdate))
5838: WHERE gt.uom_code IS NULL;