APPS.INL_INTERFACE_PVT dependencies on INL_ADJ_SHIP_LINES_V

Line 11601: inl_adj_ship_lines_v sla

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

Line 11623: FROM inl_adj_ship_lines_v sla

11619: SELECT sla.txn_qty,
11620: sla.txn_uom_code
11621: INTO l_qty,
11622: l_uom_code
11623: FROM inl_adj_ship_lines_v sla
11624: WHERE sla.ship_header_id = l_ship_header_id
11625: AND sla.ship_line_group_id = l_ship_line_group_id
11626: AND sla.ship_line_num = l_ship_line_num;
11627: */

Line 12403: inl_adj_ship_lines_v sl,

12399: l_new_txn_unit_price,
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

Line 12430: inl_adj_ship_lines_v sl,

12426: l_new_currency_conversion_type,
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