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_SHIPMENT_PVT dependencies on INL_TAX_LINES

Line 2807: FROM inl_tax_lines tl

2803: )
2804: ;
2805: SELECT NVL (MAX (tl.tax_line_num), 0) + 1
2806: INTO l_tax_line_num
2807: FROM inl_tax_lines tl
2808: WHERE NVL (tl.ship_header_id, 0) = NVL (p_TxLn_Assoc.inl_Assoc.ship_header_id, 0) ;
2809: ELSE
2810: l_tax_line_num := p_TxLn_Assoc.tax_line_num;
2811: END IF;

Line 2826: -- Get inl_tax_lines_s.nextval

2822: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
2823: p_procedure_name => l_proc_name,
2824: p_debug_info => l_debug_info) ;
2825: --
2826: -- Get inl_tax_lines_s.nextval
2827: --
2828: l_debug_info := 'Get inl_tax_lines_s.nextval';
2829: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
2830: p_procedure_name => l_proc_name,

Line 2828: l_debug_info := 'Get inl_tax_lines_s.nextval';

2824: p_debug_info => l_debug_info) ;
2825: --
2826: -- Get inl_tax_lines_s.nextval
2827: --
2828: l_debug_info := 'Get inl_tax_lines_s.nextval';
2829: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
2830: p_procedure_name => l_proc_name,
2831: p_debug_info => l_debug_info) ;
2832: SELECT inl_tax_lines_s.nextval

Line 2832: SELECT inl_tax_lines_s.nextval

2828: l_debug_info := 'Get inl_tax_lines_s.nextval';
2829: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
2830: p_procedure_name => l_proc_name,
2831: p_debug_info => l_debug_info) ;
2832: SELECT inl_tax_lines_s.nextval
2833: INTO x_new_tax_line_id
2834: FROM dual;
2835: --
2836: -- include Tax Line record

Line 2843: INTO inl_tax_lines (

2839: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
2840: p_procedure_name => l_proc_name,
2841: p_debug_info => l_debug_info) ;
2842: INSERT
2843: INTO inl_tax_lines (
2844: tax_line_id, /* 01 */
2845: tax_line_num, /* 02 */
2846: tax_code, /* 03 */
2847: ship_header_id, /* 04 */

Line 2896: p_from_parent_table_name => 'INL_TAX_LINES',

2892:
2893: IF p_include_assoc = 'Y' THEN
2894: Create_Assoc(
2895: p_Assoc => p_TxLn_Assoc.inl_Assoc,
2896: p_from_parent_table_name => 'INL_TAX_LINES',
2897: p_new_line_id => x_new_tax_line_id,
2898: x_return_status => l_return_status
2899: )
2900: ;

Line 3029: WHERE assoc.from_parent_table_name = 'INL_TAX_LINES'

3025: AND EXISTS
3026: (
3027: SELECT 1
3028: FROM inl_associations assoc
3029: WHERE assoc.from_parent_table_name = 'INL_TAX_LINES'
3030: AND assoc.from_parent_table_id = tl.tax_line_id
3031: AND assoc.to_parent_table_name = p_comp_name
3032: AND assoc.to_parent_table_id = p_comp_id
3033: ) ;

Line 3076: l_TxLn_Assoc.source_parent_table_name := 'INL_TAX_LINES';

3072: l_TxLn_Assoc.adjustment_num := p_adjustment_num;
3073: l_TxLn_Assoc.match_id := p_match_id;
3074: l_TxLn_Assoc.matched_amt := 0;
3075: l_TxLn_Assoc.nrec_tax_amt := 0;
3076: l_TxLn_Assoc.source_parent_table_name := 'INL_TAX_LINES';
3077: FOR i IN NVL (C_est_TL.FIRST, 0) ..NVL (C_est_TL.LAST, 0)
3078: LOOP
3079: l_TxLn_Assoc.inl_Assoc.ship_header_id := C_est_TL (i) .ship_header_id;
3080: l_TxLn_Assoc.tax_code := C_est_TL (i) .tax_code;

Line 3083: l_TxLn_Assoc.source_parent_table_id := C_est_TL (i) .tax_line_id; --Unique index U2 in INL_TAX_LINES

3079: l_TxLn_Assoc.inl_Assoc.ship_header_id := C_est_TL (i) .ship_header_id;
3080: l_TxLn_Assoc.tax_code := C_est_TL (i) .tax_code;
3081: l_TxLn_Assoc.tax_line_num := C_est_TL (i) .tax_line_num;
3082: l_TxLn_Assoc.parent_tax_line_id := C_est_TL (i) .tax_line_id;
3083: l_TxLn_Assoc.source_parent_table_id := C_est_TL (i) .tax_line_id; --Unique index U2 in INL_TAX_LINES
3084: l_TxLn_Assoc.currency_code := C_est_TL (i) .currency_code;
3085: l_TxLn_Assoc.currency_conversion_type := C_est_TL (i) .currency_conversion_type;
3086: l_TxLn_Assoc.currency_conversion_date := C_est_TL (i) .currency_conversion_date;
3087: l_TxLn_Assoc.currency_conversion_rate := C_est_TL (i) .currency_conversion_rate;

Line 5382: FROM inl_tax_lines tx

5378:
5379: -- l_TxLn_Assoc.adjustment_num := p_adjustment_num;
5380: SELECT NVL (MAX (adjustment_num), 0) + 1
5381: INTO l_TxLn_Assoc.adjustment_num
5382: FROM inl_tax_lines tx
5383: WHERE tx.source_parent_table_name = l_from_parent_table_name
5384: AND tx.source_parent_table_id = l_from_parent_table_id
5385: AND tx.ship_header_id = l_ship_header_id;
5386: IF l_TxLn_Assoc.adjustment_num > 1 THEN

Line 5389: FROM inl_tax_lines tx

5385: AND tx.ship_header_id = l_ship_header_id;
5386: IF l_TxLn_Assoc.adjustment_num > 1 THEN
5387: SELECT tax_line_num, tax_line_id
5388: INTO l_TxLn_Assoc.tax_line_num, l_TxLn_Assoc.parent_tax_line_id
5389: FROM inl_tax_lines tx
5390: WHERE tx.source_parent_table_name = l_from_parent_table_name
5391: AND tx.source_parent_table_id = l_from_parent_table_id
5392: AND tx.ship_header_id = l_ship_header_id
5393: AND adjustment_num =

Line 5396: FROM inl_tax_lines tx1

5392: AND tx.ship_header_id = l_ship_header_id
5393: AND adjustment_num =
5394: (
5395: SELECT MAX (tx1.adjustment_num)
5396: FROM inl_tax_lines tx1
5397: WHERE tx1.source_parent_table_name = tx.source_parent_table_name
5398: AND tx1.source_parent_table_id = tx.source_parent_table_id
5399: AND tx1.ship_header_id = l_ship_header_id
5400: ) ;

Line 5698: p_from_parent_table_name => 'INL_TAX_LINES',

5694: p_procedure_name => l_api_name,
5695: p_var_name => l_debug_info,
5696: p_var_value => c_matches (i) .to_parent_table_id) ;
5697: Create_Assoc (p_Assoc => l_TxLn_Assoc.inl_Assoc,
5698: p_from_parent_table_name => 'INL_TAX_LINES',
5699: p_new_line_id => l_new_tax_line_id,
5700: x_return_status => l_return_status) ;
5701: END LOOP;
5702: END IF;