DBA Data[Home] [Help]

APPS.INL_SHIPMENT_PVT dependencies on INL_ADJ_TAX_LINES_V

Line 2990: FROM inl_adj_tax_lines_v tl

2986: tl.currency_conversion_type,
2987: tl.currency_conversion_date,
2988: tl.currency_conversion_rate,
2989: tl.tax_amt_included_flag
2990: FROM inl_adj_tax_lines_v tl
2991: WHERE tl.adjustment_num = 0
2992: AND tl.ship_header_id = p_ship_header_id
2993: AND
2994: (

Line 3017: FROM inl_adj_tax_lines_v tl

3013: tl.currency_conversion_type,
3014: tl.currency_conversion_date,
3015: tl.currency_conversion_rate,
3016: tl.tax_amt_included_flag
3017: FROM inl_adj_tax_lines_v tl
3018: WHERE p_ship_header_id IS NULL
3019: AND tl.adjustment_num = 0
3020: AND
3021: (

Line 5630: inl_adj_tax_lines_v tl

5626:
5627: SELECT tl.tax_line_id, tl.tax_line_num
5628: INTO l_TxLn_Assoc.parent_tax_line_id, l_TxLn_Assoc.tax_line_num
5629: FROM inl_matches m,
5630: inl_adj_tax_lines_v tl
5631: WHERE m.from_parent_table_name = l_TxLn_Assoc.source_parent_table_name
5632: AND m.from_parent_table_id = l_TxLn_Assoc.source_parent_table_id
5633: AND m.match_id = (select max(m2.match_id)
5634: FROM inl_matches m2