DBA Data[Home] [Help]

APPS.AP_APPROVAL_MATCHED_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 2294: l_payment_type po_line_locations_all.payment_type%TYPE;

2290: l_matching_basis po_line_locations.matching_basis%TYPE; -- Amount Based Matching
2291:
2292: --Contract Payments: Tolerances Redesign
2293: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
2294: l_payment_type po_line_locations_all.payment_type%TYPE;
2295: l_billed_amt NUMBER;
2296: l_amt_delivered NUMBER;
2297: l_amt_corrected NUMBER;
2298: l_ret_status VARCHAR2(100);

Line 6542: l_line_location_id PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE;

6538: where invoice_id = p_invoice_id
6539: and po_line_location_id is not null --Bug16406697
6540: and line_type_lookup_code not in ('TAX','PREPAY');
6541:
6542: l_line_location_id PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE;
6543:
6544: --End9868268
6545:
6546: l_debug_loc VARCHAR2(30):='exec_partial_funds_check';

Line 6571: l_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;

6567: l_matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE;
6568: l_quantity_received PO_LINE_LOCATIONS.quantity_received%TYPE;
6569: l_amount_received PO_LINE_LOCATIONS.amount_received%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: