[Home] [Help]
326: d.accounting_date accounting_date, -- LCM-OPM Integration Send to OPM as transaction date
327: NVL(d.reversal_flag,'N') reversal_flag, --Bug#14604983
328: count(*) over () count_recs --Bug#14604983
329: FROM rcv_transactions rt,
330: ap_invoice_distributions d,
331: ap_invoices i,
332: ap_invoice_lines l,
333: mtl_units_of_measure muom
334: WHERE l.line_type_lookup_code IN ('ITEM', 'MISCELLANEOUS', 'FREIGHT', 'TAX')
420: p_procedure_name => l_api_name,
421: p_debug_info => l_debug_info
422: );
423:
424: l_matches_int_tbl(i).from_parent_table_name := 'AP_INVOICE_DISTRIBUTIONS';
425: l_matches_int_tbl(i).from_parent_table_id := c_distr_rec.invoice_distribution_id;
426: l_matches_int_tbl(i).adj_group_date := c_distr_rec.accounting_date;
427:
428: -- In order to make the Create Adjust process less
440: p_procedure_name => l_api_name,
441: p_debug_info => l_debug_info
442: );
443:
444: l_matches_int_tbl(i).to_parent_table_name := 'AP_INVOICE_DISTRIBUTIONS';
445: l_matches_int_tbl(i).to_parent_table_id := c_distr_rec.corrected_invoice_dist_id;
446: ELSE
447: l_debug_info := 'It is not a correction.';
448: INL_LOGGING_PVT.Log_Statement (
537: SELECT ail.cost_factor_id,
538: ail.line_type_lookup_code
539: INTO l_par_cost_factor_id,
540: l_par_line_type_lookup_code
541: FROM ap_invoice_distributions aid,
542: ap_invoice_lines ail
543: WHERE aid.invoice_id = ail.invoice_id
544: AND aid.invoice_line_number = ail.line_number
545: AND aid.invoice_distribution_id = c_distr_rec.charge_applicable_to_dist_id