DBA Data[Home] [Help]

APPS.AP_APPROVAL_MATCHED_PKG dependencies on AP_INVOICE_LINES_UTILITY_PKG

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

2103: CURSOR Matched_Cur IS
2104: SELECT PLL.line_location_id,
2105: PLL.po_line_id,
2106: SUM(L.amount),
2107: NVL(AP_INVOICE_LINES_UTILITY_PKG.get_approval_status(p_invoice_id,L.line_number),'N'),
2108: --bug 5182413
2109: SUM(nvl(L.quantity_invoiced,0)),
2110: PLL.price_override, -- BUG 4123171
2111: ROUND((nvl(PLL.quantity,0) - nvl(PLL.quantity_cancelled,0)), 15),

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

2207: decode(PLL.unit_meas_lookup_code,null,PL.unit_meas_lookup_code,PLL.unit_meas_lookup_code), -- BUG 4184044
2208: L.discarded_flag,L.cancelled_flag,
2209: PLL.matching_basis,PLL.payment_type,I.invoice_type_lookup_code,
2210: I.org_id,
2211: NVL(AP_INVOICE_LINES_UTILITY_PKG.get_approval_status(p_invoice_id,L.line_number),'N');-- Bug 5182413
2212: l_line_location_id NUMBER(15);
2213: l_po_line_id NUMBER(15);
2214: l_inv_line_amount NUMBER;
2215: l_adj_qty_invoiced NUMBER;