DBA Data[Home] [Help]

APPS.AR_INVOICE_UTILS dependencies on AR_MEMO_LINES_VL

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;