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_CHARGE_LINES

Line 819: 'INL_CHARGE_LINES',

815: AND (ABS(sl.adjustment_num) <= ABS(p_adjustment_num)
816: --- SCM-051
817: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
818: ),
819: 'INL_CHARGE_LINES',
820: (SELECT MAX(cl.charge_line_id)
821: FROM inl_charge_lines cl
822: --- SCM-051
823: --- WHERE cl.adjustment_num <= p_adjustment_num

Line 821: FROM inl_charge_lines cl

817: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
818: ),
819: 'INL_CHARGE_LINES',
820: (SELECT MAX(cl.charge_line_id)
821: FROM inl_charge_lines cl
822: --- SCM-051
823: --- WHERE cl.adjustment_num <= p_adjustment_num
824: WHERE ABS(cl.adjustment_num) <= ABS(p_adjustment_num)
825: --- SCM-051

Line 834: 'INL_CHARGE_LINES',

830: FROM inl_associations a
831: WHERE a.from_parent_table_name = p_from_component_name
832: AND a.from_parent_table_id
833: = DECODE(a.from_parent_table_name,
834: 'INL_CHARGE_LINES',
835: (SELECT MIN(cl.charge_line_id)
836: FROM inl_charge_lines cl
837: --- SCM-051
838: --- WHERE cl.adjustment_num <= p_adjustment_num

Line 836: FROM inl_charge_lines cl

832: AND a.from_parent_table_id
833: = DECODE(a.from_parent_table_name,
834: 'INL_CHARGE_LINES',
835: (SELECT MIN(cl.charge_line_id)
836: FROM inl_charge_lines cl
837: --- SCM-051
838: --- WHERE cl.adjustment_num <= p_adjustment_num
839: WHERE ABS(cl.adjustment_num) <= ABS(p_adjustment_num)
840: --- SCM-051

Line 1164: ELSIF assoc_List(iAssoc).to_parent_table_name = 'INL_CHARGE_LINES' THEN

1160: p_procedure_name => l_program_name,
1161: p_var_name => l_debug_info,
1162: p_var_value => l_count);
1163:
1164: ELSIF assoc_List(iAssoc).to_parent_table_name = 'INL_CHARGE_LINES' THEN
1165: IF p_allocation_basis = 'VALUE' THEN
1166: SELECT SUM(NVL(charge_amt,0) * NVL(currency_conversion_rate,1)) + l_total_amt,
1167: COUNT(*) + l_count
1168: INTO l_total_amt,

Line 1170: FROM inl_charge_lines cl

1166: SELECT SUM(NVL(charge_amt,0) * NVL(currency_conversion_rate,1)) + l_total_amt,
1167: COUNT(*) + l_count
1168: INTO l_total_amt,
1169: l_count
1170: FROM inl_charge_lines cl
1171: WHERE cl.charge_line_id = assoc_List(iAssoc).to_parent_table_id;
1172: -- If any errors happen abort API.
1173: IF l_return_status = L_FND_RET_STS_ERROR THEN
1174: RAISE L_FND_EXC_ERROR;

Line 1537: ELSIF p_to_component_name = 'INL_CHARGE_LINES' THEN

1533: p_allocation_uom_code)))
1534: INTO l_to_component_amt
1535: FROM inl_ship_lines_all ol
1536: WHERE ol.ship_line_id = p_to_component_id;
1537: ELSIF p_to_component_name = 'INL_CHARGE_LINES' THEN
1538: IF l_allocation_basis = 'VALUE' THEN
1539: SELECT SUM(NVL(charge_amt,0) * NVL(currency_conversion_rate,1))
1540: INTO l_to_component_amt
1541: FROM inl_charge_lines

Line 1541: FROM inl_charge_lines

1537: ELSIF p_to_component_name = 'INL_CHARGE_LINES' THEN
1538: IF l_allocation_basis = 'VALUE' THEN
1539: SELECT SUM(NVL(charge_amt,0) * NVL(currency_conversion_rate,1))
1540: INTO l_to_component_amt
1541: FROM inl_charge_lines
1542: WHERE charge_line_id = p_to_component_id;
1543: ELSE
1544: FND_MESSAGE.SET_NAME('INL','INL_ERR_CHK_CH_ALLOC');
1545: FND_MSG_PUB.Add;

Line 1587: IF p_to_component_name = 'INL_CHARGE_LINES' THEN

1583: o_factor := l_to_component_amt/p_total_amt;
1584: END IF;
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;

Line 2490: 'INL_CHARGE_LINES',

2486: AND (ABS(sl.adjustment_num) <= ABS(p_adjustment_num)
2487: --- SCM-051
2488: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
2489: ),
2490: 'INL_CHARGE_LINES',
2491: (SELECT MAX(cl.charge_line_id)
2492: FROM inl_charge_lines cl
2493: --- SCM-051
2494: --- WHERE cl.adjustment_num <= p_adjustment_num

Line 2492: FROM inl_charge_lines cl

2488: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
2489: ),
2490: 'INL_CHARGE_LINES',
2491: (SELECT MAX(cl.charge_line_id)
2492: FROM inl_charge_lines cl
2493: --- SCM-051
2494: --- WHERE cl.adjustment_num <= p_adjustment_num
2495: WHERE ABS(cl.adjustment_num) <= ABS(p_adjustment_num)
2496: --- SCM-051

Line 2527: 'INL_CHARGE_LINES',

2523: AND (ABS(sl.adjustment_num) <= ABS(p_adjustment_num)
2524: --- SCM-051
2525: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
2526: ),
2527: 'INL_CHARGE_LINES',
2528: (SELECT MAX(cl.charge_line_id)
2529: FROM inl_charge_lines cl
2530: --- SCM-051
2531: --- WHERE cl.adjustment_num <= p_adjustment_num

Line 2529: FROM inl_charge_lines cl

2525: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
2526: ),
2527: 'INL_CHARGE_LINES',
2528: (SELECT MAX(cl.charge_line_id)
2529: FROM inl_charge_lines cl
2530: --- SCM-051
2531: --- WHERE cl.adjustment_num <= p_adjustment_num
2532: WHERE ABS(cl.adjustment_num) <= ABS(p_adjustment_num)
2533: --- 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 3043: 'INL_CHARGE_LINES',

3039: AND (ABS(sl.adjustment_num) <= ABS(pc_adjustment_num)
3040: --- SCM-051
3041: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
3042: ),
3043: 'INL_CHARGE_LINES',
3044: (SELECT MAX(cl.charge_line_id)
3045: FROM inl_charge_lines cl
3046: --- SCM-051
3047: --- WHERE cl.adjustment_num <= pc_adjustment_num

Line 3045: FROM inl_charge_lines cl

3041: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
3042: ),
3043: 'INL_CHARGE_LINES',
3044: (SELECT MAX(cl.charge_line_id)
3045: FROM inl_charge_lines cl
3046: --- SCM-051
3047: --- WHERE cl.adjustment_num <= pc_adjustment_num
3048: WHERE ABS(cl.adjustment_num) <= ABS(pc_adjustment_num)
3049: --- SCM-051

Line 3081: 'INL_CHARGE_LINES',

3077: --- SCM-051
3078: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
3079:
3080: ),
3081: 'INL_CHARGE_LINES',
3082: (SELECT MAX(cl.charge_line_id)
3083: FROM inl_charge_lines cl
3084: --- SCM-051
3085: --- WHERE cl.adjustment_num <= pc_adjustment_num

Line 3083: FROM inl_charge_lines cl

3079:
3080: ),
3081: 'INL_CHARGE_LINES',
3082: (SELECT MAX(cl.charge_line_id)
3083: FROM inl_charge_lines cl
3084: --- SCM-051
3085: --- WHERE cl.adjustment_num <= pc_adjustment_num
3086: WHERE ABS(cl.adjustment_num) <= ABS(pc_adjustment_num)
3087: --- SCM-051

Line 3111: 'INL_CHARGE_LINES',

3107: AND (ABS(sl.adjustment_num) <= ABS(pc_adjustment_num)
3108: --- SCM-051
3109: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
3110: ),
3111: 'INL_CHARGE_LINES',
3112: (SELECT MAX(cl.charge_line_id)
3113: FROM inl_charge_lines cl
3114: --- SCM-051
3115: --- WHERE cl.adjustment_num <= pc_adjustment_num

Line 3113: FROM inl_charge_lines cl

3109: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
3110: ),
3111: 'INL_CHARGE_LINES',
3112: (SELECT MAX(cl.charge_line_id)
3113: FROM inl_charge_lines cl
3114: --- SCM-051
3115: --- WHERE cl.adjustment_num <= pc_adjustment_num
3116: WHERE ABS(cl.adjustment_num) <= ABS(pc_adjustment_num)
3117: --- SCM-051

Line 3177: FROM inl_charge_lines c,

3173: c.currency_conversion_type,
3174: c.currency_conversion_rate,
3175: c.currency_conversion_date,
3176: c.charge_line_id
3177: FROM inl_charge_lines c,
3178: --Bug#13988746 BEG
3179: (
3180: SELECT DISTINCT a.from_parent_table_id
3181: FROM inl_associations a

Line 3182: WHERE a.from_parent_table_name = 'INL_CHARGE_LINES'

3178: --Bug#13988746 BEG
3179: (
3180: SELECT DISTINCT a.from_parent_table_id
3181: FROM inl_associations a
3182: WHERE a.from_parent_table_name = 'INL_CHARGE_LINES'
3183: AND a.ship_header_id = p_ship_header_id
3184: ) X
3185: --Bug#13988746 END
3186: --- SCM-051

Line 3193: FROM inl_charge_lines cl

3189: --Bug#13988746 BEG
3190: AND c.charge_line_id
3191: = (
3192: SELECT MAX(cl.charge_line_id)
3193: FROM inl_charge_lines cl
3194: WHERE cl.adjustment_num <= ABS(pc_adjustment_num) -- SCM-051
3195: START WITH cl.charge_line_id = x.from_parent_table_id
3196: CONNECT BY PRIOR cl.charge_line_id = cl.parent_charge_line_id
3197: )

Line 3202: WHERE x.from_parent_table_name = 'INL_CHARGE_LINES'

3198: --- SCM-051
3199: /*
3200: AND EXISTS (SELECT 'x'
3201: FROM inl_associations x
3202: WHERE x.from_parent_table_name = 'INL_CHARGE_LINES'
3203: AND (SELECT MAX(cl.charge_line_id)
3204: FROM inl_charge_lines cl
3205: --- SCM-051
3206: --- WHERE cl.adjustment_num <= pc_adjustment_num

Line 3204: FROM inl_charge_lines cl

3200: AND EXISTS (SELECT 'x'
3201: FROM inl_associations x
3202: WHERE x.from_parent_table_name = 'INL_CHARGE_LINES'
3203: AND (SELECT MAX(cl.charge_line_id)
3204: FROM inl_charge_lines cl
3205: --- SCM-051
3206: --- WHERE cl.adjustment_num <= pc_adjustment_num
3207: WHERE ABS(cl.adjustment_num) <= ABS(pc_adjustment_num)
3208: --- SCM-051

Line 3461: FROM inl_charge_lines cl

3457: AND a.from_parent_table_name = 'INL_SHIP_LINES'
3458: AND a.from_parent_table_id = sl.ship_line_id)
3459: UNION ALL
3460: SELECT cl.adjustment_num adjustment_num
3461: FROM inl_charge_lines cl
3462: WHERE EXISTS (SELECT 'X'
3463: FROM inl_associations a
3464: WHERE a.ship_header_id = p_ship_header_id
3465: AND a.from_parent_table_name = 'INL_CHARGE_LINES'

Line 3465: AND a.from_parent_table_name = 'INL_CHARGE_LINES'

3461: FROM inl_charge_lines cl
3462: WHERE EXISTS (SELECT 'X'
3463: FROM inl_associations a
3464: WHERE a.ship_header_id = p_ship_header_id
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

Line 3490: FROM inl_charge_lines cl

3486: AND ABS(sl.adjustment_num) >= ABS(l_i_adj)
3487: AND ABS(sl.adjustment_num) <= ABS(l_last_adjustment_num)
3488: ),
3489: ( SELECT NVL(MIN(ABS(cl.adjustment_num)),l_last_adjustment_num)
3490: FROM inl_charge_lines cl
3491: WHERE a.from_parent_table_name = 'INL_CHARGE_LINES'
3492: AND ABS(cl.adjustment_num) >= ABS(l_i_adj)
3493: AND ABS(cl.adjustment_num) <= ABS(l_last_adjustment_num)
3494: START WITH cl.charge_line_id = a.from_parent_table_id

Line 3491: WHERE a.from_parent_table_name = 'INL_CHARGE_LINES'

3487: AND ABS(sl.adjustment_num) <= ABS(l_last_adjustment_num)
3488: ),
3489: ( SELECT NVL(MIN(ABS(cl.adjustment_num)),l_last_adjustment_num)
3490: FROM inl_charge_lines cl
3491: WHERE a.from_parent_table_name = 'INL_CHARGE_LINES'
3492: AND ABS(cl.adjustment_num) >= ABS(l_i_adj)
3493: AND ABS(cl.adjustment_num) <= ABS(l_last_adjustment_num)
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

Line 3696: IF assoc_List(iAssoc).from_parent_table_name = 'INL_CHARGE_LINES' THEN

3692: p_var_name => l_debug_info,
3693: p_var_value => assoc_List(iAssoc).association_id);
3694:
3695:
3696: IF assoc_List(iAssoc).from_parent_table_name = 'INL_CHARGE_LINES' THEN
3697: ---- Bug #9215498
3698: ---- SELECT Converted_Amt (charge_amt,
3699: ---- currency_code,
3700: ---- l_le_currency_code,

Line 3705: FROM inl_charge_lines cl

3701: ---- currency_conversion_type,
3702: ---- currency_conversion_date)
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

Line 3975: p_from_component_name => 'INL_CHARGE_LINES',

3971: p_le_currency_code => l_le_currency_code,
3972: p_association_id => NULL,
3973: p_ship_line_id => NULL,
3974: p_amount => charge_List(iCharge).charge_amt * NVL(charge_List(iCharge).currency_conversion_rate,1),
3975: p_from_component_name => 'INL_CHARGE_LINES',
3976: p_from_component_id => charge_List(iCharge).charge_line_id,
3977: p_to_component_name => 'INL_CHARGE_LINES',
3978: p_to_component_id => charge_List(iCharge).charge_line_id,
3979: p_lc_flag => 'N',

Line 3977: p_to_component_name => 'INL_CHARGE_LINES',

3973: p_ship_line_id => NULL,
3974: p_amount => charge_List(iCharge).charge_amt * NVL(charge_List(iCharge).currency_conversion_rate,1),
3975: p_from_component_name => 'INL_CHARGE_LINES',
3976: p_from_component_id => charge_List(iCharge).charge_line_id,
3977: p_to_component_name => 'INL_CHARGE_LINES',
3978: p_to_component_id => charge_List(iCharge).charge_line_id,
3979: p_lc_flag => 'N',
3980: p_adjustment_num => l_current_adjustment_num,
3981: x_return_status => l_return_status);