DBA Data[Home] [Help]

APPS.AR_INVOICE_UTILS dependencies on AR_MEMO_LINES_VL

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;