APPS.INL_SHIPMENT_PVT dependencies on INL_MATCH_AMOUNTS

Line 8542: FROM inl_match_amounts ma, -- Bug #9179775

8538: l_matched_curr_conversion_date,
8539: l_matched_curr_conversion_rate,
8540: l_allocation_basis ,
8541: l_allocation_uom_code
8542: FROM inl_match_amounts ma, -- Bug #9179775
8543: inl_corr_matches_v m ,
8544: inl_charge_line_types_vl clt ,
8545: inl_allocation_basis_vl abv
8546: WHERE abv.allocation_basis_code = clt.allocation_basis

Line 9389: inl_match_amounts ma , -- Bug #9179775

9385: l_TxLn_Assoc.inl_Assoc.allocation_basis,
9386: l_TxLn_Assoc.inl_Assoc.allocation_uom_code,
9387: l_existing_match_info_flag
9388: FROM
9389: inl_match_amounts ma , -- Bug #9179775
9390: inl_matches m ,
9391: inl_charge_line_types_vl clt,
9392: inl_allocation_basis_vl abv
9393: WHERE

Line 9764: inl_match_amounts ma,

9760: sh.organization_id --Bug#14044298
9761: --Bug#14044298 gsb.currency_code AS func_currency_code --BUG#8468830
9762: FROM
9763: inl_ship_headers sh,
9764: inl_match_amounts ma,
9765: inl_corr_matches_v m
9766: --Bug#14044298 org_organization_definitions ood, --BUG#8468830
9767: --Bug#14044298 gl_sets_of_books gsb --BUG#8468830
9768: WHERE

Line 9861: inl_match_amounts ma,

9857: DECODE(COUNT(DISTINCT(NVL(mFromMA.adj_group_date,l_initial_sysdate))),1,'Y','N')
9858: INTO
9859: l_match_amt_proc_same_adj_num
9860: FROM
9861: inl_match_amounts ma,
9862: inl_corr_matches_v m,
9863: inl_corr_matches_v mFromMA
9864: WHERE m.ship_header_id = p_ship_header_id
9865: AND m.match_amount_id = ma.match_amount_id

Line 9960: from inl_match_amounts ma, -- Bug #9179775

9956: IN (select m1.ship_header_id
9957: from inl_corr_matches_v m1
9958: where m1.match_amount_id
9959: IN (select DISTINCT(ma.match_amount_id)
9960: from inl_match_amounts ma, -- Bug #9179775
9961: inl_corr_matches_v m2
9962: WHERE m2.match_amount_id = ma.match_amount_id
9963: AND m2.ship_header_id = p_SHIP_HEADER_ID
9964: AND m2.match_type_code <> 'CORRECTION'

Line 9986: from inl_match_amounts ma, -- Bug #9188553

9982: FOR C_CUR_HEAD IN (select m1.ship_header_id
9983: from inl_corr_matches_v m1
9984: where m1.match_amount_id
9985: IN (select DISTINCT(ma.match_amount_id)
9986: from inl_match_amounts ma, -- Bug #9188553
9987: inl_corr_matches_v m2
9988: WHERE m2.match_amount_id = ma.match_amount_id
9989: AND m2.ship_header_id = p_SHIP_HEADER_ID
9990: AND m2.match_type_code <> 'CORRECTION'

Line 9998: from inl_match_amounts ma, -- Bug #9188553

9994: FOR C_CUR_HEAD IN (select m1.ship_header_id
9995: from inl_matches m1
9996: where m1.match_amount_id
9997: IN (select DISTINCT(ma.match_amount_id)
9998: from inl_match_amounts ma, -- Bug #9188553
9999: inl_corr_matches_v m2
10000: WHERE m2.match_amount_id = ma.match_amount_id
10001: AND m2.ship_header_id = p_SHIP_HEADER_ID
10002: AND m2.match_type_code <> 'CORRECTION'