APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on MTL_SYSTEM_ITEMS_VL

Line 331: 'MTL_SYSTEM_ITEMS_VL'.*/

327: /** ssia 10/17/2002 Add nvl(transaction_temp_id, 0) in the select statement
328: For serial - shipping enhancement project
329: **/
330: /*Bug#5612236. In the below queries, replaced 'MTL_SYSTEM_ITEMS_KFV' with
331: 'MTL_SYSTEM_ITEMS_VL'.*/
332: x_return_Status := 'C';
333: if( p_serial_flag = 'N' ) then
334: OPEN x_deliveryLineInfo FOR
335: SELECT ' ',del.name delivery_name, dd.delivery_detail_id,

Line 352: wsh_delivery_assignments_v da, mtl_system_items_vl msiv

348: REQUESTED_QUANTITY2,
349: PICKED_QUANTITY2,
350: SHIPPED_QUANTITY2
351: FROM wsh_new_deliveries_ob_grp_v del, wsh_delivery_details_ob_grp_v dd,
352: wsh_delivery_assignments_v da, mtl_system_items_vl msiv
353: WHERE da.delivery_id = del.delivery_id
354: AND da.delivery_detail_id = dd.delivery_detail_id
355: AND ( dd.inventory_item_id = p_inventory_item_id or p_inventory_item_id = -1 )
356: AND NVL( dd.inv_interfaced_flag, 'N') = 'N'

Line 378: mtl_system_items_vl msiv

374: dd.shipped_quantity
375: FROM wsh_new_deliveries_ob_grp_v del,
376: wsh_delivery_details_ob_grp_v dd,
377: wsh_delivery_assignments_v da,
378: mtl_system_items_vl msiv
379: WHERE da.delivery_id = del.delivery_id
380: AND da.delivery_detail_id = dd.delivery_detail_id
381: AND ( dd.inventory_item_id = p_inventory_item_id
382: or p_inventory_item_id = -1 )