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_HEADERS_ALL_S

Line 811: FROM inl_ship_headers_all sh --Bug#10381495

807: ELSIF x_ship_num IS NOT NULL AND p_transaction_type = 'UPDATE' THEN
808: BEGIN
809: SELECT sh.ship_header_id
810: INTO x_ship_header_id
811: FROM inl_ship_headers_all sh --Bug#10381495
812: WHERE sh.ship_num = x_ship_num
813: AND sh.organization_id = p_organization_id;
814: EXCEPTION
815: WHEN OTHERS THEN

Line 912: FROM inl_ship_headers_all sh --Bug#10381495

908: AND p_organization_id IS NOT NULL
909: THEN
910: SELECT COUNT(1)
911: INTO l_count_ship_num_exist
912: FROM inl_ship_headers_all sh --Bug#10381495
913: WHERE sh.ship_num = p_ship_num
914: AND sh.organization_id = p_organization_id;
915:
916: INL_LOGGING_PVT.Log_Variable(

Line 6583: FROM inl_ship_headers_all sh --Bug#10381495

6579: SELECT
6580: sh.ship_status_code
6581: INTO
6582: l_ship_status_code
6583: FROM inl_ship_headers_all sh --Bug#10381495
6584: WHERE sh.ship_header_id = x_ship_header_id;
6585: x_ship_num := NULL;
6586: EXCEPTION
6587: WHEN NO_DATA_FOUND THEN

Line 6652: FROM inl_ship_headers_all sh --Bug#10381495

6648: sh.ship_header_id
6649: INTO
6650: l_ship_status_code,
6651: x_ship_header_id
6652: FROM inl_ship_headers_all sh --Bug#10381495
6653: WHERE sh.ship_num = x_ship_num
6654: AND organization_id = l_organization_id;
6655: EXCEPTION
6656: WHEN NO_DATA_FOUND THEN

Line 9295: UPDATE inl_ship_headers_all sh --Bug#10381495

9291: p_module_name => g_module_name,
9292: p_procedure_name => l_program_name,
9293: p_debug_info => l_debug_info) ;
9294:
9295: UPDATE inl_ship_headers_all sh --Bug#10381495
9296: SET ship_date = NVL(x_ship_hdr_int_rec.ship_date ,sh.ship_date ),
9297: taxation_country = NVL(x_ship_hdr_int_rec.taxation_country ,sh.taxation_country ),
9298: document_sub_type = NVL(x_ship_hdr_int_rec.document_sub_type ,sh.document_sub_type ),
9299: ship_header_int_id = NVL(x_ship_hdr_int_rec.ship_header_int_id ,sh.ship_header_int_id ),

Line 9338: inl_ship_headers_all_s.NEXTVAL

9334: p_debug_info => l_debug_info) ;
9335: -- Check if Shipment Number is setup as(AUTOMATIC or MANUAL)
9336: SELECT user_defined_ship_num_code,
9337: next_ship_num,
9338: inl_ship_headers_all_s.NEXTVAL
9339: INTO l_user_defined_ship_num_code,
9340: l_next_ship_num,
9341: x_ship_hdr_int_rec.ship_header_id
9342: FROM inl_parameters

Line 11600: inl_ship_headers_all sh, --Bug#9660043 --Bug#10381495

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
11604: AND sla.ship_header_id = sl.ship_header_id --Bug#9660043

Line 12404: inl_ship_headers_all sh -- SCM-051

12400: l_ship_num -- SCM-051
12401: FROM
12402: rcv_transactions rt,
12403: inl_adj_ship_lines_v sl,
12404: inl_ship_headers_all sh -- SCM-051
12405: WHERE
12406: rt.transaction_id = p_to_parent_table_id
12407: AND sh.ship_header_id = sl.ship_header_id -- SCM-051
12408: AND NVL(sl.parent_ship_line_id,sl.ship_line_id) = rt.lcm_shipment_line_id

Line 12431: inl_ship_headers_all sh -- SCM-051

12427: l_new_txn_unit_price,
12428: l_ship_num
12429: FROM
12430: inl_adj_ship_lines_v sl,
12431: inl_ship_headers_all sh -- SCM-051
12432: WHERE
12433: sh.ship_header_id = sl.ship_header_id -- SCM-051
12434: AND NVL(sl.parent_ship_line_id,sl.ship_line_id) = p_to_parent_table_id
12435: FOR UPDATE of sh.ship_header_id NOWAIT; -- SCM-051

Line 12507: FROM inl_ship_headers_all sh,

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

Line 12575: FROM inl_ship_headers_all sh,

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

Line 13296: inl_ship_headers_all sh --Bug#10381495

13292: l_ship_header_id,
13293: l_INT_importedOk
13294: FROM
13295: inl_ship_headers_int shi,
13296: inl_ship_headers_all sh --Bug#10381495
13297: WHERE
13298: shi.ship_header_int_id = p_to_parent_table_id
13299: AND sh.ship_header_int_id = p_to_parent_table_id
13300: ;

Line 17643: inl_ship_headers_all sh

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
17647: AND m.group_id = l_matches_int_error(i).group_id