APPS.INL_SHIPMENT_PVT dependencies on INL_ADJ_CHARGE_LINES_V

Line 1861: FROM inl_adj_charge_lines_v cl,

1857: cl.charge_amt * cl.currency_conversion_rate) AS ch_line_amt_func_curr,
1858: cl.currency_code,
1859: cl.charge_line_id,
1860: cl.charge_line_num
1861: FROM inl_adj_charge_lines_v cl,
1862: inl_charge_line_types_vl clt ,
1863: inl_associations assoc
1864: WHERE clt.charge_line_type_id = cl.charge_line_type_id
1865: AND assoc.from_parent_table_name = 'INL_CHARGE_LINES'

Line 4211: FROM inl_adj_charge_lines_v cl

4207: poa_party_id ,
4208: poa_party_site_id ,
4209: poo_organization_id ,
4210: poo_location_id
4211: FROM inl_adj_charge_lines_v cl
4212: WHERE cl.adjustment_num = 0
4213: AND cl.charge_line_type_id = p_charge_line_type_id
4214: AND EXISTS
4215: (

Line 4659: inl_adj_charge_lines_v cl

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
4663: AND m.from_parent_table_id = l_from_parent_table_id

Line 4679: FROM inl_adj_charge_lines_v cl1

4675: )
4676: AND cl.charge_line_num =
4677: (
4678: SELECT MAX (cl1.charge_line_num)
4679: FROM inl_adj_charge_lines_v cl1
4680: WHERE cl1.match_id = m.match_id
4681: ) ;
4682: -- GROUP BY cl.charge_line_id, cl.adjustment_num;
4683: ELSE

Line 4700: FROM inl_adj_charge_lines_v cl

4696: cl.adjustment_num
4697: INTO l_corr_charge_line_id,
4698: l_corr_charge_line_num ,
4699: l_corr_adj_num
4700: FROM inl_adj_charge_lines_v cl
4701: WHERE cl.match_id = p_match_id
4702: AND cl.charge_line_num =
4703: (
4704: SELECT MAX (cl1.charge_line_num)

Line 4705: FROM inl_adj_charge_lines_v cl1

4701: WHERE cl.match_id = p_match_id
4702: AND cl.charge_line_num =
4703: (
4704: SELECT MAX (cl1.charge_line_num)
4705: FROM inl_adj_charge_lines_v cl1
4706: WHERE cl1.match_id = p_match_id
4707: ) ;
4708: EXCEPTION
4709: WHEN NO_DATA_FOUND THEN

Line 5017: inl_adj_charge_lines_v cl

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
5021: AND m.to_parent_table_name = l_to_parent_table_name

Line 5037: FROM inl_adj_charge_lines_v cl1

5033: )
5034: AND cl.charge_line_num =
5035: (
5036: SELECT MAX (cl1.charge_line_num)
5037: FROM inl_adj_charge_lines_v cl1
5038: WHERE cl1.match_amount_id = m.match_amount_id
5039: ) ;
5040: -- GROUP BY cl.charge_line_id, cl.adjustment_num;
5041: ELSE

Line 5058: FROM inl_adj_charge_lines_v cl

5054: cl.adjustment_num
5055: INTO l_corr_charge_line_id,
5056: l_corr_charge_line_num ,
5057: l_corr_adj_num
5058: FROM inl_adj_charge_lines_v cl
5059: WHERE cl.match_amount_id = p_match_amount_id
5060: AND cl.charge_line_num =
5061: (
5062: SELECT MAX (cl1.charge_line_num)

Line 5063: FROM inl_adj_charge_lines_v cl1

5059: WHERE cl.match_amount_id = p_match_amount_id
5060: AND cl.charge_line_num =
5061: (
5062: SELECT MAX (cl1.charge_line_num)
5063: FROM inl_adj_charge_lines_v cl1
5064: WHERE cl1.match_amount_id = p_match_amount_id
5065: ) ;
5066: EXCEPTION
5067: WHEN NO_DATA_FOUND THEN