APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on MTL_SYSTEM_ITEMS_VL

Line 330: 'MTL_SYSTEM_ITEMS_VL'.*/

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

Line 351: wsh_delivery_assignments_v da, mtl_system_items_vl msiv

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

Line 377: mtl_system_items_vl msiv

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