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 843: 'INL_TAX_LINES',

839: WHERE ABS(cl.adjustment_num) <= ABS(p_adjustment_num)
840: --- SCM-051
841: START WITH cl.charge_line_id = p_from_component_id
842: CONNECT BY PRIOR cl.parent_charge_line_id = cl.charge_line_id),
843: 'INL_TAX_LINES',
844: (SELECT MIN(tl.tax_line_id)
845: FROM inl_tax_lines tl
846: --- SCM-051
847: --- WHERE tl.adjustment_num <= p_adjustment_num

Line 845: FROM inl_tax_lines tl

841: START WITH cl.charge_line_id = p_from_component_id
842: CONNECT BY PRIOR cl.parent_charge_line_id = cl.charge_line_id),
843: 'INL_TAX_LINES',
844: (SELECT MIN(tl.tax_line_id)
845: FROM inl_tax_lines tl
846: --- SCM-051
847: --- WHERE tl.adjustment_num <= p_adjustment_num
848: WHERE ABS(tl.adjustment_num) <= ABS(p_adjustment_num)
849: --- SCM-051

Line 1198: ELSIF assoc_List(iAssoc).to_parent_table_name = 'INL_TAX_LINES' THEN

1194: p_procedure_name => l_program_name,
1195: p_var_name => l_debug_info,
1196: p_var_value => l_count);
1197:
1198: ELSIF assoc_List(iAssoc).to_parent_table_name = 'INL_TAX_LINES' THEN
1199: IF p_allocation_basis = 'VALUE' THEN
1200: SELECT nvl(SUM(nrec_tax_amt),0) + l_total_amt,
1201: COUNT(*) + l_count
1202: INTO l_total_amt,

Line 1204: FROM inl_tax_lines tl --BUG#8330505

1200: SELECT nvl(SUM(nrec_tax_amt),0) + l_total_amt,
1201: COUNT(*) + l_count
1202: INTO l_total_amt,
1203: l_count
1204: FROM inl_tax_lines tl --BUG#8330505
1205: WHERE tl.tax_line_id = assoc_List(iAssoc).to_parent_table_id;
1206: ELSE
1207: FND_MESSAGE.SET_NAME('INL','INL_ERR_TX_ALLOC');
1208: FND_MSG_PUB.Add;

Line 1548: ELSIF p_to_component_name = 'INL_TAX_LINES' THEN

1544: FND_MESSAGE.SET_NAME('INL','INL_ERR_CHK_CH_ALLOC');
1545: FND_MSG_PUB.Add;
1546: RAISE L_FND_EXC_ERROR;
1547: END IF;
1548: ELSIF p_to_component_name = 'INL_TAX_LINES' THEN
1549: IF l_allocation_basis = 'VALUE' THEN
1550: SELECT NVL(SUM(nrec_tax_amt),0)
1551: INTO l_to_component_amt
1552: FROM inl_tax_lines --BUG#8330505

Line 1552: FROM inl_tax_lines --BUG#8330505

1548: ELSIF p_to_component_name = 'INL_TAX_LINES' THEN
1549: IF l_allocation_basis = 'VALUE' THEN
1550: SELECT NVL(SUM(nrec_tax_amt),0)
1551: INTO l_to_component_amt
1552: FROM inl_tax_lines --BUG#8330505
1553: WHERE tax_line_id = p_to_component_id;
1554: ELSE
1555: FND_MESSAGE.SET_NAME('INL','INL_ERR_TX_ALLOC');
1556: FND_MSG_PUB.Add;

Line 1589: ELSIF p_to_component_name = 'INL_TAX_LINES' THEN

1585:
1586: IF p_allocation_basis <> 'VALUE' THEN
1587: IF p_to_component_name = 'INL_CHARGE_LINES' THEN
1588: l_debug_info := 'Assumed allocation basis VALUE for charges';
1589: ELSIF p_to_component_name = 'INL_TAX_LINES' THEN
1590: l_debug_info := 'Assumed allocation basis VALUE for taxes';
1591: END IF;
1592: END IF;
1593:

Line 2500: 'INL_TAX_LINES',

2496: --- SCM-051
2497: START WITH cl.charge_line_id = a.from_parent_table_id
2498: CONNECT BY PRIOR cl.charge_line_id = cl.parent_charge_line_id
2499: ),
2500: 'INL_TAX_LINES',
2501: (SELECT MAX(tl.tax_line_id)
2502: FROM inl_tax_lines tl
2503: --- SCM-051
2504: --- WHERE tl.adjustment_num <= p_adjustment_num

Line 2502: FROM inl_tax_lines tl

2498: CONNECT BY PRIOR cl.charge_line_id = cl.parent_charge_line_id
2499: ),
2500: 'INL_TAX_LINES',
2501: (SELECT MAX(tl.tax_line_id)
2502: FROM inl_tax_lines tl
2503: --- SCM-051
2504: --- WHERE tl.adjustment_num <= p_adjustment_num
2505: WHERE ABS(tl.adjustment_num) <= ABS(p_adjustment_num)
2506: --- SCM-051

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

2756: p_procedure_name => l_program_name,
2757: p_var_name => 'p_to_component_name',
2758: p_var_value => p_to_component_name);
2759:
2760: IF p_to_component_name IN ('INL_CHARGE_LINES','INL_TAX_LINES') THEN
2761: Insert_Allocation (
2762: p_ship_header_id => p_ship_header_id,
2763: p_le_currency_code => p_le_currency_code,
2764: p_association_id => p_association_id,

Line 3053: 'INL_TAX_LINES',

3049: --- SCM-051
3050: START WITH cl.charge_line_id = a.from_parent_table_id
3051: CONNECT BY PRIOR cl.charge_line_id = cl.parent_charge_line_id
3052: ),
3053: 'INL_TAX_LINES',
3054: (SELECT MAX(tl.tax_line_id)
3055: FROM inl_tax_lines tl
3056: --- SCM-051
3057: --- WHERE tl.adjustment_num <= pc_adjustment_num

Line 3055: FROM inl_tax_lines tl

3051: CONNECT BY PRIOR cl.charge_line_id = cl.parent_charge_line_id
3052: ),
3053: 'INL_TAX_LINES',
3054: (SELECT MAX(tl.tax_line_id)
3055: FROM inl_tax_lines tl
3056: --- SCM-051
3057: --- WHERE tl.adjustment_num <= pc_adjustment_num
3058: WHERE ABS(tl.adjustment_num) <= ABS(pc_adjustment_num)
3059: --- SCM-051

Line 3121: 'INL_TAX_LINES',

3117: --- SCM-051
3118: START WITH cl.charge_line_id = a.from_parent_table_id
3119: CONNECT BY PRIOR cl.charge_line_id = cl.parent_charge_line_id
3120: ),
3121: 'INL_TAX_LINES',
3122: (SELECT MAX(tl.tax_line_id)
3123: FROM inl_tax_lines tl
3124: --- SCM-051
3125: --- WHERE tl.adjustment_num <= pc_adjustment_num

Line 3123: FROM inl_tax_lines tl

3119: CONNECT BY PRIOR cl.charge_line_id = cl.parent_charge_line_id
3120: ),
3121: 'INL_TAX_LINES',
3122: (SELECT MAX(tl.tax_line_id)
3123: FROM inl_tax_lines tl
3124: --- SCM-051
3125: --- WHERE tl.adjustment_num <= pc_adjustment_num
3126: WHERE ABS(tl.adjustment_num) <= ABS(pc_adjustment_num)
3127: --- SCM-051

Line 3223: FROM inl_tax_lines t --BUG#8330505

3219: CURSOR tax (pc_adjustment_num IN NUMBER
3220: ) IS
3221: SELECT tax_amt,
3222: tax_line_id
3223: FROM inl_tax_lines t --BUG#8330505
3224: --- SCM-051
3225: --- WHERE t.adjustment_num <= pc_adjustment_num --Bug#9660084
3226: WHERE ABS(t.adjustment_num) <= ABS(pc_adjustment_num) --Bug#9660084
3227: --- SCM-051

Line 3230: WHERE x.from_parent_table_name = 'INL_TAX_LINES'

3226: WHERE ABS(t.adjustment_num) <= ABS(pc_adjustment_num) --Bug#9660084
3227: --- SCM-051
3228: AND EXISTS (SELECT 'x'
3229: FROM inl_associations x
3230: WHERE x.from_parent_table_name = 'INL_TAX_LINES'
3231: AND (SELECT MAX(tl.tax_line_id)
3232: FROM inl_tax_lines tl
3233: --- SCM-051
3234: --- WHERE tl.adjustment_num <= pc_adjustment_num

Line 3232: FROM inl_tax_lines tl

3228: AND EXISTS (SELECT 'x'
3229: FROM inl_associations x
3230: WHERE x.from_parent_table_name = 'INL_TAX_LINES'
3231: AND (SELECT MAX(tl.tax_line_id)
3232: FROM inl_tax_lines tl
3233: --- SCM-051
3234: --- WHERE tl.adjustment_num <= pc_adjustment_num
3235: WHERE ABS(tl.adjustment_num) <= ABS(pc_adjustment_num)
3236: --- SCM-051

Line 3469: FROM inl_tax_lines tl

3465: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
3466: AND a.from_parent_table_id = cl.charge_line_id)
3467: UNION ALL
3468: SELECT tl.adjustment_num adjustment_num
3469: FROM inl_tax_lines tl
3470: WHERE EXISTS (SELECT 'X'
3471: FROM inl_associations a
3472: WHERE a.ship_header_id = p_ship_header_id
3473: AND a.from_parent_table_name = 'INL_TAX_LINES'

Line 3473: AND a.from_parent_table_name = 'INL_TAX_LINES'

3469: FROM inl_tax_lines tl
3470: WHERE EXISTS (SELECT 'X'
3471: FROM inl_associations a
3472: WHERE a.ship_header_id = p_ship_header_id
3473: AND a.from_parent_table_name = 'INL_TAX_LINES'
3474: AND a.from_parent_table_id = tl.tax_line_id)) x
3475: --- SCM-051
3476: WHERE ABS(x.adjustment_num) >= ABS(l_i_adj)
3477: AND ABS(x.adjustment_num) <= ABS(l_last_adjustment_num);

Line 3498: FROM inl_tax_lines tl

3494: START WITH cl.charge_line_id = a.from_parent_table_id
3495: CONNECT BY PRIOR cl.charge_line_id = cl.parent_charge_line_id
3496: ),
3497: ( SELECT NVL(MIN(ABS(tl.adjustment_num)),l_last_adjustment_num)
3498: FROM inl_tax_lines tl
3499: WHERE a.from_parent_table_name = 'INL_TAX_LINES'
3500: AND ABS(tl.adjustment_num) >= ABS(l_i_adj)
3501: AND ABS(tl.adjustment_num) <= ABS(l_last_adjustment_num)
3502: START WITH tl.tax_line_id = a.from_parent_table_id

Line 3499: WHERE a.from_parent_table_name = 'INL_TAX_LINES'

3495: CONNECT BY PRIOR cl.charge_line_id = cl.parent_charge_line_id
3496: ),
3497: ( SELECT NVL(MIN(ABS(tl.adjustment_num)),l_last_adjustment_num)
3498: FROM inl_tax_lines tl
3499: WHERE a.from_parent_table_name = 'INL_TAX_LINES'
3500: AND ABS(tl.adjustment_num) >= ABS(l_i_adj)
3501: AND ABS(tl.adjustment_num) <= ABS(l_last_adjustment_num)
3502: START WITH tl.tax_line_id = a.from_parent_table_id
3503: CONNECT BY PRIOR tl.tax_line_id = tl.parent_tax_line_id

Line 3707: ELSIF assoc_List(iAssoc).from_parent_table_name = 'INL_TAX_LINES' THEN

3703: SELECT DECODE(cl.landed_cost_flag,'Y',NVL(cl.charge_amt,0) * NVL(cl.currency_conversion_rate,1),0) --BUG#9719618
3704: INTO l_from_amount
3705: FROM inl_charge_lines cl
3706: WHERE cl.charge_line_id = assoc_List(iAssoc).from_parent_table_id;
3707: ELSIF assoc_List(iAssoc).from_parent_table_name = 'INL_TAX_LINES' THEN
3708: SELECT NVL(SUM(nrec_tax_amt),0)
3709: INTO l_from_amount
3710: FROM inl_tax_lines tl --BUG#8330505
3711: WHERE tl.tax_line_id = assoc_List(iAssoc).from_parent_table_id;

Line 3710: FROM inl_tax_lines tl --BUG#8330505

3706: WHERE cl.charge_line_id = assoc_List(iAssoc).from_parent_table_id;
3707: ELSIF assoc_List(iAssoc).from_parent_table_name = 'INL_TAX_LINES' THEN
3708: SELECT NVL(SUM(nrec_tax_amt),0)
3709: INTO l_from_amount
3710: FROM inl_tax_lines tl --BUG#8330505
3711: WHERE tl.tax_line_id = assoc_List(iAssoc).from_parent_table_id;
3712: ELSIF assoc_List(iAssoc).from_parent_table_name = 'INL_SHIP_HEADERS' THEN
3713: ----BUG#971 9618 SELECT SUM(NVL(ol.primary_qty,0)*NVL( ol.primary_unit_price * NVL(ol.currency_conversion_rate,1),0))
3714: SELECT SUM(NVL(ol.primary_qty,0)*NVL(DECODE(ol.landed_cost_flag,'Y',ol.primary_unit_price * NVL(ol.currency_conversion_rate,1),0),0)) --BUG#9719618

Line 3913: inl_tax_lines t, --BUG#8330505

3909:
3910: SELECT SUM(NVL(al.allocation_amt,0))
3911: INTO l_inclusive_tax_amt
3912: FROM
3913: inl_tax_lines t, --BUG#8330505
3914: inl_associations assoc,
3915: inl_allocations al
3916: WHERE t.tax_amt_included_flag = 'Y'
3917: AND t.tax_line_id = (SELECT MAX(tl.tax_line_id)

Line 3918: FROM inl_tax_lines tl

3914: inl_associations assoc,
3915: inl_allocations al
3916: WHERE t.tax_amt_included_flag = 'Y'
3917: AND t.tax_line_id = (SELECT MAX(tl.tax_line_id)
3918: FROM inl_tax_lines tl
3919: --- SCM-051
3920: --- WHERE tl.adjustment_num <= l_current_adjustment_num
3921: WHERE ABS(tl.adjustment_num) <= ABS(l_current_adjustment_num)
3922: --- SCM-051

Line 3925: AND assoc.from_parent_table_name = 'INL_TAX_LINES'

3921: WHERE ABS(tl.adjustment_num) <= ABS(l_current_adjustment_num)
3922: --- SCM-051
3923: START WITH tl.tax_line_id = assoc.from_parent_table_id
3924: CONNECT BY PRIOR tl.tax_line_id = tl.parent_tax_line_id)
3925: AND assoc.from_parent_table_name = 'INL_TAX_LINES'
3926: AND assoc.association_id = al.association_id
3927: AND al.ship_line_id = dist_List(iDist).ship_line_id
3928: AND ABS(al.adjustment_num) = ABS(l_current_adjustment_num);
3929:

Line 4013: p_from_component_name => 'INL_TAX_LINES',

4009: p_le_currency_code => l_le_currency_code,
4010: p_association_id => NULL,
4011: p_ship_line_id => NULL,
4012: p_amount => NVL(tax_List(iTax).tax_amt,0),
4013: p_from_component_name => 'INL_TAX_LINES',
4014: p_from_component_id => tax_List(iTax).tax_line_id,
4015: p_to_component_name => 'INL_TAX_LINES',
4016: p_to_component_id => tax_List(iTax).tax_line_id,
4017: p_lc_flag => 'N',

Line 4015: p_to_component_name => 'INL_TAX_LINES',

4011: p_ship_line_id => NULL,
4012: p_amount => NVL(tax_List(iTax).tax_amt,0),
4013: p_from_component_name => 'INL_TAX_LINES',
4014: p_from_component_id => tax_List(iTax).tax_line_id,
4015: p_to_component_name => 'INL_TAX_LINES',
4016: p_to_component_id => tax_List(iTax).tax_line_id,
4017: p_lc_flag => 'N',
4018: p_adjustment_num => l_current_adjustment_num,
4019: x_return_status => l_return_status);