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_SHIPMENT_PVT dependencies on INL_MATCHES

Line 4142: FROM inl_matches m

4138: AND assoc.from_parent_table_id = cl.charge_line_id
4139: AND cl.charge_line_type_id = p_charge_line_type_id
4140: AND EXISTS
4141: (SELECT 1
4142: FROM inl_matches m
4143: WHERE assoc.ship_header_id = m.ship_header_id
4144: AND
4145: ((p_match_id IS NOT NULL
4146: AND m.match_id = p_match_id )

Line 4149: FROM inl_matches m2

4145: ((p_match_id IS NOT NULL
4146: AND m.match_id = p_match_id )
4147: OR (p_match_Amount_id IS NOT NULL
4148: AND EXISTS (SELECT 1
4149: FROM inl_matches m2
4150: WHERE m2.match_id = m.match_id
4151: AND m2.match_Amount_id = p_match_Amount_id
4152: AND rownum <2)))
4153: AND rownum <2

Line 4160: FROM inl_matches m

4156: SELECT
4157: m.to_parent_table_name,
4158: m.to_parent_table_id,
4159: m.ship_header_id
4160: FROM inl_matches m
4161: WHERE ((p_match_id IS NOT NULL
4162: AND m.match_id = p_match_id )
4163: OR
4164: (p_match_Amount_id IS NOT NULL

Line 4166: FROM inl_matches m2

4162: AND m.match_id = p_match_id )
4163: OR
4164: (p_match_Amount_id IS NOT NULL
4165: AND EXISTS (SELECT 1
4166: FROM inl_matches m2
4167: WHERE m2.match_id = m.match_id
4168: AND m2.match_Amount_id = p_match_Amount_id
4169: AND rownum <2)))
4170: ;

Line 4224: FROM inl_matches m

4220: AND (
4221: (
4222: pc_level = 'ALL'
4223: AND EXISTS (SELECT 1
4224: FROM inl_matches m
4225: WHERE m.ship_header_id = assoc.ship_header_id
4226: AND
4227: ((p_match_id IS NOT NULL
4228: AND m.match_id = p_match_id )

Line 4231: FROM inl_matches m2

4227: ((p_match_id IS NOT NULL
4228: AND m.match_id = p_match_id )
4229: OR (p_match_Amount_id IS NOT NULL
4230: AND EXISTS (SELECT 1
4231: FROM inl_matches m2
4232: WHERE m2.match_id = m.match_id
4233: AND m2.match_Amount_id = p_match_Amount_id
4234: AND rownum <2)))
4235: AND rownum <2

Line 4243: FROM inl_matches m

4239: OR (pc_level = 'LINE'
4240: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'
4241: AND EXISTS
4242: (SELECT 1
4243: FROM inl_matches m
4244: WHERE m.ship_header_id = assoc.ship_header_id
4245: AND m.to_parent_table_name = 'INL_SHIP_LINES'
4246: AND m.to_parent_table_id = assoc.to_parent_table_id
4247: AND

Line 4252: FROM inl_matches m2

4248: ((p_match_id IS NOT NULL
4249: AND m.match_id = p_match_id )
4250: OR (p_match_Amount_id IS NOT NULL
4251: AND EXISTS (SELECT 1
4252: FROM inl_matches m2
4253: WHERE m2.match_id = m.match_id
4254: AND m2.match_Amount_id = p_match_Amount_id
4255: AND rownum <2)))
4256: AND rownum <2

Line 4263: FROM inl_matches m

4259: OR (pc_level = 'GROUP'
4260: AND assoc.to_parent_table_name IN ('INL_SHIP_LINES','INL_SHIP_LINE_GROUPS')
4261: AND EXISTS
4262: (SELECT 1
4263: FROM inl_matches m
4264: WHERE m.ship_header_id = assoc.ship_header_id
4265: AND (
4266: ( m.to_parent_table_name = assoc.to_parent_table_name
4267: AND m.to_parent_table_id = assoc.to_parent_table_id

Line 4294: FROM inl_matches m2

4290: ((p_match_id IS NOT NULL
4291: AND m.match_id = p_match_id )
4292: OR (p_match_Amount_id IS NOT NULL
4293: AND EXISTS (SELECT 1
4294: FROM inl_matches m2
4295: WHERE m2.match_id = m.match_id
4296: AND m2.match_Amount_id = p_match_Amount_id
4297: AND rownum <2)))
4298: AND rownum <2

Line 4658: FROM inl_matches m,

4654: cl.charge_line_num
4655: INTO l_prev_adjustment_num ,
4656: l_ChLn_Assoc.parent_charge_line_id,
4657: l_ChLn_Assoc.charge_line_num
4658: FROM inl_matches m,
4659: inl_adj_charge_lines_v cl
4660: WHERE cl.match_id = m.match_id
4661: AND m.match_id <> p_match_id
4662: AND m.from_parent_table_name = l_from_parent_table_name

Line 4669: FROM inl_matches m2

4665: AND m.to_parent_table_id = l_to_parent_table_id
4666: AND m.match_id =
4667: (
4668: SELECT MAX (m2.match_id)
4669: FROM inl_matches m2
4670: WHERE m2.from_parent_table_name = m.from_parent_table_name
4671: AND m2.from_parent_table_id = m.from_parent_table_id
4672: AND m2.to_parent_table_name = m.to_parent_table_name
4673: AND m2.to_parent_table_id = m.to_parent_table_id

Line 5016: FROM inl_matches m,

5012: cl.charge_line_num
5013: INTO l_ChLn_Assoc.adjustment_num ,
5014: l_ChLn_Assoc.parent_charge_line_id,
5015: l_ChLn_Assoc.charge_line_num
5016: FROM inl_matches m,
5017: inl_adj_charge_lines_v cl
5018: WHERE cl.match_amount_id = m.match_amount_id
5019: AND m.from_parent_table_name = l_from_parent_table_name
5020: AND m.from_parent_table_id = l_from_parent_table_id

Line 5027: FROM inl_matches m2

5023: AND m.adj_already_generated_flag = 'Y'
5024: AND m.match_id =
5025: (
5026: SELECT MAX (m2.match_id)
5027: FROM inl_matches m2
5028: WHERE m2.from_parent_table_name = m.from_parent_table_name
5029: AND m2.from_parent_table_id = m.from_parent_table_id
5030: AND m2.to_parent_table_name = m.to_parent_table_name
5031: AND m2.to_parent_table_id = m.to_parent_table_id

Line 5591: inl_matches m ,

5587: l_TxLn_Assoc.inl_Assoc.allocation_uom_code,
5588: l_existing_match_info_flag
5589: FROM
5590: inl_corr_match_amounts_v ma ,
5591: inl_matches m ,
5592: inl_charge_line_types_vl clt,
5593: inl_allocation_basis_vl abv
5594: WHERE
5595: abv.allocation_basis_code = clt.allocation_basis

Line 5629: FROM inl_matches m,

5625: ) ;
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)

Line 5634: FROM inl_matches m2

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
5635: WHERE m2.from_parent_table_name = l_TxLn_Assoc.source_parent_table_name
5636: AND m2.from_parent_table_id = l_TxLn_Assoc.source_parent_table_id)
5637: AND tl.match_amount_id = m.match_amount_id;
5638: ELSE

Line 5949: UPDATE inl_matches m

5945: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5947: END IF;
5948: -- Flag the matches that already generated ajustments
5949: UPDATE inl_matches m
5950: SET m.adj_already_generated_flag = 'Y' ,
5951: last_updated_by = fnd_global.user_id,
5952: last_update_date = SYSDATE
5953: WHERE m.match_id = NVL (rec_match.correction_match_id, rec_match.match_id)