DBA Data[Home] [Help]

APPS.AP_ISP_UTILITIES_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 1722: l_matching_basis po_line_locations_all.matching_basis%TYPE;

1718: l_amount ap_invoice_lines_all.amount%TYPE;
1719: l_billed ap_invoice_lines_all.amount%TYPE;
1720: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
1721: l_amount_ordered ap_invoice_lines_all.amount%TYPE;
1722: l_matching_basis po_line_locations_all.matching_basis%TYPE;
1723: l_overbill_flag VARCHAR2(2);
1724: l_curr_calling_sequence VARCHAR2(2000);
1725: l_debug_info VARCHAR2(2000);
1726: l_api_name VARCHAR2(50);

Line 1755: from po_line_locations_all

1751: decode(matching_basis, 'AMOUNT', amount_billed, quantity_billed)),
1752: matching_basis, quantity, amount
1753: into l_billed, l_matching_basis,
1754: l_quantity_ordered, l_amount_ordered
1755: from po_line_locations_all
1756: where line_location_id = l_po_line_location_id;
1757:
1758: if ( l_matching_basis = 'AMOUNT' ) then
1759: if ( l_amount + l_billed > l_amount_ordered ) then

Line 2029: FROM po_line_locations_all

2025: AND invoice_line_number = p_line_number;
2026:
2027: SELECT matching_basis
2028: INTO l_matching_basis
2029: FROM po_line_locations_all
2030: WHERE line_location_id = p_line_location_id;
2031:
2032: l_debug_info := 'Populate the pl/sql table with proration data';
2033: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN