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_ALL

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 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 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 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 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 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 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 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 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 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 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