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_INTERFACE_PVT dependencies on INL_SHIP_LINES_ALL

Line 2145: FROM inl_ship_lines_all sl, --Bug#10381495

2141: BEGIN
2142: SELECT sl.ship_line_group_id, slg.ship_line_group_num
2143: INTO x_ship_line_group_id,
2144: x_ship_line_group_num
2145: FROM inl_ship_lines_all sl, --Bug#10381495
2146: inl_ship_line_groups slg
2147: WHERE sl.ship_header_id = p_ship_header_id
2148: AND sl.ship_line_id = p_ship_line_id
2149: AND sl.ship_line_group_id = slg.ship_line_group_id

Line 2310: FROM inl_ship_lines_all sl --Bug#10381495

2306: x_ship_line_num := NULL;
2307: IF p_validation_flag = 'Y' THEN
2308: SELECT COUNT (1)
2309: INTO l_count_ship_ln_num_exist
2310: FROM inl_ship_lines_all sl --Bug#10381495
2311: WHERE sl.ship_line_id = x_ship_line_id;
2312:
2313: IF NVL(l_count_ship_ln_num_exist,0) = 0 THEN
2314: l_debug_info := 'No Shipment Line found';

Line 2342: FROM inl_ship_lines_all sl --Bug#10381495

2338: l_colum_value := x_ship_line_num;
2339: BEGIN
2340: SELECT sl.ship_line_id
2341: INTO x_ship_line_id
2342: FROM inl_ship_lines_all sl --Bug#10381495
2343: WHERE sl.ship_header_id = p_ship_header_id
2344: AND sl.ship_line_group_id = p_ship_line_group_id
2345: AND sl.ship_line_num = x_ship_line_num;
2346: EXCEPTION

Line 3584: FROM inl_ship_lines_all sl --Bug#10381495

3580: INTO l_inventory_item_id,
3581: l_txn_uom_code,
3582: l_txn_qty,
3583: l_txn_unit_price
3584: FROM inl_ship_lines_all sl --Bug#10381495
3585: WHERE sl.ship_line_id = p_ship_line_id;
3586: END IF;
3587:
3588: INL_LOGGING_PVT.Log_Variable(

Line 8100: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all

8096: -- Utility name : Delete_Ship
8097: -- Type : Private
8098: -- Function : Delete a LCM Shipment from inl_ship_holds, inl_associations, inl_matches, inl_match_amount
8099: -- inl_allocations, inl_tax_lines, inl_charge_lines,
8100: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all
8101: -- If a Charge/Tax is associated with more than one Shipment, only the associations
8102: -- of the current shipment are going to be deleted
8103: -- Pre-reqs : None
8104: -- Parameters :

Line 8312: l_debug_info := 'Delete from inl_ship_lines_all';

8308: p_var_value => sql%rowcount
8309: );
8310:
8311: -- Table
8312: l_debug_info := 'Delete from inl_ship_lines_all';
8313: INL_LOGGING_PVT.Log_Statement(
8314: p_module_name => g_module_name,
8315: p_procedure_name => l_program_name,
8316: p_debug_info => l_debug_info) ;

Line 8318: DELETE FROM inl_ship_lines_all

8314: p_module_name => g_module_name,
8315: p_procedure_name => l_program_name,
8316: p_debug_info => l_debug_info) ;
8317:
8318: DELETE FROM inl_ship_lines_all
8319: WHERE ship_header_id = p_ship_header_id;
8320:
8321: INL_LOGGING_PVT.Log_Variable(
8322: p_module_name => g_module_name,

Line 8917: FROM inl_ship_lines_all

8913: IF x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_num IS NULL THEN
8914: -- Get the next Ship Line Number
8915: SELECT MAX(ship_line_num)
8916: INTO x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_num
8917: FROM inl_ship_lines_all
8918: WHERE ship_header_id = x_ship_ln_int_lst(l_ship_ln_int_idx).ship_header_id
8919: AND ship_line_group_id = x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_group_id;
8920:
8921: x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_num := NVL(x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_num, 0) + 1;

Line 8935: SELECT inl_ship_Lines_all_s.NEXTVAL

8931: p_module_name => g_module_name,
8932: p_procedure_name => l_program_name,
8933: p_debug_info => l_debug_info) ;
8934: -- Get the next Shipment Line Id
8935: SELECT inl_ship_Lines_all_s.NEXTVAL
8936: INTO x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_id
8937: FROM dual;
8938:
8939: INL_LOGGING_PVT.Log_Variable(

Line 8952: INSERT INTO inl_ship_lines_all (

8948: p_procedure_name => l_program_name,
8949: p_debug_info => l_debug_info);
8950:
8951: -- Insert an INL SHIP LINE record
8952: INSERT INTO inl_ship_lines_all (
8953: ship_header_id, --01
8954: ship_line_group_id, --02
8955: ship_line_id, --03
8956: ship_line_num, --04

Line 9117: UPDATE inl_ship_lines_all sl

9113: p_procedure_name => l_program_name,
9114: p_debug_info => l_debug_info) ;
9115:
9116: -- update the INL SHIP LINE record
9117: UPDATE inl_ship_lines_all sl
9118: SET adjustment_num = 0,
9119: match_id = NULL,
9120: txn_qty = NVL(x_ship_ln_int_lst(l_ship_ln_int_idx).txn_qty , sl.txn_qty) ,
9121: txn_uom_code = NVL(x_ship_ln_int_lst(l_ship_ln_int_idx).txn_uom_code , sl.txn_uom_code) ,

Line 10029: FROM inl_ship_lines_all --Bug#10381495

10025: WHERE ship_header_id = x_new_to_parent_table_id;
10026: ELSIF x_new_to_parent_table_name = 'INL_SHIP_LINES' THEN
10027: SELECT ship_header_id
10028: INTO x_ship_header_id
10029: FROM inl_ship_lines_all --Bug#10381495
10030: WHERE ship_line_id = x_new_to_parent_table_id;
10031: ELSIF x_new_to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN
10032: SELECT ship_header_id
10033: INTO x_ship_header_id

Line 11599: inl_ship_lines_all sl, --Bug#10381495

11595: --Bug#9660043 l_ship_line_group_id,
11596: l_qty , --Bug#9660043
11597: l_uom_code --Bug#9660043
11598: FROM
11599: inl_ship_lines_all sl, --Bug#10381495
11600: inl_ship_headers_all sh, --Bug#9660043 --Bug#10381495
11601: inl_adj_ship_lines_v sla
11602: WHERE sl.ship_line_id = p_ship_line_id
11603: AND sh.ship_header_id = sl.ship_header_id --Bug#9660043

Line 12508: inl_ship_lines_all sl,

12504: -- SCM-051
12505: SELECT sh.ship_num
12506: INTO l_ship_num
12507: FROM inl_ship_headers_all sh,
12508: inl_ship_lines_all sl,
12509: rcv_transactions rt
12510: WHERE sh.ship_header_id = sl.ship_header_id
12511: AND rt.transaction_id = p_to_parent_table_id
12512: AND NVL(sl.parent_ship_line_id,sl.ship_line_id) = rt.lcm_shipment_line_id

Line 12529: inl_ship_lines_all sl,

12525: l_count_elc_ong
12526: FROM
12527: inl_adj_charge_lines_v cl,
12528: inl_associations a,
12529: inl_ship_lines_all sl,
12530: rcv_transactions rt
12531: WHERE
12532: rt.transaction_id = p_to_parent_table_id
12533: AND NVL(sl.parent_ship_line_id,sl.ship_line_id) = rt.lcm_shipment_line_id

Line 12576: inl_ship_lines_all sl

12572: -- SCM-051
12573: SELECT sh.ship_num
12574: INTO l_ship_num
12575: FROM inl_ship_headers_all sh,
12576: inl_ship_lines_all sl
12577: WHERE sh.ship_header_id = sl.ship_header_id
12578: AND sl.ship_line_id = p_to_parent_table_id
12579: AND ROWNUM = 1
12580: FOR UPDATE OF sh.ship_header_id NOWAIT;

Line 12595: inl_ship_lines_all sl

12591: l_count_elc_ong
12592: FROM
12593: inl_adj_charge_lines_v cl,
12594: inl_associations a,
12595: inl_ship_lines_all sl
12596: WHERE
12597: sl.ship_line_id = p_to_parent_table_id
12598: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
12599: AND (

Line 13207: FROM inl_ship_lines_all --Bug#10381495

13203: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES' THEN
13204: l_INT_importedOk := 'Y';
13205: SELECT ship_header_id
13206: INTO l_ship_header_id
13207: FROM inl_ship_lines_all --Bug#10381495
13208: WHERE ship_line_id = p_to_parent_table_id;
13209: IF p_match_type_code IN('ITEM', 'CHARGE', 'TAX') THEN
13210: l_matchTpCdOk := 'Y';
13211: END IF;

Line 13260: inl_ship_lines_all sl --Bug#10381495

13256: l_ship_header_id,
13257: l_INT_importedOk
13258: FROM
13259: inl_ship_lines_int sli,
13260: inl_ship_lines_all sl --Bug#10381495
13261: WHERE
13262: sli.ship_line_int_id = p_to_parent_table_id
13263: AND sl.ship_line_int_id = p_to_parent_table_id;
13264: --Bug#9660043

Line 13336: inl_ship_lines_all sl --Bug#10381495

13332: l_ship_line_id,
13333: l_ship_header_id
13334: FROM
13335: rcv_transactions rt,
13336: inl_ship_lines_all sl --Bug#10381495
13337: WHERE
13338: rt.transaction_id = p_to_parent_table_id
13339: AND sl.ship_line_id = rt.lcm_shipment_line_id
13340: ;

Line 17598: inl_ship_lines_all sl

17594: CURSOR c_matches_int_error IS
17595: SELECT DISTINCT m.group_id
17596: FROM inl_matches_int m,
17597: rcv_transactions rt,
17598: inl_ship_lines_all sl
17599: WHERE sl.ship_line_id = rt.lcm_shipment_line_id
17600: AND rt.transaction_id = m.to_parent_table_id
17601: AND m.to_parent_table_name = 'RCV_TRANSACTIONS'
17602: AND m.processing_status_code = 'ERROR'

Line 17642: inl_ship_lines_all sl,

17638: SELECT COUNT(1)
17639: INTO l_count_elc_pend_shipment
17640: FROM inl_matches_int m,
17641: rcv_transactions rt,
17642: inl_ship_lines_all sl,
17643: inl_ship_headers_all sh
17644: WHERE sh.ship_header_id = sl.ship_header_id
17645: AND sl.ship_line_id = rt.lcm_shipment_line_id
17646: AND rt.transaction_id = m.to_parent_table_id