APPS.AP_APPROVAL_MATCHED_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1578: (select 1 from ap_invoice_distributions_all aid1

1574: AND RTXN.shipment_line_id = RSL.shipment_line_id(+)
1575:
1576: --9564576 Added the below condition
1577: AND exists
1578: (select 1 from ap_invoice_distributions_all aid1
1579: where NVL(aid1.match_status_flag , 'N') <> 'A'
1580: and aid1.invoice_id=D.invoice_id /*Bug 15968233*/
1581: and aid1.po_distribution_id = PD.po_distribution_id
1582: and aid1.line_type_lookup_code IN ('ITEM' , 'ACCRUAL')

Line 1744: UPDATE ap_invoice_distributions_all aid

1740:
1741: l_qv_ratio := l_qv_upd/l_amount_upd;
1742: l_base_qv_ratio := l_base_qv_upd/l_base_amount_upd;
1743:
1744: UPDATE ap_invoice_distributions_all aid
1745: SET quantity_variance = ap_utilities_pkg.ap_round_currency
1746: (aid.amount * l_qv_ratio, p_inv_currency_code)
1747: ,base_quantity_variance = ap_utilities_pkg.ap_round_currency
1748: (aid.base_amount * l_base_qv_ratio, p_base_currency_code)

Line 2000: UPDATE ap_invoice_distributions_all aid

1996:
1997: l_av_ratio := l_av_upd/l_amount_upd;
1998: l_base_av_ratio := l_base_av_upd/l_base_amount_upd;
1999:
2000: UPDATE ap_invoice_distributions_all aid
2001: SET amount_variance = ap_utilities_pkg.ap_round_currency
2002: (aid.amount * l_av_ratio, p_inv_currency_code)
2003: ,base_amount_variance = ap_utilities_pkg.ap_round_currency
2004: (aid.base_amount * l_base_av_ratio, p_base_currency_code)