[Home] [Help]
262: NULL tax_cost_factor_id, --Tax Prorate should be the same basis of its charge
263: 'CHARGE' amount_type
264: FROM inl_matches_int MInt,
265: ap_invoices i,
266: ap_invoice_lines l,
267: ap_invoice_distributions d
268: WHERE MInt.from_parent_table_name = 'AP_INVOICE_DISTRIBUTIONS'
269: AND MInt.from_parent_table_id = d.invoice_distribution_id
270: AND MInt.processing_status_code = 'PENDING'
292: l_prorat.cost_factor_id tax_cost_factor_id, --Tax Prorate should be the same basis of its charge
293: 'TAX' amount_type
294: FROM inl_matches_int MInt,
295: ap_invoices i,
296: ap_invoice_lines l,
297: ap_invoice_distributions d,
298: ap_invoice_distributions d_prorat,
299: ap_invoice_lines l_prorat
300: WHERE MInt.from_parent_table_name = 'AP_INVOICE_DISTRIBUTIONS'
295: ap_invoices i,
296: ap_invoice_lines l,
297: ap_invoice_distributions d,
298: ap_invoice_distributions d_prorat,
299: ap_invoice_lines l_prorat
300: WHERE MInt.from_parent_table_name = 'AP_INVOICE_DISTRIBUTIONS'
301: AND MInt.from_parent_table_id = d.invoice_distribution_id
302: AND MInt.processing_status_code = 'PENDING'
303: AND d.invoice_id = p_invoice_id
399: AND ( (c_amounts_rec.amount_type = 'TAX'
400: AND MInt.tax_code = c_amounts_rec.tax_code
401: AND MInt.from_parent_table_id
402: IN (SELECT d.invoice_distribution_id
403: FROM ap_invoice_lines l,
404: ap_invoice_distributions d,
405: ap_invoice_distributions d_prorat,
406: ap_invoice_lines l_prorat
407: WHERE d.invoice_id = p_invoice_id
402: IN (SELECT d.invoice_distribution_id
403: FROM ap_invoice_lines l,
404: ap_invoice_distributions d,
405: ap_invoice_distributions d_prorat,
406: ap_invoice_lines l_prorat
407: WHERE d.invoice_id = p_invoice_id
408: AND d.invoice_id = l.invoice_id
409: AND l.line_number = d.invoice_line_number
410: AND l.line_type_lookup_code = 'TAX'
417: )OR(c_amounts_rec.amount_type = 'CHARGE'
418: AND MInt.charge_line_type_id = c_amounts_rec.cost_factor_id
419: AND MInt.from_parent_table_id
420: IN (SELECT d.invoice_distribution_id
421: FROM ap_invoice_lines l,
422: ap_invoice_distributions d
423: WHERE d.invoice_id = p_invoice_id
424: AND d.invoice_id = l.invoice_id
425: AND l.line_number = d.invoice_line_number
561: decode(l.line_type_lookup_code, 'TAX', 'N', NULL) tax_amt_included_flag
562: FROM rcv_transactions rt,
563: ap_invoice_distributions d,
564: ap_invoices i,
565: ap_invoice_lines l,
566: mtl_units_of_measure muom
567: WHERE l.line_type_lookup_code IN ('ITEM', 'MISCELLANEOUS', 'FREIGHT', 'TAX')
568: AND d.match_status_flag = 'S'
569: AND rt.lcm_shipment_line_id IS NOT NULL
671: END IF;
672:
673: IF c_distr_rec.line_type = 'ITEM' OR c_distr_rec.correction_type = 'ITEM' THEN
674: -- The distribution cursor does not get IPV lines
675: -- To get the exact qty and amt we access the ap_invoice_lines
676: l_matches_int_tbl(i).charge_line_type_id := NULL;
677: l_matches_int_tbl(i).matched_qty := l_quantity_invoiced; --c_distr_rec.quantity_invoiced;
678: l_matches_int_tbl(i).matched_uom_code := c_distr_rec.uom_code;
679: l_matches_int_tbl(i).matched_amt := l_line_amount; --c_distr_rec.distr_amount;
706: ail.line_type_lookup_code
707: INTO l_par_cost_factor_id,
708: l_par_line_type_lookup_code
709: FROM ap_invoice_distributions aid,
710: ap_invoice_lines ail
711: WHERE aid.invoice_id = ail.invoice_id
712: AND aid.invoice_line_number = ail.line_number
713: AND aid.invoice_distribution_id = c_distr_rec.charge_applicable_to_dist_id
714: AND aid.invoice_id = c_distr_rec.invoice_id;