APPS.INL_SHIPMENT_PVT dependencies on INL_CORR_MATCHES_V

Line 3193: FROM inl_corr_matches_v mat

3189: mat.matched_curr_code,
3190: pc_to_currency_code,
3191: pc_to_curr_conversion_type,
3192: pc_to_curr_conversion_date)) matched_amt
3193: FROM inl_corr_matches_v mat
3194: WHERE mat.to_parent_table_name = 'INL_SHIP_LINES'
3195: AND mat.match_type_code = 'ITEM'
3196: AND mat.to_parent_table_id = pc_ship_line_id
3197: AND NOT EXISTS

Line 3200: FROM inl_corr_matches_v m2

3196: AND mat.to_parent_table_id = pc_ship_line_id
3197: AND NOT EXISTS
3198: (
3199: SELECT 1
3200: FROM inl_corr_matches_v m2
3201: WHERE m2.from_parent_table_name = mat.from_parent_table_name
3202: AND m2.from_parent_table_id = mat.from_parent_table_id
3203: AND m2.match_id > mat.match_id
3204: )

Line 3344: FROM inl_corr_matches_v mat,

3340: l_ori_unit_price , /* 18 */
3341: l_from_parent_table_name , /* 19 */
3342: l_from_parent_table_id , /* 20 */
3343: l_curr_match_id /* 21 */
3344: FROM inl_corr_matches_v mat,
3345: inl_ship_lines sl ,
3346: inl_ship_headers sh
3347: WHERE mat.match_id = p_match_id
3348: AND mat.to_parent_table_name = 'INL_SHIP_LINES'

Line 3354: FROM inl_corr_matches_v mat2

3350: AND sl.ship_header_id = sh.ship_header_id
3351: AND sl.ship_line_id = mat.to_parent_table_id
3352: AND (mat.correction_match_id is null OR
3353: mat.correction_match_id = (select min(mat2.correction_match_id)
3354: FROM inl_corr_matches_v mat2
3355: WHERE mat2.match_id = p_match_id
3356: AND mat2.to_parent_table_name = 'INL_SHIP_LINES'
3357: AND mat2.adj_already_generated_flag = 'N'
3358: ));

Line 4621: FROM inl_corr_matches_v m

4617: l_matched_curr_code ,
4618: l_matched_curr_conversion_type,
4619: l_matched_curr_conversion_date,
4620: l_matched_curr_conversion_rate
4621: FROM inl_corr_matches_v m
4622: WHERE match_id = p_match_id;
4623: -- Getting the Ship information
4624: l_debug_info := 'Getting the ship line information';
4625: INL_LOGGING_PVT.Log_Statement (

Line 4888: FROM inl_corr_matches_v m

4884: m.from_parent_table_name,
4885: m.from_parent_table_id ,
4886: m.to_parent_table_name ,
4887: m.to_parent_table_id
4888: FROM inl_corr_matches_v m
4889: WHERE m.match_amount_id = p_match_amount_id
4890: ORDER BY m.match_id;
4891:
4892: TYPE c_matches_type

Line 4986: inl_corr_matches_v m ,

4982: l_matched_curr_conversion_rate,
4983: l_allocation_basis ,
4984: l_allocation_uom_code
4985: FROM inl_corr_match_amounts_v ma,
4986: inl_corr_matches_v m ,
4987: inl_charge_line_types_vl clt ,
4988: inl_allocation_basis_vl abv
4989: WHERE abv.allocation_basis_code = clt.allocation_basis
4990: AND clt.charge_line_type_id = m.charge_line_type_id

Line 5354: FROM inl_corr_matches_v m

5350: l_matched_curr_conversion_type,
5351: l_matched_curr_conversion_date,
5352: l_matched_curr_conversion_rate,
5353: l_ship_header_id
5354: FROM inl_corr_matches_v m
5355: WHERE match_id = p_match_id;
5356: -- Handling estimated tax Line and getting the parent_tax_line_id
5357: l_debug_info := 'Handling estimated tax Line and getting the parent_tax_line_id';
5358: INL_LOGGING_PVT.Log_Statement (

Line 5516: FROM inl_corr_matches_v m

5512: IS
5513: SELECT distinct
5514: m.to_parent_table_name,
5515: m.to_parent_table_id
5516: FROM inl_corr_matches_v m
5517: WHERE m.match_amount_id = p_match_amount_id;
5518:
5519: TYPE c_matches_type
5520: IS

Line 5788: inl_corr_matches_v m

5784: FROM
5785: inl_charge_lines cl,
5786: inl_ship_lines sl ,
5787: inl_ship_headers sh ,
5788: inl_corr_matches_v m
5789: WHERE
5790: cl.charge_line_id (+) = DECODE (m.to_parent_table_name, 'INL_CHARGE_LINES', m.to_parent_table_id, NULL)
5791: AND sl.ship_line_id (+) = DECODE (m.to_parent_table_name, 'INL_SHIP_LINES', m.to_parent_table_id, NULL)
5792: AND sh.ship_header_id = m.ship_header_id

Line 5811: inl_corr_matches_v m

5807: NULL AS to_parent_table_name,
5808: NULL AS to_parent_table_id
5809: FROM
5810: inl_ship_headers sh,
5811: inl_corr_matches_v m
5812: WHERE
5813: sh.ship_header_id = m.ship_header_id
5814: AND m.ship_header_id = p_ship_header_id
5815: AND m.match_amount_id IS NOT NULL