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_TAX_PVT dependencies on INL_ASSOCIATIONS

Line 46: FROM inl_associations assoc

42: DELETE FROM inl_tax_lines tl
43: WHERE tl.ship_header_id = P_ship_Header_Id
44: OR (tl.ship_header_id is null
45: AND EXISTS (SELECT 1
46: FROM inl_associations assoc
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

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 67: DELETE FROM inl_associations assoc

63: p_procedure_name => l_proc_name,
64: p_debug_info => l_debug_info
65: );
66:
67: DELETE FROM inl_associations assoc
68: WHERE assoc.from_parent_table_name = 'INL_TAX_LINES'
69: AND NOT EXISTS (SELECT 1
70: FROM inl_tax_lines tl
71: WHERE assoc.from_parent_table_id = tl.tax_line_id)

Line 392: inl_associations assoc

388: tl.tax_line_id inl_tax_line_id,
389: assoc.to_parent_table_id,
390: tl.source_parent_table_id
391: FROM inl_adj_tax_lines_v tl,
392: inl_associations assoc
393: WHERE assoc.from_parent_table_name = 'INL_TAX_LINES'
394: AND assoc.from_parent_table_id = tl.tax_line_id
395: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'
396: AND tl.ship_header_id = p_ship_header_id

Line 838: --Inserting record in INL_ASSOCIATIONS

834: fnd_global.user_id , /* 19 */
835: SYSDATE , /* 20 */
836: fnd_global.login_id /* 21 */
837: );
838: --Inserting record in INL_ASSOCIATIONS
839: l_debug_info := 'Inserting record in INL_ASSOCIATIONS';
840: INL_LOGGING_PVT.Log_Statement (
841: p_module_name => g_module_name,
842: p_procedure_name => l_api_name,

Line 839: l_debug_info := 'Inserting record in INL_ASSOCIATIONS';

835: SYSDATE , /* 20 */
836: fnd_global.login_id /* 21 */
837: );
838: --Inserting record in INL_ASSOCIATIONS
839: l_debug_info := 'Inserting record in INL_ASSOCIATIONS';
840: INL_LOGGING_PVT.Log_Statement (
841: p_module_name => g_module_name,
842: p_procedure_name => l_api_name,
843: p_debug_info => l_debug_info

Line 847: INTO inl_associations (

843: p_debug_info => l_debug_info
844: );
845:
846: INSERT
847: INTO inl_associations (
848: association_id , /* 01 */
849: ship_header_id , /* 02 */
850: from_parent_table_name , /* 03 */
851: from_parent_table_id , /* 04 */

Line 863: inl_associations_s.NEXTVAL , /* 01 */

859: last_update_date , /* 12 */
860: last_update_login /* 13 */
861: )
862: VALUES (
863: inl_associations_s.NEXTVAL , /* 01 */
864: l_tax_ln_tbl(i).ship_header_id , /* 02 */
865: 'INL_TAX_LINES' , /* 03 */
866: l_tax_line_id , /* 04 */
867: l_tax_ln_tbl(i).to_parent_table_name , /* 05 */

Line 1749: -- INL_tax_lines and from INL_associations

1745: -- Type : Private
1746: --
1747: -- Function : It makes adjusts (Insert, Delete or Both) in tax_line table.
1748: -- For a given Ship_Header_Id DEL will remove all rows from this shipment of the
1749: -- INL_tax_lines and from INL_associations
1750: -- INS will insert in INL_tax_lines all lines from zx_lines
1751: -- If the zx_line has recover amount two lines will be generated in INL_tax_lines.
1752: --
1753: -- Pre-reqs : None

Line 1893: INSERT INTO inl_associations (

1889: p_debug_info => l_debug_info
1890: );
1891: -----------------------------------------------------------------
1892: -- It will create the association of new tax line with the correspondent component
1893: INSERT INTO inl_associations (
1894: association_id /* 01 */
1895: ,ship_header_id /* 02 */
1896: ,from_parent_table_name /* 03 */
1897: ,from_parent_table_id /* 04 */

Line 1908: inl_associations_s.NEXTVAL /* 01 */

1904: ,last_updated_by /* 11 */
1905: ,last_update_date /* 12 */
1906: ,last_update_login) /* 13 */
1907: VALUES(
1908: inl_associations_s.NEXTVAL /* 01 */
1909: ,curTax.trx_id /* 02 */
1910: ,'INL_TAX_LINES' /* 03 */
1911: ,curTax.tax_line_id_s /* 04 */
1912: ,curTax.source /* 05 */

Line 1933: FROM inl_associations assoc

1929: SET tax_already_calculated_flag = 'Y',
1930: last_updated_by = fnd_global.user_id,
1931: last_update_date = SYSDATE
1932: WHERE NVL(parent_charge_line_id,charge_line_id) IN (SELECT assoc.from_parent_table_id
1933: FROM inl_associations assoc
1934: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'
1935: AND assoc.ship_header_id = p_ship_header_id);
1936: -- logging message
1937: INL_LOGGING_PVT.Log_EndProc (

Line 2285: l_debug_info := 'Step 6: Adjust_Tax_Lines to Persist tax records in INL_ASSOCIATIONS and INL_TAX_LINES';

2281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2282: END IF;
2283:
2284: -----------------------------------------------------------------
2285: l_debug_info := 'Step 6: Adjust_Tax_Lines to Persist tax records in INL_ASSOCIATIONS and INL_TAX_LINES';
2286: -- logging message
2287: INL_LOGGING_PVT.Log_Statement (
2288: p_module_name => g_module_name,
2289: p_procedure_name => l_api_name,