APPS.INL_SHIPMENT_PVT dependencies on INL_ADJ_TAX_LINES_V

Line 4904: FROM inl_adj_tax_lines_v tl

4900: tl.currency_conversion_type,
4901: tl.currency_conversion_date,
4902: tl.currency_conversion_rate,
4903: tl.tax_amt_included_flag
4904: FROM inl_adj_tax_lines_v tl
4905: WHERE p_ship_header_id IS NOT NULL --Bug#14044298
4906: AND tl.adjustment_num = p_prev_adjustment_num
4907: AND tl.ship_header_id = p_ship_header_id
4908: AND

Line 4931: inl_adj_tax_lines_v tl,

4927: tl.currency_conversion_date,
4928: tl.currency_conversion_rate,
4929: tl.tax_amt_included_flag
4930: FROM
4931: inl_adj_tax_lines_v tl,
4932: inl_associations assoc
4933: WHERE p_ship_header_id IS NULL
4934: AND (tl.tax_amt > 0
4935: OR tl.nrec_tax_amt > 0) --SCM-051

Line 5125: FROM inl_adj_tax_lines_v tl

5121: tl.currency_conversion_type,
5122: tl.currency_conversion_date,
5123: tl.currency_conversion_rate,
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)

Line 9528: inl_adj_tax_lines_v tl

9524: ) ;
9525: SELECT tl.tax_line_id, tl.tax_line_num
9526: INTO l_TxLn_Assoc.parent_tax_line_id, l_TxLn_Assoc.tax_line_num
9527: FROM inl_matches m,
9528: inl_adj_tax_lines_v tl
9529: WHERE m.from_parent_table_name = l_TxLn_Assoc.source_parent_table_name
9530: AND m.from_parent_table_id = l_TxLn_Assoc.source_parent_table_id
9531: AND m.match_id = (select max(m2.match_id)
9532: FROM inl_matches m2