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_SHIP_LINES

Line 1334: p_table_name => 'INL_SHIP_LINES',

1330: Handle_ShipError (
1331: p_ship_header_id => p_ship_header_id,
1332: p_ship_line_id => p_ship_line_id,
1333: p_charge_line_id => NULL,
1334: p_table_name => 'INL_SHIP_LINES',
1335: p_column_name => 'PRIMARY_QTY',
1336: p_column_value => 0,
1337: p_error_message => SUBSTR (FND_MSG_PUB.Get(
1338: p_msg_index => FND_MSG_PUB.Count_Msg (),

Line 1494: p_table_name => 'INL_SHIP_LINES',

1490: Handle_ShipError (
1491: p_ship_header_id => p_ship_header_id,
1492: p_ship_line_id => p_ship_line_id,
1493: p_charge_line_id => NULL,
1494: p_table_name => 'INL_SHIP_LINES',
1495: p_column_name => 'PRIMARY_QTY',
1496: p_column_value => p_primary_qty,
1497: p_error_message => SUBSTR (FND_MSG_PUB.Get (
1498: p_msg_index => FND_MSG_PUB.Count_Msg (),

Line 1620: p_table_name => 'INL_SHIP_LINES',

1616: Handle_ShipError (
1617: p_ship_header_id => p_ship_header_id,
1618: p_ship_line_id => p_ship_line_id,
1619: p_charge_line_id => NULL,
1620: p_table_name => 'INL_SHIP_LINES',
1621: p_column_name => NULL,
1622: p_column_value => NULL,
1623: p_error_message => SUBSTR (FND_MSG_PUB.Get (
1624: p_msg_index => FND_MSG_PUB.Count_Msg (),

Line 1959: p_table_name => 'INL_SHIP_LINES',

1955: Handle_ShipError (
1956: p_ship_header_id => p_ship_header_id,
1957: p_ship_line_id => p_ship_line_id,
1958: p_charge_line_id => NULL,
1959: p_table_name => 'INL_SHIP_LINES',
1960: p_column_name => 'PRIMARY_UNIT_PRICE',
1961: p_column_value => 0,
1962: p_error_message => SUBSTR (FND_MSG_PUB.Get (
1963: p_msg_index => FND_MSG_PUB.Count_Msg (),

Line 1997: p_table_name => 'INL_SHIP_LINES',

1993: Handle_ShipError (
1994: p_ship_header_id => p_ship_header_id,
1995: p_ship_line_id => p_ship_line_id,
1996: p_charge_line_id => NULL,
1997: p_table_name => 'INL_SHIP_LINES',
1998: p_column_name => 'PRIMARY_UNIT_PRICE',
1999: p_column_value => 0,
2000: p_error_message => SUBSTR (FND_MSG_PUB.Get (
2001: p_msg_index => FND_MSG_PUB.Count_Msg (),

Line 2629: inl_ship_lines_all isl,

2625: ph.org_id PO_ORG_ID
2626: INTO l_lcm_org_id,
2627: l_po_org_id
2628: FROM inl_ship_headers_all ish,
2629: inl_ship_lines_all isl,
2630: po_headers_all ph,
2631: po_line_locations_all pll
2632: WHERE isl.ship_header_id = ish.ship_header_id
2633: AND ph.po_header_id = pll.po_header_id

Line 2889: inl_ship_lines_all sl,

2885: pvs.vendor_site_code,
2886: COUNT(*) how_many,
2887: MAX(sl.ship_line_num) max_ship_line_num
2888: FROM
2889: inl_ship_lines_all sl,
2890: po_headers_all ph,
2891: po_line_locations_all pll,
2892: po_vendors pv,
2893: po_vendor_sites_all pvs,

Line 2922: inl_ship_lines_all sl,

2918: CURSOR c_sl_num (pc_party_site_id NUMBER) is
2919: SELECT
2920: sl.ship_line_num
2921: FROM
2922: inl_ship_lines_all sl,
2923: po_headers_all ph,
2924: po_line_locations_all pll,
2925: po_vendors pv,
2926: po_vendor_sites_all pvs,

Line 3482: AND ia.from_parent_table_name = 'INL_SHIP_LINES'

3478: SELECT NVL(COUNT(1),0)
3479: INTO l_count_associations
3480: FROM inl_associations ia
3481: WHERE ship_header_id = p_ship_header_id
3482: AND ia.from_parent_table_name = 'INL_SHIP_LINES'
3483: AND ia.from_parent_table_id = p_ship_line_id;
3484:
3485: INL_LOGGING_PVT.Log_Variable (
3486: p_module_name => g_module_name,

Line 3501: p_table_name => 'INL_SHIP_LINES',

3497: Handle_ShipError (
3498: p_ship_header_id => p_ship_header_id,
3499: p_ship_line_id => p_ship_line_id,
3500: p_charge_line_id => NULL,
3501: p_table_name => 'INL_SHIP_LINES',
3502: p_column_name => 'SHIP_LINE_TYPE_ID',
3503: p_column_value => 0,
3504: p_error_message => SUBSTR (FND_MSG_PUB.Get (
3505: p_msg_index => FND_MSG_PUB.Count_Msg (),

Line 3605: 'INL_SHIP_LINES' to_parent_table_name

3601: ol.currency_code,
3602: ol.currency_conversion_type,
3603: ol.currency_conversion_date,
3604: ol.currency_conversion_rate,
3605: 'INL_SHIP_LINES' to_parent_table_name
3606: FROM inl_adj_ship_lines_v ol
3607: WHERE ol.ship_header_id = p_ship_header_id
3608: AND ol.ship_line_group_id = p_ln_group_id
3609: ORDER BY ol.ship_line_num;

Line 3672: FROM inl_ship_lines isl,

3668: IF l_closed_code <> 'OPEN' THEN
3669:
3670: SELECT isl.ship_line_num, islg.ship_line_group_num
3671: INTO l_ship_line_num,l_ship_ln_grp_num
3672: FROM inl_ship_lines isl,
3673: inl_ship_line_groups islg
3674: WHERE isl.ship_line_group_id=islg.ship_line_group_id
3675: AND isl.ship_line_id = l_ship_lines_rec.ship_line_id
3676: AND isl.ship_header_id = p_ship_header_id;

Line 3710: p_table_name => 'INL_SHIP_LINES',

3706: Handle_ShipError (
3707: p_ship_header_id => p_ship_header_id,
3708: p_ship_line_id => NULL,
3709: p_charge_line_id => NULL,
3710: p_table_name => 'INL_SHIP_LINES',
3711: p_column_name => 'SHIP_LINE_SOURCE_ID',
3712: p_column_value => l_ship_lines_rec.ship_line_source_id,
3713: p_error_message => SUBSTR (FND_MSG_PUB.Get (
3714: p_msg_index => FND_MSG_PUB.Count_Msg (),

Line 5292: WHERE mat.to_parent_table_name = 'INL_SHIP_LINES'

5288: pc_to_curr_conversion_type,
5289: pc_to_curr_conversion_date
5290: )) matched_amt
5291: FROM inl_corr_matches_v mat
5292: WHERE mat.to_parent_table_name = 'INL_SHIP_LINES'
5293: AND mat.match_type_code = 'ITEM'
5294: AND mat.to_parent_table_id = pc_ship_line_id
5295: AND NOT EXISTS
5296: (

Line 5378: inl_ship_lines sl

5374: INTO l_rt_transaction_id,
5375: l_rt_uom_code
5376: FROM mtl_units_of_measure um,
5377: rcv_transactions rt,
5378: inl_ship_lines sl
5379: WHERE um.unit_of_measure = rt.unit_of_measure
5380: AND rt.destination_type_code = 'RECEIVING'
5381: AND ((rt.transaction_type = 'RECEIVE'
5382: AND rt.parent_transaction_id = -1)

Line 5480: inl_ship_lines sl ,

5476: l_from_parent_table_name , /* 19 */
5477: l_from_parent_table_id , /* 20 */
5478: l_curr_match_id /* 21 */
5479: FROM inl_corr_matches_v mat,
5480: inl_ship_lines sl ,
5481: inl_ship_lines sl0 ,
5482: inl_ship_headers sh
5483: WHERE mat.match_id = p_match_id
5484: AND mat.to_parent_table_name = 'INL_SHIP_LINES'

Line 5481: inl_ship_lines sl0 ,

5477: l_from_parent_table_id , /* 20 */
5478: l_curr_match_id /* 21 */
5479: FROM inl_corr_matches_v mat,
5480: inl_ship_lines sl ,
5481: inl_ship_lines sl0 ,
5482: inl_ship_headers sh
5483: WHERE mat.match_id = p_match_id
5484: AND mat.to_parent_table_name = 'INL_SHIP_LINES'
5485: AND mat.adj_already_generated_flag = 'N'

Line 5484: AND mat.to_parent_table_name = 'INL_SHIP_LINES'

5480: inl_ship_lines sl ,
5481: inl_ship_lines sl0 ,
5482: inl_ship_headers sh
5483: WHERE mat.match_id = p_match_id
5484: AND mat.to_parent_table_name = 'INL_SHIP_LINES'
5485: AND mat.adj_already_generated_flag = 'N'
5486: AND sl.ship_header_id = sh.ship_header_id
5487: AND sl0.ship_line_id = mat.to_parent_table_id
5488: AND sl0.ship_header_id = sl.ship_header_id

Line 5494: FROM inl_ship_lines sl2

5490: AND sl0.ship_line_num = sl.ship_line_num
5491: AND sl.adjustment_num =
5492: (
5493: SELECT MIN(sl2.adjustment_num)
5494: FROM inl_ship_lines sl2
5495: WHERE sl0.ship_header_id = sl2.ship_header_id
5496: AND sl0.ship_line_group_id = sl2.ship_line_group_id
5497: AND sl0.ship_line_num = sl2.ship_line_num
5498: )

Line 5503: AND mat2.to_parent_table_name = 'INL_SHIP_LINES'

5499: AND (mat.correction_match_id is null OR
5500: mat.correction_match_id = (select min(mat2.correction_match_id)
5501: FROM inl_corr_matches_v mat2
5502: WHERE mat2.match_id = p_match_id
5503: AND mat2.to_parent_table_name = 'INL_SHIP_LINES'
5504: AND mat2.adj_already_generated_flag = 'N'
5505: ));
5506: INL_LOGGING_PVT.Log_Variable (
5507: p_module_name => g_module_name,

Line 5534: inl_ship_lines sl

5530: INTO l_rt_transaction_id,
5531: l_rt_uom_code
5532: FROM mtl_units_of_measure um,
5533: rcv_transactions rt,
5534: inl_ship_lines sl
5535: WHERE um.unit_of_measure = rt.unit_of_measure
5536: AND rt.destination_type_code = 'RECEIVING'
5537: AND ((rt.transaction_type = 'RECEIVE'
5538: AND rt.parent_transaction_id = -1)

Line 5618: FROM inl_ship_lines

5614: );
5615: l_nrq_zero_exception_flag := 'Y';
5616: SELECT txn_qty
5617: INTO l_net_rcv_txn_qty
5618: FROM inl_ship_lines
5619: WHERE ship_header_id = l_to_ship_header_id
5620: AND ship_line_num = l_ship_line_num
5621: AND ship_line_group_id = l_ship_line_group_id
5622: AND adjustment_num = 0

Line 6000: INTO inl_ship_lines_all

5996: END IF;
5997:
5998: --BUG#8468830
5999: INSERT
6000: INTO inl_ship_lines_all
6001: (
6002: ship_header_id, /* 01 */
6003: ship_line_group_id, /* 02 */
6004: ship_line_id, /* 03 */

Line 6079: inl_ship_lines_all_s.NEXTVAL, /* 03 */

6075: nrq_zero_exception_flag /* 79 */ --BUG#8334078
6076: )
6077: SELECT sl.ship_header_id, /* 01 */
6078: sl.ship_line_group_id, /* 02 */
6079: inl_ship_lines_all_s.NEXTVAL, /* 03 */
6080: sl.ship_line_num, /* 04 */
6081: sl.ship_line_type_id, /* 05 */
6082: sl.ship_line_src_type_code, /* 06 */
6083: sl.ship_line_source_id, /* 07 */

Line 6151: FROM inl_ship_lines sl

6147: sl.attribute13, /* 76 */
6148: sl.attribute14, /* 77 */
6149: sl.attribute15, /* 78 */
6150: l_nrq_zero_exception_flag /* 79 */ --BUG#8334078
6151: FROM inl_ship_lines sl
6152: WHERE ship_line_id = l_to_ship_line_id;
6153: IF l_replace_estim_qty_flag = 'N' THEN --THIS TRANSACTION IS ABOUT AN ACTUAL VALUE
6154: -- IF SHIP LINE HAS ESTIMATED TAXES THEY WILL WILL BE = 0
6155: Zero_EstimTaxLines (

Line 6158: p_comp_name => 'INL_SHIP_LINES',

6154: -- IF SHIP LINE HAS ESTIMATED TAXES THEY WILL WILL BE = 0
6155: Zero_EstimTaxLines (
6156: p_ship_header_id => NULL,
6157: p_match_id => p_match_id,
6158: p_comp_name => 'INL_SHIP_LINES',
6159: p_comp_id => l_to_ship_line_id,
6160: p_tax_code => NULL,
6161: p_adjustment_num => p_adjustment_num,
6162: x_return_status => l_return_status

Line 6829: (m.to_parent_table_name = 'INL_SHIP_LINES'

6825: AND a.to_parent_table_id = m.to_parent_table_id)
6826: )
6827: )
6828: OR
6829: (m.to_parent_table_name = 'INL_SHIP_LINES'
6830: AND m.ship_header_id = a.ship_header_id
6831: AND (a.to_parent_table_name = 'INL_SHIP_HEADERS'
6832: OR (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
6833: AND EXISTS (SELECT 1

Line 6834: FROM inl_ship_lines sl

6830: AND m.ship_header_id = a.ship_header_id
6831: AND (a.to_parent_table_name = 'INL_SHIP_HEADERS'
6832: OR (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
6833: AND EXISTS (SELECT 1
6834: FROM inl_ship_lines sl
6835: WHERE sl.ship_line_id = m.to_parent_table_id -- the match ship line
6836: AND sl.ship_line_group_id = a.to_parent_table_id --belong to group of association
6837: )
6838: )

Line 6839: OR (a.to_parent_table_name = 'INL_SHIP_LINES'

6835: WHERE sl.ship_line_id = m.to_parent_table_id -- the match ship line
6836: AND sl.ship_line_group_id = a.to_parent_table_id --belong to group of association
6837: )
6838: )
6839: OR (a.to_parent_table_name = 'INL_SHIP_LINES'
6840: AND m.to_parent_table_id = a.to_parent_table_id
6841: )
6842: )
6843: )

Line 7107: inl_ship_lines_all sl,

7103: a.to_parent_table_id
7104: FROM
7105: inl_charge_lines cl,
7106: inl_associations a,
7107: inl_ship_lines_all sl,
7108: inl_ship_line_groups slg,
7109: inl_ship_headers_all sh
7110: WHERE
7111: cl.adjustment_num = 0

Line 7116: AND ((a.to_parent_table_name = 'INL_SHIP_LINES'

7112: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
7113: AND a.from_parent_table_id = cl.charge_line_id
7114: AND cl.charge_line_type_id = p_charge_line_type_id
7115: AND a.ship_header_id = sl.ship_header_id
7116: AND ((a.to_parent_table_name = 'INL_SHIP_LINES'
7117: AND a.to_parent_table_id = sl.ship_line_id)
7118: OR
7119: (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
7120: AND a.to_parent_table_id = sl.ship_line_group_id)

Line 7298: IF affected_by_alc_ship_lst(i).to_parent_table_name <> 'INL_SHIP_LINES' THEN

7294:
7295: -- affected_by_alc_ship_lst.inl_Assoc.ship_header_id := affected_by_alc_ship_lst(i).ship_header_id;
7296:
7297: -- CURRENTLY ALL ASSOCIATIONS OF ACTUALS ARE MADE AT LINE LEVEL
7298: IF affected_by_alc_ship_lst(i).to_parent_table_name <> 'INL_SHIP_LINES' THEN
7299:
7300: l_debug_info := 'Problem in INL SHIPMENT PVT regarding canceled invoice applied at a level different from line';
7301: INL_LOGGING_PVT.Log_Statement (
7302: p_module_name => g_module_name,

Line 7318: inl_ship_lines_all sl,

7314: l_sum_chLnAmt
7315: FROM
7316: inl_adj_charge_lines_v cl,
7317: inl_adj_associations_v a, --BUG#9804065
7318: inl_ship_lines_all sl,
7319: inl_ship_line_groups slg,
7320: inl_ship_headers_all sh
7321: WHERE
7322: a.ship_header_id = sl.ship_header_id

Line 7324: AND ((a.to_parent_table_name = 'INL_SHIP_LINES'

7320: inl_ship_headers_all sh
7321: WHERE
7322: a.ship_header_id = sl.ship_header_id
7323: AND cl.charge_line_type_id = p_charge_line_type_id --same cost factor
7324: AND ((a.to_parent_table_name = 'INL_SHIP_LINES'
7325: AND a.to_parent_table_id = sl.ship_line_id)
7326: OR
7327: (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
7328: AND a.to_parent_table_id = sl.ship_line_group_id)

Line 7368: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'

7364: inl_charge_lines cl,
7365: inl_associations assoc
7366: WHERE
7367: assoc.to_parent_table_id = affected_by_alc_ship_lst(i).to_parent_table_id
7368: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'
7369: AND assoc.from_parent_table_name = 'INL_CHARGE_LINES'
7370: AND assoc.from_parent_table_id = cl.charge_line_id
7371: AND cl.charge_line_type_id = p_charge_line_type_id --same cost factor
7372: AND cl.charge_amt = 0

Line 7514: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'

7510: inl_charge_lines cl,
7511: inl_associations assoc
7512: WHERE
7513: assoc.ship_header_id = affected_by_elc_lst(k).ship_header_id
7514: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'
7515: AND assoc.from_parent_table_name = 'INL_CHARGE_LINES'
7516: AND assoc.from_parent_table_id = cl.charge_line_id
7517: AND cl.charge_amt = 0
7518: AND cl.charge_line_type_id = p_charge_line_type_id --same cost factor

Line 7545: FROM inl_ship_lines_all sl

7541: a.ship_header_id = affected_by_elc_lst(k).ship_header_id
7542: AND cl.charge_line_type_id = p_charge_line_type_id --same cost factor
7543: AND NVL(cl.match_id,cl.match_amount_id) IS NOT NULL --only ALC
7544: AND EXISTS (SELECT 1
7545: FROM inl_ship_lines_all sl
7546: WHERE sl.ship_line_id = a.to_parent_table_id
7547: AND sl.ship_header_id = affected_by_elc_lst(k).ship_header_id
7548: AND sl.ship_line_group_id = affected_by_elc_lst(k).to_parent_table_id
7549: AND ROWNUM < 2)

Line 7571: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'

7567: inl_charge_lines cl,
7568: inl_associations assoc
7569: WHERE
7570: assoc.ship_header_id = affected_by_elc_lst(k).ship_header_id
7571: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'
7572: AND assoc.from_parent_table_name = 'INL_CHARGE_LINES'
7573: AND assoc.from_parent_table_id = cl.charge_line_id
7574: AND cl.charge_amt = 0
7575: AND cl.charge_line_type_id = p_charge_line_type_id --same cost factor

Line 7578: FROM inl_ship_lines_all sl

7574: AND cl.charge_amt = 0
7575: AND cl.charge_line_type_id = p_charge_line_type_id --same cost factor
7576: AND NVL(cl.match_id,cl.match_amount_id) IS NOT NULL --only ALC
7577: AND EXISTS (SELECT 1
7578: FROM inl_ship_lines_all sl
7579: WHERE sl.ship_line_id = assoc.to_parent_table_id
7580: AND sl.ship_header_id = affected_by_elc_lst(k).ship_header_id
7581: AND sl.ship_line_group_id = affected_by_elc_lst(k).to_parent_table_id
7582: AND ROWNUM < 2)

Line 7595: ELSIF affected_by_elc_lst(k).to_parent_table_name = 'INL_SHIP_LINES' then

7591: START WITH cl1.charge_line_id = cl.charge_line_id
7592: CONNECT BY PRIOR cl1.parent_charge_line_id = cl1.charge_line_id));
7593: --Bug#11064618
7594:
7595: ELSIF affected_by_elc_lst(k).to_parent_table_name = 'INL_SHIP_LINES' then
7596: SELECT
7597: SUM(cl.charge_amt)
7598: INTO
7599: l_sum_chLnAmt

Line 7628: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'

7624: inl_charge_lines cl,
7625: inl_associations assoc
7626: WHERE
7627: assoc.ship_header_id = affected_by_elc_lst(k).ship_header_id
7628: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'
7629: AND assoc.to_parent_table_id = affected_by_elc_lst(k).to_parent_table_id
7630: AND assoc.from_parent_table_name = 'INL_CHARGE_LINES'
7631: AND assoc.from_parent_table_id = cl.charge_line_id
7632: AND cl.charge_amt = 0

Line 8088: FROM inl_ship_lines sl

8084: p_debug_info => l_debug_info
8085: ) ;
8086: SELECT sl.ship_header_id
8087: INTO l_ship_header_id
8088: FROM inl_ship_lines sl
8089: WHERE sl.ship_line_id = l_ship_line_id;
8090:
8091: INL_LOGGING_PVT.Log_Variable (
8092: p_module_name => g_module_name,

Line 8228: l_ChLn_Assoc.inl_Assoc.to_parent_table_name := 'INL_SHIP_LINES';

8224: p_debug_info => l_debug_info
8225: ) ;
8226: l_ChLn_Assoc.inl_Assoc.ship_header_id := l_ship_header_id;
8227: l_ChLn_Assoc.inl_Assoc.allocation_uom_code := NULL;
8228: l_ChLn_Assoc.inl_Assoc.to_parent_table_name := 'INL_SHIP_LINES';
8229: l_ChLn_Assoc.inl_Assoc.to_parent_table_id := l_to_parent_table_id;
8230: l_ChLn_Assoc.charge_line_type_id := l_charge_line_type_id;
8231: l_ChLn_Assoc.landed_cost_flag := 'Y';
8232: l_ChLn_Assoc.adjustment_num := l_prev_adjustment_num;

Line 9135: IF l_table_name = 'INL_SHIP_LINES' THEN

9131: p_procedure_name => l_api_name,
9132: p_debug_info => l_debug_info
9133: ) ;
9134: l_TxLn_Assoc.inl_Assoc.to_parent_table_name := l_table_name;
9135: IF l_table_name = 'INL_SHIP_LINES' THEN
9136: l_TxLn_Assoc.inl_Assoc.to_parent_table_id := l_table_id;
9137: END IF;
9138: -- l_TxLn_Assoc.adjustment_num := p_adjustment_num;
9139: SELECT NVL (MAX (adjustment_num), 0) + 1

Line 9732: --Bug#14044298 inl_ship_lines sl ,

9728: sh.organization_id --Bug#14044298
9729: --Bug#14044298 gsb.currency_code func_currency_code --BUG#8468830
9730: FROM
9731: --Bug#14044298 inl_charge_lines cl ,
9732: --Bug#14044298 inl_ship_lines sl ,
9733: inl_ship_headers sh ,
9734: inl_corr_matches_v m
9735: --Bug#14044298 org_organization_definitions ood, --BUG#8468830
9736: --Bug#14044298 gl_sets_of_books gsb --BUG#8468830

Line 9740: --Bug#14044298 AND sl.ship_line_id (+) = DECODE (m.to_parent_table_name, 'INL_SHIP_LINES', m.to_parent_table_id, NULL)

9736: --Bug#14044298 gl_sets_of_books gsb --BUG#8468830
9737: WHERE
9738: sh.ship_header_id = p_ship_header_id
9739: --Bug#14044298 cl.charge_line_id (+) = DECODE (m.to_parent_table_name, 'INL_CHARGE_LINES', m.to_parent_table_id, NULL)
9740: --Bug#14044298 AND sl.ship_line_id (+) = DECODE (m.to_parent_table_name, 'INL_SHIP_LINES', m.to_parent_table_id, NULL)
9741: AND sh.ship_header_id = m.ship_header_id
9742: AND m.ship_header_id = p_ship_header_id
9743: AND m.match_amount_id IS NULL
9744: AND m.match_type_code <> 'CORRECTION'

Line 11229: INSERT INTO inl_ship_lines(

11225: l_secondary_unit_price := (l_elc_adj_shiplines(i).txn_qty * l_elc_adj_shiplines(i).new_txn_unit_price) / l_elc_adj_shiplines(i).secondary_qty;
11226: END IF;
11227: END IF;
11228:
11229: INSERT INTO inl_ship_lines(
11230: ship_header_id, -- 01
11231: ship_line_group_id, -- 02
11232: ship_line_id, -- 03
11233: ship_line_num, -- 04

Line 11314: inl_ship_lines_all_s.nextval, -- 03

11310: new_currency_conversion_rate -- 81
11311: )
11312: (SELECT p_ship_header_id, -- 01
11313: sl.ship_line_group_id, -- 02
11314: inl_ship_lines_all_s.nextval, -- 03
11315: sl.ship_line_num, -- 04
11316: sl.ship_line_type_id, -- 05
11317: sl.ship_line_src_type_code, -- 06
11318: sl.ship_line_source_id, -- 07

Line 12054: inl_ship_lines_all sl

12050:
12051: SELECT COUNT(1)
12052: INTO l_rcv_running
12053: FROM rcv_transactions_interface rti,
12054: inl_ship_lines_all sl
12055: WHERE rti.transaction_type = 'RECEIVE'
12056: AND rti.processing_status_code = 'RUNNING'
12057: AND rti.lcm_shipment_line_id = sl.ship_line_id
12058: AND sl.ship_header_id = p_ship_header_id;

Line 12978: AND a.to_parent_table_name = 'INL_SHIP_LINES'

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
12981: WHERE b.ship_line_id = p_ship_line_id)
12982:

Line 12980: FROM inl_ship_lines_all b

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
12981: WHERE b.ship_line_id = p_ship_line_id)
12982:
12983: AND a.match_type_code = 'TAX'
12984: AND (p_charge_line_type_id IS NULL OR a.charge_line_type_id = p_charge_line_type_id)

Line 13098: AND a.to_parent_table_name = 'INL_SHIP_LINES'

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
13101: where b.ship_line_id = p_ship_line_id)
13102: AND a.match_type_code = 'CHARGE'

Line 13100: from inl_ship_lines_all b

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
13101: where b.ship_line_id = p_ship_line_id)
13102: AND a.match_type_code = 'CHARGE'
13103: AND a.charge_line_type_id = p_charge_line_type_id
13104: -- Bug 8879575

Line 13210: AND a.to_parent_table_name = 'INL_SHIP_LINES'

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
13213: WHERE b.ship_line_id = p_ship_line_id)
13214: AND ((p_summarized_matched_amt = 'Y' AND a.match_type_code <> 'TAX')

Line 13212: FROM inl_ship_lines_all b

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
13213: WHERE b.ship_line_id = p_ship_line_id)
13214: AND ((p_summarized_matched_amt = 'Y' AND a.match_type_code <> 'TAX')
13215: OR (p_summarized_matched_amt = 'N'
13216: AND a.match_type_code = 'ITEM'))

Line 13340: IF(p_match_table_name = 'INL_SHIP_LINES' OR p_match_table_name IS NULL) THEN

13336: p_var_name => 'p_summarized_matched_amt',
13337: p_var_value => p_summarized_matched_amt) ;
13338:
13339: -- Handle Match Type Code
13340: IF(p_match_table_name = 'INL_SHIP_LINES' OR p_match_table_name IS NULL) THEN
13341: l_match_type_code := 'ITEM';
13342: ELSIF (p_match_table_name = 'INL_CHARGE_LINES') THEN
13343: l_match_type_code := 'CHARGE';
13344: ELSIF (p_match_table_name = 'INL_TAX_LINES') THEN

Line 13474: FROM inl_ship_lines_all

13470: WHERE ship_header_id = p_ship_header_id;
13471:
13472: SELECT NVL(MAX(last_update_date), min_date)
13473: INTO l_line_last_update_date
13474: FROM inl_ship_lines_all
13475: WHERE ship_header_id = p_ship_header_id;
13476:
13477: SELECT NVL(MAX(last_update_date), min_date)
13478: INTO l_assoc_last_update_date

Line 13953: UPDATE inl_ship_lines_all isl

13949: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
13950: p_procedure_name => l_program_name,
13951: p_debug_info => l_debug_info);
13952:
13953: UPDATE inl_ship_lines_all isl
13954: SET isl.last_update_login = l_fnd_login_id,
13955: isl.last_update_date = SYSDATE,
13956: isl.last_updated_by = l_fnd_user_id,
13957: isl.new_txn_unit_price = NULL,

Line 13963: FROM inl_ship_lines_all a

13959: isl.new_currency_conversion_date = NULL,
13960: isl.new_currency_conversion_rate = NULL
13961: WHERE isl.ship_header_id = p_ship_header_id
13962: AND isl.adjustment_num = (SELECT MIN(a.adjustment_num)
13963: FROM inl_ship_lines_all a
13964: WHERE a.ship_header_id = p_ship_header_id)
13965: AND ( isl.new_txn_unit_price IS NOT NULL
13966: OR isl.new_currency_conversion_type IS NOT NULL
13967: OR isl.new_currency_conversion_date IS NOT NULL