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 6792: inl_matches m

6788: cl.poo_organization_id ,
6789: cl.poo_location_id
6790: FROM inl_adj_charge_lines_v cl,
6791: inl_associations a,
6792: inl_matches m
6793: WHERE
6794: ((cl.match_id IS NULL
6795: AND cl.match_amount_id IS NULL)
6796: OR

Line 8142: FROM inl_matches m,

8138: cl.charge_line_num
8139: INTO l_prev_adjustment_num ,
8140: l_ChLn_Assoc.parent_charge_line_id,
8141: l_ChLn_Assoc.charge_line_num
8142: FROM inl_matches m,
8143: inl_adj_charge_lines_v cl
8144: WHERE cl.match_id = m.match_id
8145: AND m.match_id <> p_match_id
8146: AND m.from_parent_table_name = l_from_parent_table_name

Line 8153: FROM inl_matches m2

8149: AND m.to_parent_table_id = l_to_parent_table_id
8150: AND m.match_id =
8151: (
8152: SELECT MAX (m2.match_id)
8153: FROM inl_matches m2
8154: WHERE m2.from_parent_table_name = m.from_parent_table_name
8155: AND m2.from_parent_table_id = m.from_parent_table_id
8156: AND m2.to_parent_table_name = m.to_parent_table_name
8157: AND m2.to_parent_table_id = m.to_parent_table_id

Line 8599: FROM inl_matches m

8595: -- a)Verify if exists any new match in this match amount
8596: -- a.1) Get the last match_amount_id
8597: SELECT max(match_amount_id)
8598: INTO l_prev_match_amount_id
8599: FROM inl_matches m
8600: WHERE m.charge_line_type_id = l_charge_line_type_id
8601: AND nvl(m.tax_code,'-9') = nvl(l_tax_code,'-9')
8602: AND m.match_amount_id <> p_match_amount_id
8603: AND adj_already_generated_flag = 'Y'

Line 8606: FROM inl_matches m2

8602: AND m.match_amount_id <> p_match_amount_id
8603: AND adj_already_generated_flag = 'Y'
8604: AND (m.from_parent_table_name, m.from_parent_table_id)
8605: IN (SELECT m2.from_parent_table_name, m2.from_parent_table_id
8606: FROM inl_matches m2
8607: WHERE m2.match_amount_id = p_match_amount_id)
8608: ;
8609:
8610: INL_LOGGING_PVT.Log_Variable (

Line 8621: FROM inl_matches m

8617: IF l_prev_match_amount_id IS NOT NULL THEN
8618: -- a.2) Count the new matches
8619: SELECT nvl(count(*),0)
8620: INTO l_count_new_matches
8621: FROM inl_matches m
8622: WHERE m.match_amount_id = p_match_amount_id
8623: AND not exists (SELECT 1
8624: FROM inl_matches m2
8625: WHERE m2.match_amount_id = l_prev_match_amount_id

Line 8624: FROM inl_matches m2

8620: INTO l_count_new_matches
8621: FROM inl_matches m
8622: WHERE m.match_amount_id = p_match_amount_id
8623: AND not exists (SELECT 1
8624: FROM inl_matches m2
8625: WHERE m2.match_amount_id = l_prev_match_amount_id
8626: AND m2.from_parent_table_name = m.from_parent_table_name
8627: AND m2.from_parent_table_id = m.from_parent_table_id
8628: AND m2.to_parent_table_name = m.to_parent_table_name

Line 8637: FROM inl_matches m

8633: IF l_count_new_matches = 0 THEN
8634: -- b.1) Count old matches
8635: SELECT nvl(count(*),0)
8636: INTO l_count_new_matches
8637: FROM inl_matches m
8638: WHERE m.match_amount_id = l_prev_match_amount_id
8639: AND not exists (SELECT 1
8640: FROM inl_matches m2
8641: WHERE m2.match_amount_id = p_match_amount_id

Line 8640: FROM inl_matches m2

8636: INTO l_count_new_matches
8637: FROM inl_matches m
8638: WHERE m.match_amount_id = l_prev_match_amount_id
8639: AND not exists (SELECT 1
8640: FROM inl_matches m2
8641: WHERE m2.match_amount_id = p_match_amount_id
8642: AND m2.from_parent_table_name = m.from_parent_table_name
8643: AND m2.from_parent_table_id = m.from_parent_table_id
8644: AND m2.to_parent_table_name = m.to_parent_table_name

Line 8667: FROM inl_matches m

8663: p_debug_info => 'Get previous match id.'
8664: ) ;
8665: SELECT m.parent_match_id
8666: INTO l_prev_match_id
8667: FROM inl_matches m
8668: WHERE m.match_amount_id = p_match_amount_id
8669: AND m.existing_match_info_flag = 'Y';
8670:
8671: INL_LOGGING_PVT.Log_Variable (

Line 8712: FROM inl_matches m,

8708: SELECT cl.charge_line_id ,
8709: cl.charge_line_num
8710: INTO l_ChLn_Assoc.parent_charge_line_id,
8711: l_ChLn_Assoc.charge_line_num
8712: FROM inl_matches m,
8713: inl_adj_charge_lines_v cl
8714: WHERE cl.match_amount_id = m.match_amount_id
8715: AND m.from_parent_table_name = l_from_parent_table_name
8716: AND m.from_parent_table_id = l_from_parent_table_id

Line 8723: FROM inl_matches m2

8719: AND m.adj_already_generated_flag = 'Y'
8720: AND m.match_id =
8721: (
8722: SELECT MAX (m2.match_id)
8723: FROM inl_matches m2
8724: WHERE m2.from_parent_table_name = m.from_parent_table_name
8725: AND m2.from_parent_table_id = m.from_parent_table_id
8726: AND m2.to_parent_table_name = m.to_parent_table_name
8727: AND m2.to_parent_table_id = m.to_parent_table_id

Line 9390: inl_matches m ,

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
9394: abv.allocation_basis_code = clt.allocation_basis

Line 9437: FROM inl_matches m

9433: -- a)Verify if exists any new match in this match amount
9434: -- a.1) Get the last match_amount_id
9435: SELECT max(match_amount_id)
9436: INTO l_prev_match_amount_id
9437: FROM inl_matches m
9438: WHERE m.charge_line_type_id = l_charge_line_type_id
9439: AND nvl(m.tax_code,'-9') = nvl(l_TxLn_Assoc.tax_code,'-9')
9440: AND m.match_amount_id <> p_match_amount_id
9441: AND adj_already_generated_flag = 'Y'

Line 9444: FROM inl_matches m2

9440: AND m.match_amount_id <> p_match_amount_id
9441: AND adj_already_generated_flag = 'Y'
9442: AND (m.from_parent_table_name, m.from_parent_table_id)
9443: IN (SELECT m2.from_parent_table_name, m2.from_parent_table_id
9444: FROM inl_matches m2
9445: WHERE m2.match_amount_id = p_match_amount_id)
9446: ;
9447:
9448: INL_LOGGING_PVT.Log_Variable (

Line 9458: FROM inl_matches m

9454:
9455: -- a.2) Count the new matches
9456: SELECT nvl(count(*),0)
9457: INTO l_count_new_matches
9458: FROM inl_matches m
9459: WHERE m.match_amount_id = p_match_amount_id
9460: AND not exists (SELECT 1
9461: FROM inl_matches m2
9462: WHERE m2.match_amount_id = l_prev_match_amount_id

Line 9461: FROM inl_matches m2

9457: INTO l_count_new_matches
9458: FROM inl_matches m
9459: WHERE m.match_amount_id = p_match_amount_id
9460: AND not exists (SELECT 1
9461: FROM inl_matches m2
9462: WHERE m2.match_amount_id = l_prev_match_amount_id
9463: AND m2.from_parent_table_name = m.from_parent_table_name
9464: AND m2.from_parent_table_id = m.from_parent_table_id
9465: AND m2.to_parent_table_name = m.to_parent_table_name

Line 9474: FROM inl_matches m

9470: IF l_count_new_matches = 0 THEN
9471: -- b.1) Count old matches
9472: SELECT nvl(count(*),0)
9473: INTO l_count_new_matches
9474: FROM inl_matches m
9475: WHERE m.match_amount_id = l_prev_match_amount_id
9476: AND not exists (SELECT 1
9477: FROM inl_matches m2
9478: WHERE m2.match_amount_id = p_match_amount_id

Line 9477: FROM inl_matches m2

9473: INTO l_count_new_matches
9474: FROM inl_matches m
9475: WHERE m.match_amount_id = l_prev_match_amount_id
9476: AND not exists (SELECT 1
9477: FROM inl_matches m2
9478: WHERE m2.match_amount_id = p_match_amount_id
9479: AND m2.from_parent_table_name = m.from_parent_table_name
9480: AND m2.from_parent_table_id = m.from_parent_table_id
9481: AND m2.to_parent_table_name = m.to_parent_table_name

Line 9527: FROM inl_matches m,

9523: p_debug_info => l_debug_info
9524: ) ;
9525: SELECT tl.tax_line_id, tl.tax_line_num
9526: INTO l_TxLn_Assoc.parent_tax_line_id, l_TxLn_Assoc.tax_line_num
9527: FROM inl_matches m,
9528: inl_adj_tax_lines_v tl
9529: WHERE m.from_parent_table_name = l_TxLn_Assoc.source_parent_table_name
9530: AND m.from_parent_table_id = l_TxLn_Assoc.source_parent_table_id
9531: AND m.match_id = (select max(m2.match_id)

Line 9532: FROM inl_matches m2

9528: inl_adj_tax_lines_v tl
9529: WHERE m.from_parent_table_name = l_TxLn_Assoc.source_parent_table_name
9530: AND m.from_parent_table_id = l_TxLn_Assoc.source_parent_table_id
9531: AND m.match_id = (select max(m2.match_id)
9532: FROM inl_matches m2
9533: WHERE m2.from_parent_table_name = l_TxLn_Assoc.source_parent_table_name
9534: AND m2.from_parent_table_id = l_TxLn_Assoc.source_parent_table_id
9535: AND m2.adj_already_generated_flag = 'Y' -- BUG#8411723 => MURALI
9536: )

Line 9995: from inl_matches m1

9991: AND NVL(m2.adj_already_generated_flag, 'N') = 'N')
9992: AND m1.match_type_code <> 'CORRECTION') LOOP
9993: */
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

Line 10235: UPDATE inl_matches m

10231: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
10232: RAISE L_FND_EXC_UNEXPECTED_ERROR;
10233: END IF;
10234: -- Flag the matches that already generated ajustments
10235: UPDATE inl_matches m
10236: SET m.adj_already_generated_flag = 'Y' ,
10237: m.adjustment_num = l_adjustment_num, --lcm/opm integration
10238: m.last_updated_by = L_FND_USER_ID,
10239: m.last_update_date = SYSDATE

Line 12976: FROM inl_matches a

12972: */
12973: --SCM-051
12974: SELECT SUM(NVL(a.nrec_tax_amt,0) * NVL(a.matched_curr_conversion_rate,1)) -- Bug #10102991 --Bug#1405859
12975: INTO l_nrec_tax_amt
12976: FROM inl_matches a
12977: WHERE a.ship_header_id = p_ship_header_id
12978: AND a.to_parent_table_name = 'INL_SHIP_LINES'
12979: AND a.to_parent_table_id = (SELECT NVL(MAX(b.parent_ship_line_id), p_ship_line_id)
12980: FROM inl_ship_lines_all b

Line 12988: FROM inl_matches c

12984: AND (p_charge_line_type_id IS NULL OR a.charge_line_type_id = p_charge_line_type_id)
12985: AND (p_tax_code IS NULL OR a.tax_code = p_tax_code)
12986: -- Bug 8879575
12987: AND a.adjustment_num = (SELECT NVL(MAX(c.adjustment_num), a.adjustment_num)
12988: FROM inl_matches c
12989: WHERE c.ship_header_id = a.ship_header_id
12990: AND c.from_parent_table_name = a.from_parent_table_name
12991: AND c.from_parent_table_id = a.from_parent_table_id
12992: AND c.to_parent_table_name = a.to_parent_table_name

Line 12998: FROM inl_matches d

12994: AND c.match_type_code = a.match_type_code
12995: AND c.tax_code = a.tax_code
12996: AND c.existing_match_info_flag = 'Y')
12997: AND NOT EXISTS (SELECT 1
12998: FROM inl_matches d
12999: WHERE d.ship_header_id = a.ship_header_id
13000: AND d.from_parent_table_name = a.from_parent_table_name
13001: AND d.from_parent_table_id = a.from_parent_table_id
13002: AND d.to_parent_table_name = a.to_parent_table_name

Line 13096: FROM inl_matches a

13092: */
13093: --SCM-051
13094: SELECT SUM(NVL(a.matched_amt,0) * NVL(a.matched_curr_conversion_rate,1)) -- Bug #10102991--Bug#14058596
13095: INTO l_matched_charge_amt
13096: FROM inl_matches a
13097: WHERE a.ship_header_id = p_ship_header_id
13098: AND a.to_parent_table_name = 'INL_SHIP_LINES'
13099: AND a.to_parent_table_id = (select NVL(MAX(b.parent_ship_line_id), p_ship_line_id)
13100: from inl_ship_lines_all b

Line 13106: from inl_matches c

13102: AND a.match_type_code = 'CHARGE'
13103: AND a.charge_line_type_id = p_charge_line_type_id
13104: -- Bug 8879575
13105: AND a.adjustment_num = (select NVL(MAX(c.adjustment_num), a.adjustment_num)
13106: from inl_matches c
13107: where c.ship_header_id = a.ship_header_id
13108: and c.from_parent_table_name = a.from_parent_table_name
13109: and c.from_parent_table_id = a.from_parent_table_id
13110: and c.to_parent_table_name = a.to_parent_table_name

Line 13116: from inl_matches d

13112: and c.match_type_code = a.match_type_code
13113: and c.charge_line_type_id = a.charge_line_type_id
13114: and c.existing_match_info_flag = 'Y')
13115: AND NOT EXISTS (select 1
13116: from inl_matches d
13117: where d.ship_header_id = a.ship_header_id
13118: and d.from_parent_table_name = a.from_parent_table_name
13119: and d.from_parent_table_id = a.from_parent_table_id
13120: and d.to_parent_table_name = a.to_parent_table_name

Line 13208: FROM inl_matches a

13204: */
13205: --SCM-051
13206: SELECT SUM(NVL(a.matched_amt,0) * NVL(a.matched_curr_conversion_rate,1)) -- Bug #10102991--Bug#14058596
13207: INTO l_matched_item_amt
13208: FROM inl_matches a
13209: WHERE a.ship_header_id = p_ship_header_id
13210: AND a.to_parent_table_name = 'INL_SHIP_LINES'
13211: AND a.to_parent_table_id = (SELECT NVL(MAX(b.parent_ship_line_id), p_ship_line_id)
13212: FROM inl_ship_lines_all b

Line 13219: FROM inl_matches c

13215: OR (p_summarized_matched_amt = 'N'
13216: AND a.match_type_code = 'ITEM'))
13217: -- Bug 8879575
13218: AND a.adjustment_num = (SELECT NVL(MAX(c.adjustment_num), a.adjustment_num)
13219: FROM inl_matches c
13220: WHERE c.ship_header_id = a.ship_header_id
13221: AND c.from_parent_table_name = a.from_parent_table_name
13222: AND c.from_parent_table_id = a.from_parent_table_id
13223: AND c.to_parent_table_name = a.to_parent_table_name

Line 13228: FROM inl_matches d

13224: AND c.to_parent_table_id = a.to_parent_table_id
13225: AND c.match_type_code = a.match_type_code
13226: AND c.existing_match_info_flag = 'Y')
13227: AND NOT EXISTS (SELECT 1
13228: FROM inl_matches d
13229: WHERE d.ship_header_id = a.ship_header_id
13230: AND d.from_parent_table_name = a.from_parent_table_name
13231: AND d.from_parent_table_id = a.from_parent_table_id
13232: AND d.to_parent_table_name = a.to_parent_table_name