APPS.INL_SHIPMENT_PVT dependencies on INL_ADJ_SHIP_LINES_V

Line 778: FROM inl_adj_ship_lines_v ol

774: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
775: p_procedure_name => l_proc_name) ;
776: SELECT COUNT ( *)
777: INTO ac_lin
778: FROM inl_adj_ship_lines_v ol
779: WHERE ol.ship_header_id = p_ship_header_id
780: AND ROWNUM < 2;
781:
782: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,

Line 850: FROM inl_adj_ship_lines_v

846: p_procedure_name => l_proc_name) ;
847: BEGIN
848: SELECT ship_line_num
849: INTO l_ship_line_num
850: FROM inl_adj_ship_lines_v
851: WHERE NVL (parent_ship_line_id, ship_line_id) = p_ship_line_id;
852: EXCEPTION
853: WHEN NO_DATA_FOUND THEN
854: RETURN '';

Line 1320: inl_adj_ship_lines_v sl

1316: -- with receipts for the same receipt_source_code and src_id
1317: SELECT NVL (SUM (sl.primary_qty), 0)
1318: INTO x_qty_in_others_ops
1319: FROM inl_ship_headers sh,
1320: inl_adj_ship_lines_v sl
1321: WHERE sl.ship_header_id = sh.ship_header_id
1322: AND NVL (sl.parent_ship_line_id, sl.ship_line_id) <> p_ship_line_id
1323: AND
1324: (

Line 1344: inl_adj_ship_lines_v sl

1340: FOR c_ship_num IN
1341: (
1342: SELECT DISTINCT sh.ship_num
1343: FROM inl_ship_headers sh,
1344: inl_adj_ship_lines_v sl
1345: WHERE sl.ship_header_id = sh.ship_header_id
1346: AND NVL (sl.parent_ship_line_id, sl.ship_line_id) <> p_ship_line_id
1347: AND
1348: (

Line 1989: FROM inl_adj_ship_lines_v a

1985: ol.ship_line_src_type_code,
1986: ol.ship_line_source_id,
1987: ol.inventory_item_id,
1988: (SELECT SUM (a.primary_qty)
1989: FROM inl_adj_ship_lines_v a
1990: WHERE a.ship_header_id = ol.ship_header_id
1991: AND a.ship_line_source_id = ol.ship_line_source_id) AS sum_primary_qty,
1992: ol.primary_qty,
1993: ol.primary_unit_price,

Line 2000: FROM inl_adj_ship_lines_v ol,

1996: ol.currency_conversion_type,
1997: ol.currency_conversion_date,
1998: ol.currency_conversion_rate,
1999: 'INL_SHIP_LINES' to_parent_table_name
2000: FROM inl_adj_ship_lines_v ol,
2001: inl_ship_line_types_vl olt
2002: WHERE ol.ship_header_id = p_ship_header_id
2003: AND ol.ship_line_type_id = olt.ship_line_type_id
2004: AND ol.ship_line_group_id = p_ln_group_id

Line 3530: FROM inl_adj_ship_lines_v

3526: INTO l_final_price,
3527: l_final_qty ,
3528: l_primary_qty ,
3529: l_primary_unit_price
3530: FROM inl_adj_ship_lines_v
3531: WHERE ship_header_id = l_to_ship_header_id
3532: AND ship_line_group_id = l_ship_line_group_id
3533: AND ship_line_num = l_ship_line_num;
3534: