DBA Data[Home] [Help]

APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on PO_LINE_LOCATIONS

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

605: p_retainage_withheld_amt => NULL,
606: p_retainage_released_amt => NULL
607: );
608:
609: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
610: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
611: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
612: END IF;
613:

Line 6789: l_po_price po_line_locations.price_override%TYPE;

6785: l_dist_line_type VARCHAR2(25);
6786: l_inv_price ap_invoice_distributions.unit_price%TYPE;
6787: l_qty_invoiced NUMBER;
6788: l_po_qty NUMBER;
6789: l_po_price po_line_locations.price_override%TYPE;
6790: l_po_rate NUMBER;
6791: l_rtxn_rate NUMBER;
6792: l_inv_rate ap_invoices.exchange_rate%TYPE;
6793: l_match_option po_line_locations.match_option%TYPE;

Line 6793: l_match_option po_line_locations.match_option%TYPE;

6789: l_po_price po_line_locations.price_override%TYPE;
6790: l_po_rate NUMBER;
6791: l_rtxn_rate NUMBER;
6792: l_inv_rate ap_invoices.exchange_rate%TYPE;
6793: l_match_option po_line_locations.match_option%TYPE;
6794: l_rtxn_uom VARCHAR2(25);
6795: l_rtxn_item_id rcv_shipment_lines.item_id%TYPE;
6796: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;
6797: l_distribution_amt ap_invoice_distributions.amount%TYPE;

Line 6796: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;

6792: l_inv_rate ap_invoices.exchange_rate%TYPE;
6793: l_match_option po_line_locations.match_option%TYPE;
6794: l_rtxn_uom VARCHAR2(25);
6795: l_rtxn_item_id rcv_shipment_lines.item_id%TYPE;
6796: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;
6797: l_distribution_amt ap_invoice_distributions.amount%TYPE;
6798: l_dist_base_amt ap_invoice_distributions.base_amount%TYPE;
6799: l_dist_match_type ap_invoice_distributions.dist_match_type%TYPE;
6800: l_corrected_inv_dist_id NUMBER(15);

Line 6849: po_line_locations PLL,

6845: ap_invoice_distributions D,
6846: po_distributions PD,
6847: po_lines PL,
6848: po_line_types PLT, -- Amount Based Matching
6849: po_line_locations PLL,
6850: rcv_transactions RTXN,
6851: rcv_shipment_lines RSL
6852: WHERE AI.invoice_id = D.invoice_id
6853: AND D.invoice_distribution_id = X_distribution_id