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

Line 767: ELSIF rec_assoc.to_parent_table_name = 'INL_TAX_LINES' THEN

763: FND_MSG_PUB.Add;
764: RAISE FND_API.G_EXC_ERROR;
765:
766: END IF;
767: ELSIF rec_assoc.to_parent_table_name = 'INL_TAX_LINES' THEN
768: IF l_allocation_basis = 'VALUE' THEN
769: SELECT nvl(SUM(nrec_tax_amt),0) + l_total_amt
770: INTO l_total_amt
771: FROM INL_tax_lines

Line 771: FROM INL_tax_lines

767: ELSIF rec_assoc.to_parent_table_name = 'INL_TAX_LINES' THEN
768: IF l_allocation_basis = 'VALUE' THEN
769: SELECT nvl(SUM(nrec_tax_amt),0) + l_total_amt
770: INTO l_total_amt
771: FROM INL_tax_lines
772: WHERE tax_line_id = rec_assoc.to_parent_table_id;
773: ELSE
774: FND_MESSAGE.SET_NAME('INL','INL_ERR_TX_ALLOC');
775: FND_MSG_PUB.Add;

Line 871: ELSIF p_to_component_name = 'INL_TAX_LINES' THEN

867: FND_MSG_PUB.Add;
868: RAISE FND_API.G_EXC_ERROR;
869:
870: END IF;
871: ELSIF p_to_component_name = 'INL_TAX_LINES' THEN
872: IF l_allocation_basis = 'VALUE' THEN
873: SELECT NVL(SUM(nrec_tax_amt),0)
874: INTO l_to_component_amt
875: FROM INL_tax_lines

Line 875: FROM INL_tax_lines

871: ELSIF p_to_component_name = 'INL_TAX_LINES' THEN
872: IF l_allocation_basis = 'VALUE' THEN
873: SELECT NVL(SUM(nrec_tax_amt),0)
874: INTO l_to_component_amt
875: FROM INL_tax_lines
876: WHERE tax_line_id = p_to_component_id;
877: ELSE
878: FND_MESSAGE.SET_NAME('INL','INL_ERR_TX_ALLOC');
879: FND_MSG_PUB.Add;

Line 911: ELSIF p_to_component_name = 'INL_TAX_LINES' THEN

907:
908: IF p_allocation_basis <> 'VALUE' THEN
909: IF p_to_component_name = 'INL_CHARGE_LINES' THEN
910: l_debug_info := 'Assumed allocation basis VALUE for charges';
911: ELSIF p_to_component_name = 'INL_TAX_LINES' THEN
912: l_debug_info := 'Assumed allocation basis VALUE for taxes';
913: END IF;
914: END IF;
915:

Line 1722: IF p_to_component_name IN ('INL_CHARGE_LINES','INL_TAX_LINES') THEN

1718: p_procedure_name => l_procedure_name,
1719: p_var_name => l_debug_info,
1720: p_var_value => p_to_component_name);
1721:
1722: IF p_to_component_name IN ('INL_CHARGE_LINES','INL_TAX_LINES') THEN
1723: Insert_Allocation (p_ship_header_id,
1724: p_le_currency_code,
1725: p_association_id,
1726: NULL,

Line 1951: AND ((p_calc_scope_code = 3 AND from_parent_table_name = 'INL_TAX_LINES') OR

1947: allocation_uom_code,
1948: association_id
1949: FROM inl_adj_associations_v
1950: WHERE ship_header_id = p_ship_header_id
1951: AND ((p_calc_scope_code = 3 AND from_parent_table_name = 'INL_TAX_LINES') OR
1952: (p_calc_scope_code = 2 AND from_parent_table_name = 'INL_CHARGE_LINES') OR
1953: (p_calc_scope_code = 1 AND from_parent_table_name IN ('INL_SHIP_HEADERS','INL_SHIP_LINES')) OR
1954: p_calc_scope_code = 0)
1955: ORDER BY association_id;

Line 1991: FROM INL_tax_lines t

1987:
1988: CURSOR tax IS
1989: SELECT tax_amt,
1990: tax_line_id
1991: FROM INL_tax_lines t
1992: WHERE EXISTS (SELECT 'x'
1993: FROM INL_adj_associations_v x
1994: WHERE x.from_parent_table_name = 'INL_TAX_LINES'
1995: AND x.from_parent_table_id = t.tax_line_id

Line 1994: WHERE x.from_parent_table_name = 'INL_TAX_LINES'

1990: tax_line_id
1991: FROM INL_tax_lines t
1992: WHERE EXISTS (SELECT 'x'
1993: FROM INL_adj_associations_v x
1994: WHERE x.from_parent_table_name = 'INL_TAX_LINES'
1995: AND x.from_parent_table_id = t.tax_line_id
1996: AND x.ship_header_id = p_ship_header_id
1997: AND p_calc_scope_code in (0,3)
1998: AND ROWNUM < 2)

Line 2143: AND ((p_calc_scope_code = 3 AND from_parent_table_name = 'INL_TAX_LINES') OR

2139:
2140: DELETE FROM INL_allocations
2141: WHERE ship_header_id = p_ship_header_id
2142: AND adjustment_num = l_adjustment_num
2143: AND ((p_calc_scope_code = 3 AND from_parent_table_name = 'INL_TAX_LINES') OR
2144: (p_calc_scope_code = 2 AND from_parent_table_name = 'INL_CHARGE_LINES') OR
2145: (p_calc_scope_code = 1 AND from_parent_table_name IN ('INL_SHIP_HEADERS',
2146: 'INL_SHIP_LINES',
2147: 'INL_SHIP_DISTS')) OR

Line 2234: ELSIF rec_assoc.from_parent_table_name = 'INL_TAX_LINES' THEN

2230: currency_conversion_date)
2231: INTO l_from_amount
2232: FROM INL_adj_charge_lines_v
2233: WHERE charge_line_id = rec_assoc.from_parent_table_id;
2234: ELSIF rec_assoc.from_parent_table_name = 'INL_TAX_LINES' THEN
2235: SELECT NVL(SUM(nrec_tax_amt),0)
2236: INTO l_from_amount
2237: FROM INL_tax_lines
2238: WHERE tax_line_id = rec_assoc.from_parent_table_id;

Line 2237: FROM INL_tax_lines

2233: WHERE charge_line_id = rec_assoc.from_parent_table_id;
2234: ELSIF rec_assoc.from_parent_table_name = 'INL_TAX_LINES' THEN
2235: SELECT NVL(SUM(nrec_tax_amt),0)
2236: INTO l_from_amount
2237: FROM INL_tax_lines
2238: WHERE tax_line_id = rec_assoc.from_parent_table_id;
2239: ELSIF rec_assoc.from_parent_table_name = 'INL_SHIP_HEADERS' THEN
2240: SELECT SUM(NVL(primary_qty,0)*NVL(fc_primary_unit_price,0))
2241: INTO l_from_amount

Line 2378: FROM inl_tax_lines t,

2374: l_inclusive_tax_amt := 0;
2375:
2376: SELECT SUM(NVL(al.allocation_amt,0))
2377: INTO l_inclusive_tax_amt
2378: FROM inl_tax_lines t,
2379: inl_adj_associations_v assoc,
2380: inl_allocations al
2381: WHERE t.tax_amt_included_flag = 'Y'
2382: AND t.tax_line_id = assoc.from_parent_table_id

Line 2383: AND assoc.from_parent_table_name = 'INL_TAX_LINES'

2379: inl_adj_associations_v assoc,
2380: inl_allocations al
2381: WHERE t.tax_amt_included_flag = 'Y'
2382: AND t.tax_line_id = assoc.from_parent_table_id
2383: AND assoc.from_parent_table_name = 'INL_TAX_LINES'
2384: AND assoc.association_id = al.association_id
2385: AND al.ship_line_id = rec_dist.ship_line_id
2386: AND al.adjustment_num = l_adjustment_num;
2387:

Line 2451: 'INL_TAX_LINES',

2447: l_le_currency_code,
2448: NULL,
2449: NULL,
2450: NVL(rec_tax.tax_amt,0),
2451: 'INL_TAX_LINES',
2452: rec_tax.tax_line_id,
2453: 'INL_TAX_LINES',
2454: rec_tax.tax_line_id,
2455: 'N',

Line 2453: 'INL_TAX_LINES',

2449: NULL,
2450: NVL(rec_tax.tax_amt,0),
2451: 'INL_TAX_LINES',
2452: rec_tax.tax_line_id,
2453: 'INL_TAX_LINES',
2454: rec_tax.tax_line_id,
2455: 'N',
2456: l_adjustment_num,
2457: l_return_status);