DBA Data[Home] [Help]

APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on PO_LINE_LOCATIONS

Line 617: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';

613: p_retainage_withheld_amt => NULL,
614: p_retainage_released_amt => NULL
615: );
616:
617: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
618: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
619: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
620: END IF;
621:

Line 8288: l_po_price po_line_locations.price_override%TYPE;

8284: l_dist_line_type VARCHAR2(25);
8285: l_inv_price ap_invoice_distributions.unit_price%TYPE;
8286: l_qty_invoiced NUMBER;
8287: l_po_qty NUMBER;
8288: l_po_price po_line_locations.price_override%TYPE;
8289: l_po_rate NUMBER;
8290: l_rtxn_rate NUMBER;
8291: l_inv_rate ap_invoices.exchange_rate%TYPE;
8292: l_match_option po_line_locations.match_option%TYPE;

Line 8292: l_match_option po_line_locations.match_option%TYPE;

8288: l_po_price po_line_locations.price_override%TYPE;
8289: l_po_rate NUMBER;
8290: l_rtxn_rate NUMBER;
8291: l_inv_rate ap_invoices.exchange_rate%TYPE;
8292: l_match_option po_line_locations.match_option%TYPE;
8293: l_rtxn_uom VARCHAR2(25);
8294: l_rtxn_item_id rcv_shipment_lines.item_id%TYPE;
8295: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;
8296: l_distribution_amt ap_invoice_distributions.amount%TYPE;

Line 8295: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;

8291: l_inv_rate ap_invoices.exchange_rate%TYPE;
8292: l_match_option po_line_locations.match_option%TYPE;
8293: l_rtxn_uom VARCHAR2(25);
8294: l_rtxn_item_id rcv_shipment_lines.item_id%TYPE;
8295: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;
8296: l_distribution_amt ap_invoice_distributions.amount%TYPE;
8297: l_dist_base_amt ap_invoice_distributions.base_amount%TYPE;
8298: l_dist_match_type ap_invoice_distributions.dist_match_type%TYPE;
8299: l_corrected_inv_dist_id NUMBER(15);

Line 8350: po_line_locations PLL,

8346: ap_invoice_distributions D,
8347: po_distributions PD,
8348: po_lines PL,
8349: po_line_types PLT, -- Amount Based Matching
8350: po_line_locations PLL,
8351: rcv_transactions RTXN,
8352: rcv_shipment_lines RSL,
8353: AP_INVOICE_LINES_ALL ail --bug#10416960
8354: WHERE AI.invoice_id = D.invoice_id

Line 8423: po_line_locations PLL,

8419: ap_invoice_distributions retain_d, --bug 9242891 retainage inv dists
8420: po_distributions PD,
8421: po_lines PL,
8422: po_line_types PLT, -- Amount Based Matching
8423: po_line_locations PLL,
8424: rcv_transactions RTXN,
8425: rcv_shipment_lines RSL
8426: WHERE AI.invoice_id = D.invoice_id
8427: AND AI.invoice_type_lookup_code = 'RETAINAGE RELEASE' --bug 9242891