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 4715: FROM inl_tax_lines tl

4711: )
4712: ;
4713: SELECT NVL (MAX (tl.tax_line_num), 0) + 1
4714: INTO l_tax_line_num
4715: FROM inl_tax_lines tl
4716: WHERE NVL (tl.ship_header_id, 0) = NVL (p_TxLn_Assoc.inl_Assoc.ship_header_id, 0) ;
4717: ELSE
4718: l_tax_line_num := p_TxLn_Assoc.tax_line_num;
4719: END IF;

Line 4735: -- Get inl_tax_lines_s.nextval

4731: p_module_name => g_module_name,
4732: p_procedure_name => l_program_name,
4733: p_debug_info => l_debug_info) ;
4734: --
4735: -- Get inl_tax_lines_s.nextval
4736: --
4737: l_debug_info := 'Get inl_tax_lines_s.nextval';
4738: INL_LOGGING_PVT.Log_Statement (
4739: p_module_name => g_module_name,

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

4733: p_debug_info => l_debug_info) ;
4734: --
4735: -- Get inl_tax_lines_s.nextval
4736: --
4737: l_debug_info := 'Get inl_tax_lines_s.nextval';
4738: INL_LOGGING_PVT.Log_Statement (
4739: p_module_name => g_module_name,
4740: p_procedure_name => l_program_name,
4741: p_debug_info => l_debug_info

Line 4743: SELECT inl_tax_lines_s.nextval

4739: p_module_name => g_module_name,
4740: p_procedure_name => l_program_name,
4741: p_debug_info => l_debug_info
4742: ) ;
4743: SELECT inl_tax_lines_s.nextval
4744: INTO x_new_tax_line_id
4745: FROM dual;
4746: --
4747: -- include Tax Line record

Line 4755: INTO inl_tax_lines (

4751: p_module_name => g_module_name,
4752: p_procedure_name => l_program_name,
4753: p_debug_info => l_debug_info) ;
4754: INSERT
4755: INTO inl_tax_lines (
4756: tax_line_id, /* 01 */
4757: tax_line_num, /* 02 */
4758: tax_code, /* 03 */
4759: ship_header_id, /* 04 */

Line 4807: p_from_parent_table_name => 'INL_TAX_LINES',

4803: ) ;
4804: IF p_include_assoc = 'Y' THEN
4805: Create_Assoc(
4806: p_Assoc => p_TxLn_Assoc.inl_Assoc,
4807: p_from_parent_table_name => 'INL_TAX_LINES',
4808: p_new_line_id => x_new_tax_line_id,
4809: x_return_status => l_return_status
4810: )
4811: ;

Line 4944: AND assoc.from_parent_table_name = 'INL_TAX_LINES'

4940: p_tax_code IS NULL
4941: OR tl.tax_code = p_tax_code
4942: )
4943: -- SCM-051
4944: AND assoc.from_parent_table_name = 'INL_TAX_LINES'
4945: AND assoc.to_parent_table_name = p_comp_name
4946: AND assoc.to_parent_table_id = p_comp_id
4947: AND assoc.from_parent_table_id =
4948: (

Line 4950: FROM inl_tax_lines parntTxLn0

4946: AND assoc.to_parent_table_id = p_comp_id
4947: AND assoc.from_parent_table_id =
4948: (
4949: SELECT parntTxLn0.tax_line_id
4950: FROM inl_tax_lines parntTxLn0
4951: WHERE CONNECT_BY_ISLEAF = 1
4952: START WITH parntTxLn0.tax_line_id = tl.tax_line_id
4953: CONNECT BY PRIOR parntTxLn0.parent_tax_line_id = parntTxLn0.tax_line_id
4954: )

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

5012: l_TxLn_Assoc.adjustment_num := p_adjustment_num;
5013: l_TxLn_Assoc.match_id := p_match_id;
5014: l_TxLn_Assoc.matched_amt := 0;
5015: l_TxLn_Assoc.nrec_tax_amt := 0;
5016: l_TxLn_Assoc.source_parent_table_name := 'INL_TAX_LINES';
5017: FOR i IN NVL (C_est_TL.FIRST, 0) ..NVL (C_est_TL.LAST, 0)
5018: LOOP
5019: l_TxLn_Assoc.inl_Assoc.ship_header_id := C_est_TL (i) .ship_header_id;
5020: l_TxLn_Assoc.tax_code := C_est_TL (i) .tax_code;

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

5019: l_TxLn_Assoc.inl_Assoc.ship_header_id := C_est_TL (i) .ship_header_id;
5020: l_TxLn_Assoc.tax_code := C_est_TL (i) .tax_code;
5021: l_TxLn_Assoc.tax_line_num := C_est_TL (i) .tax_line_num;
5022: l_TxLn_Assoc.parent_tax_line_id := C_est_TL (i) .tax_line_id;
5023: l_TxLn_Assoc.source_parent_table_id := C_est_TL (i) .tax_line_id; --Unique index U2 in INL_TAX_LINES
5024: l_TxLn_Assoc.currency_code := C_est_TL (i) .currency_code;
5025: l_TxLn_Assoc.currency_conversion_type := C_est_TL (i) .currency_conversion_type;
5026: l_TxLn_Assoc.currency_conversion_date := C_est_TL (i) .currency_conversion_date;
5027: l_TxLn_Assoc.currency_conversion_rate := C_est_TL (i) .currency_conversion_rate;

Line 5128: FROM INL_TAX_LINES t

5124: tl.tax_amt_included_flag
5125: FROM inl_adj_tax_lines_v tl
5126: WHERE match_Amount_id = p_match_Amount_id
5127: AND NOT EXISTS (SELECT 1
5128: FROM INL_TAX_LINES t
5129: WHERE t.parent_tax_line_id = tl.tax_line_id)
5130: ;
5131: TYPE ori_TL_Type
5132: IS

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

5166: l_TxLn_Assoc.match_id := null;
5167: l_TxLn_Assoc.match_Amount_id := p_match_Amount_id;
5168: l_TxLn_Assoc.matched_amt := 0;
5169: l_TxLn_Assoc.nrec_tax_amt := 0;
5170: l_TxLn_Assoc.source_parent_table_name := 'INL_TAX_LINES';
5171: FOR i IN NVL (C_ori_TL.FIRST, 0) ..NVL (C_ori_TL.LAST, 0)
5172: LOOP
5173: l_TxLn_Assoc.inl_Assoc.ship_header_id := C_ori_TL (i) .ship_header_id;
5174: l_TxLn_Assoc.tax_code := C_ori_TL (i) .tax_code;

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

5173: l_TxLn_Assoc.inl_Assoc.ship_header_id := C_ori_TL (i) .ship_header_id;
5174: l_TxLn_Assoc.tax_code := C_ori_TL (i) .tax_code;
5175: l_TxLn_Assoc.tax_line_num := C_ori_TL (i) .tax_line_num;
5176: l_TxLn_Assoc.parent_tax_line_id := C_ori_TL (i) .tax_line_id;
5177: l_TxLn_Assoc.source_parent_table_id := C_ori_TL (i) .tax_line_id; --Unique index U2 in INL_TAX_LINES
5178: l_TxLn_Assoc.currency_code := C_ori_TL (i) .currency_code;
5179: l_TxLn_Assoc.currency_conversion_type := C_ori_TL (i) .currency_conversion_type;
5180: l_TxLn_Assoc.currency_conversion_date := C_ori_TL (i) .currency_conversion_date;
5181: l_TxLn_Assoc.currency_conversion_rate := C_ori_TL (i) .currency_conversion_rate;

Line 9141: FROM inl_tax_lines tx

9137: END IF;
9138: -- l_TxLn_Assoc.adjustment_num := p_adjustment_num;
9139: SELECT NVL (MAX (adjustment_num), 0) + 1
9140: INTO l_TxLn_Assoc.adjustment_num
9141: FROM inl_tax_lines tx
9142: WHERE tx.source_parent_table_name = l_from_parent_table_name
9143: AND tx.source_parent_table_id = l_from_parent_table_id
9144: AND tx.ship_header_id = l_ship_header_id;
9145: IF l_TxLn_Assoc.adjustment_num > 1 THEN

Line 9148: FROM inl_tax_lines tx

9144: AND tx.ship_header_id = l_ship_header_id;
9145: IF l_TxLn_Assoc.adjustment_num > 1 THEN
9146: SELECT tax_line_num, tax_line_id
9147: INTO l_TxLn_Assoc.tax_line_num, l_TxLn_Assoc.parent_tax_line_id
9148: FROM inl_tax_lines tx
9149: WHERE tx.source_parent_table_name = l_from_parent_table_name
9150: AND tx.source_parent_table_id = l_from_parent_table_id
9151: AND tx.ship_header_id = l_ship_header_id
9152: AND adjustment_num =

Line 9155: FROM inl_tax_lines tx1

9151: AND tx.ship_header_id = l_ship_header_id
9152: AND adjustment_num =
9153: (
9154: SELECT MAX (tx1.adjustment_num)
9155: FROM inl_tax_lines tx1
9156: WHERE tx1.source_parent_table_name = tx.source_parent_table_name
9157: AND tx1.source_parent_table_id = tx.source_parent_table_id
9158: AND tx1.ship_header_id = l_ship_header_id
9159: ) ;

Line 9619: p_from_parent_table_name => 'INL_TAX_LINES',

9615: p_var_name => l_debug_info,
9616: p_var_value => c_matches (i) .to_parent_table_id) ;
9617: Create_Assoc (
9618: p_Assoc => l_TxLn_Assoc.inl_Assoc,
9619: p_from_parent_table_name => 'INL_TAX_LINES',
9620: p_new_line_id => l_new_tax_line_id,
9621: x_return_status => l_return_status) ;
9622: END LOOP;
9623: END IF;

Line 13344: ELSIF (p_match_table_name = 'INL_TAX_LINES') THEN

13340: IF(p_match_table_name = 'INL_SHIP_LINES' OR p_match_table_name IS NULL) THEN
13341: l_match_type_code := 'ITEM';
13342: ELSIF (p_match_table_name = 'INL_CHARGE_LINES') THEN
13343: l_match_type_code := 'CHARGE';
13344: ELSIF (p_match_table_name = 'INL_TAX_LINES') THEN
13345: l_match_type_code := 'TAX';
13346: END IF;
13347: /* --SCM-051
13348: -- Get the functional currency code

Line 13484: FROM inl_tax_lines

13480: WHERE ship_header_id = p_ship_header_id;
13481:
13482: SELECT NVL(MAX(last_update_date), min_date)
13483: INTO l_tax_last_update_date
13484: FROM inl_tax_lines
13485: WHERE ship_header_id = p_ship_header_id;
13486:
13487: ship_last_update_date := greatest(l_header_last_update_date,
13488: l_group_last_update_date,