DBA Data[Home] [Help]

APPS.AP_APPROVAL_MATCHED_PKG dependencies on AP_INVOICE_LINES_ALL

Line 304: ap_invoice_lines_all ail

300: po_line_locations PLL,
301: po_lines PL,
302: rcv_transactions RTXN,
303: rcv_shipment_lines RSL,
304: ap_invoice_lines_all ail
305: WHERE I.invoice_id = p_invoice_id
306: AND I.invoice_id = D.invoice_id
307: AND D.invoice_line_number = p_inv_line_number
308: AND D.invoice_id= ail.invoice_id

Line 2504: FROM ap_invoice_lines_all

2500: -- l_final_matching_exists := 'Y'; --bug5759169
2501:
2502: BEGIN
2503: SELECT 1 INTO l_final_match_count
2504: FROM ap_invoice_lines_all
2505: WHERE po_line_location_id = l_line_location_id
2506: AND nvl(final_match_flag,'N') in ('D','Y')
2507: AND nvl(discarded_flag,'N')<>'Y'
2508: AND nvl(cancelled_flag,'N')<>'Y'

Line 6311: FROM ap_invoice_lines_all

6307: -- bug8704810
6308: -- SELECT 'Price Difference or Quantity Has Decimals' .. bug8704810
6309: SELECT 'Price Difference' -- bug8704810
6310: INTO l_check
6311: FROM ap_invoice_lines_all
6312: WHERE invoice_id = p_invoice_id
6313: AND po_line_location_id = p_line_location_id
6314: AND unit_price <> p_po_unit_price;
6315:

Line 6574: l_po_header_id ap_invoice_lines_all.po_header_id%TYPE;

6570: l_hold_name VARCHAR2(30);
6571: l_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;
6572: l_quantity_cancelled PO_DISTRIBUTIONS_ALL.quantity_cancelled%TYPE ;
6573: l_amount_cancelled PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE ;
6574: l_po_header_id ap_invoice_lines_all.po_header_id%TYPE;
6575:
6576:
6577: BEGIN
6578: