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.

[Home] [Help]

APPS.INL_TAX_PVT dependencies on INL_SHIP_HEADERS

Line 51: FROM inl_associations assoc, inl_ship_headers sh

47: WHERE assoc.ship_header_id = P_ship_Header_Id
48: AND assoc.from_parent_table_name = 'INL_TAX_LINES'
49: AND assoc.from_parent_table_id = tl.tax_line_id)
50: AND NOT EXISTS (SELECT 1
51: FROM inl_associations assoc, inl_ship_headers sh
52: WHERE assoc.ship_header_id <> P_ship_Header_Id
53: AND assoc.ship_header_id = sh.ship_header_id
54: AND sh.ship_status_code = 'COMPLETED'
55: AND from_parent_table_name = 'INL_TAX_LINES'

Line 1804: ,inl_ship_headers oh

1800: ,oh.ship_TYPE_ID
1801: ,inl_tax_lines_s.NEXTVAL tax_line_id_s
1802: FROM zx_lines zl
1803: ,inl_ebtax_lines_v lv
1804: ,inl_ship_headers oh
1805: WHERE zl.application_id = 9004
1806: AND zl.trx_id = P_ship_Header_Id
1807: AND oh.ship_Header_Id = P_ship_Header_Id
1808: AND lv.ship_line_id = zl.trx_line_id