DBA Data[Home] [Help]

APPS.INL_LANDEDCOST_PVT dependencies on INL_ADJ_CHARGE_LINES_V

Line 751: FROM INL_adj_charge_lines_v

747: p_le_currency_code,
748: currency_conversion_type,
749: currency_conversion_date)) + l_total_amt
750: INTO l_total_amt
751: FROM INL_adj_charge_lines_v
752: WHERE charge_line_id = rec_assoc.to_parent_table_id;
753:
754: -- If any errors happen abort API.
755: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 863: FROM inl_adj_charge_lines_v

859: P_le_currency_code,
860: currency_conversion_type,
861: currency_conversion_date))
862: INTO l_to_component_amt
863: FROM inl_adj_charge_lines_v
864: WHERE charge_line_id = p_to_component_id;
865: ELSE
866: FND_MESSAGE.SET_NAME('INL','INL_ERR_CHK_CH_ALLOC');
867: FND_MSG_PUB.Add;

Line 1977: FROM INL_adj_charge_lines_v c

1973: currency_conversion_type,
1974: currency_conversion_rate,
1975: currency_conversion_date,
1976: charge_line_id
1977: FROM INL_adj_charge_lines_v c
1978: WHERE EXISTS (SELECT 'x'
1979: FROM inl_adj_associations_v x
1980: WHERE x.from_parent_table_name = 'INL_CHARGE_LINES'
1981: AND x.from_parent_table_id = c.charge_line_id

Line 2232: FROM INL_adj_charge_lines_v

2228: l_le_currency_code,
2229: currency_conversion_type,
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