APPS.INL_SHIPMENT_PVT dependencies on INL_ADJ_SHIP_LINES_V

Line 799: inl_adj_ship_lines_v ol

795: -- Bug 12630218
796: CURSOR c_group_lines IS
797: SELECT slg.ship_line_group_id, slg.ship_line_group_num, COUNT(ol.ship_line_id) count_ship_line
798: FROM inl_ship_line_groups slg,
799: inl_adj_ship_lines_v ol
800: WHERE ol.ship_header_id (+) = slg.ship_header_id
801: AND ol.ship_line_group_id (+) = slg.ship_line_group_id
802: AND slg.ship_header_id = p_ship_header_id
803: GROUP BY slg.ship_line_group_id, slg.ship_line_group_num

Line 923: FROM inl_adj_ship_lines_v

919: p_procedure_name => l_program_name) ;
920: BEGIN
921: SELECT ship_line_num
922: INTO l_ship_line_num
923: FROM inl_adj_ship_lines_v
924: WHERE NVL (parent_ship_line_id, ship_line_id) = p_ship_line_id;
925: EXCEPTION
926: WHEN NO_DATA_FOUND THEN
927: RETURN '';

Line 1525: inl_adj_ship_lines_v sl

1521: -- with receipts for the same receipt_source_code and src_id
1522: SELECT NVL (SUM (sl.primary_qty), 0)
1523: INTO x_qty_in_others_ops
1524: FROM inl_ship_headers sh,
1525: inl_adj_ship_lines_v sl
1526: WHERE sl.ship_header_id = sh.ship_header_id
1527: AND NVL (sl.parent_ship_line_id, sl.ship_line_id) <> p_ship_line_id
1528: AND
1529: (

Line 1561: inl_adj_ship_lines_v sl

1557: SELECT DISTINCT sh.ship_num,
1558: sl.ship_line_num
1559: BULK COLLECT INTO l_ship_qty_validation_inf_tbl
1560: FROM inl_ship_headers sh,
1561: inl_adj_ship_lines_v sl
1562: WHERE sl.ship_header_id = sh.ship_header_id
1563: AND NVL (sl.parent_ship_line_id, sl.ship_line_id) <> p_ship_line_id
1564: AND
1565: (

Line 1586: inl_adj_ship_lines_v sl

1582: /*FOR c_ship_num IN
1583: (
1584: SELECT DISTINCT sh.ship_num
1585: FROM inl_ship_headers sh,
1586: inl_adj_ship_lines_v sl
1587: WHERE sl.ship_header_id = sh.ship_header_id
1588: AND NVL (sl.parent_ship_line_id, sl.ship_line_id) <> p_ship_line_id
1589: AND
1590: (

Line 3594: FROM inl_adj_ship_lines_v a

3590: ol.ship_line_src_type_code,
3591: ol.ship_line_source_id,
3592: ol.inventory_item_id,
3593: (SELECT SUM (a.primary_qty)
3594: FROM inl_adj_ship_lines_v a
3595: WHERE a.ship_header_id = ol.ship_header_id
3596: AND a.ship_line_source_id = ol.ship_line_source_id) AS sum_primary_qty,
3597: ol.primary_qty,
3598: ol.primary_unit_price,

Line 3606: FROM inl_adj_ship_lines_v ol

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;
3610: l_ship_lines_rec c_ship_lines%ROWTYPE;

Line 5801: FROM inl_adj_ship_lines_v

5797: INTO l_final_price,
5798: l_final_qty ,
5799: l_primary_qty ,
5800: l_primary_unit_price
5801: FROM inl_adj_ship_lines_v
5802: WHERE ship_header_id = l_to_ship_header_id
5803: AND ship_line_group_id = l_ship_line_group_id
5804: AND ship_line_num = l_ship_line_num;
5805: l_final_price := l_matched_amt / l_matched_qty;

Line 11132: inl_adj_ship_lines_v sl

11128: SELECT sl.ship_line_id, sl.new_txn_unit_price,
11129: sl.primary_qty, sl.secondary_qty, sl.txn_qty,
11130: sl.primary_uom_code, sl.secondary_uom_code
11131: FROM inl_ship_headers_all sh,
11132: inl_adj_ship_lines_v sl
11133: WHERE(sl.new_txn_unit_price IS NOT NULL
11134: OR sl.new_currency_conversion_type IS NOT NULL
11135: OR sl.new_currency_conversion_date IS NOT NULL
11136: OR sl.new_currency_conversion_rate IS NOT NULL)

Line 11393: FROM inl_adj_ship_lines_v sl

11389: NULL, -- 78
11390: NULL, -- 80
11391: NULL, -- 81
11392: NULL
11393: FROM inl_adj_ship_lines_v sl
11394: WHERE sl.ship_line_id = l_elc_adj_shiplines(i).ship_line_id);
11395: END LOOP;
11396: END IF;
11397: