DBA Data[Home] [Help]

APPS.AP_APPROVAL_MATCHED_PKG dependencies on AP_INVOICE_LINES_UTILITY_PKG

Line 1879: NVL(AP_INVOICE_LINES_UTILITY_PKG.get_approval_status(p_invoice_id,L.line_number),'N'),

1875: CURSOR Matched_Cur IS
1876: SELECT PLL.line_location_id,
1877: PLL.po_line_id,
1878: SUM(L.amount),
1879: NVL(AP_INVOICE_LINES_UTILITY_PKG.get_approval_status(p_invoice_id,L.line_number),'N'),
1880: --bug 5182413
1881: SUM(nvl(L.quantity_invoiced,0)),
1882: PLL.price_override, -- BUG 4123171
1883: ROUND((nvl(PLL.quantity,0) - nvl(PLL.quantity_cancelled,0)), 15),

Line 1983: NVL(AP_INVOICE_LINES_UTILITY_PKG.get_approval_status(p_invoice_id,L.line_number),'N');-- Bug 5182413

1979: decode(PLL.unit_meas_lookup_code,null,PL.unit_meas_lookup_code,PLL.unit_meas_lookup_code), -- BUG 4184044
1980: L.discarded_flag,L.cancelled_flag,
1981: PLL.matching_basis,PLL.payment_type,I.invoice_type_lookup_code,
1982: I.org_id,
1983: NVL(AP_INVOICE_LINES_UTILITY_PKG.get_approval_status(p_invoice_id,L.line_number),'N');-- Bug 5182413
1984: l_line_location_id NUMBER(15);
1985: l_po_line_id NUMBER(15);
1986: l_inv_line_amount NUMBER;
1987: l_adj_qty_invoiced NUMBER;