eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INL_MATCH_GRP dependencies on AP_INVOICE_DISTRIBUTIONS

Line 267: ap_invoice_distributions d

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'
271: AND d.invoice_id = p_invoice_id

Line 268: WHERE MInt.from_parent_table_name = 'AP_INVOICE_DISTRIBUTIONS'

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'
271: AND d.invoice_id = p_invoice_id
272: AND d.invoice_id = i.invoice_id

Line 297: ap_invoice_distributions d,

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'
301: AND MInt.from_parent_table_id = d.invoice_distribution_id

Line 298: ap_invoice_distributions d_prorat,

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'
301: AND MInt.from_parent_table_id = d.invoice_distribution_id
302: AND MInt.processing_status_code = 'PENDING'

Line 300: WHERE MInt.from_parent_table_name = 'AP_INVOICE_DISTRIBUTIONS'

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
304: AND d.invoice_id = i.invoice_id

Line 396: WHERE MInt.from_parent_table_name = 'AP_INVOICE_DISTRIBUTIONS'

392:
393:
394: UPDATE inl_matches_int MInt
395: SET match_amount_int_id = l_match_amount_int_id
396: WHERE MInt.from_parent_table_name = 'AP_INVOICE_DISTRIBUTIONS'
397: AND MInt.match_type_code = c_amounts_rec.match_type_code
398: AND MInt.processing_status_code = 'PENDING'
399: AND ( (c_amounts_rec.amount_type = 'TAX'
400: AND MInt.tax_code = c_amounts_rec.tax_code

Line 404: ap_invoice_distributions d,

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
408: AND d.invoice_id = l.invoice_id

Line 405: ap_invoice_distributions d_prorat,

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
408: AND d.invoice_id = l.invoice_id
409: AND l.line_number = d.invoice_line_number

Line 422: ap_invoice_distributions d

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
426: AND l.line_type_lookup_code IN ('MISCELLANEOUS', 'FREIGHT')

Line 563: ap_invoice_distributions d,

559: l.tax tax_code,
560: decode(l.line_type_lookup_code, 'TAX', decode(d.tax_recoverable_flag,'Y',0,d.amount), NULL) nrec_tax_amt,
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')

Line 644: l_matches_int_tbl(i).from_parent_table_name := 'AP_INVOICE_DISTRIBUTIONS';

640: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
641: p_procedure_name => l_api_name,
642: p_debug_info => l_debug_info);
643:
644: l_matches_int_tbl(i).from_parent_table_name := 'AP_INVOICE_DISTRIBUTIONS';
645: l_matches_int_tbl(i).from_parent_table_id := c_distr_rec.invoice_distribution_id;
646:
647: -- In order to make the Create Adjust process less
648: -- complex, the correction match should use the same

Line 661: l_matches_int_tbl(i).to_parent_table_name := 'AP_INVOICE_DISTRIBUTIONS';

657: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
658: p_procedure_name => l_api_name,
659: p_debug_info => l_debug_info);
660:
661: l_matches_int_tbl(i).to_parent_table_name := 'AP_INVOICE_DISTRIBUTIONS';
662: l_matches_int_tbl(i).to_parent_table_id := c_distr_rec.corrected_invoice_dist_id;
663: ELSE
664: l_debug_info := 'It is not a correction.';
665: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

Line 709: FROM ap_invoice_distributions aid,

705: SELECT ail.cost_factor_id,
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