APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 330: /*Bug#5612236. In the below queries, replaced 'MTL_SYSTEM_ITEMS_KFV' with

326: BEGIN
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

Line 408: mtl_system_items_kfv msik

404: select msik.concatenated_segments
405: from wsh_new_deliveries_ob_grp_v del,
406: wsh_delivery_details_ob_grp_v dd,
407: wsh_delivery_assignments_v da,
408: mtl_system_items_kfv msik
409: where da.delivery_id = del.delivery_id
410: AND da.delivery_detail_id = dd.delivery_detail_id
411: AND del.delivery_id = p_delivery_id
412: AND msik.inventory_item_id(+) = dd.inventory_item_id

Line 602: from wms_license_plate_numbers wlpn, mtl_system_items_kfv msik

598: p_lpn_id IN NUMBER) IS
599: BEGIN
600: open x_items for
601: select wlpn.inventory_item_id, msik.concatenated_segments
602: from wms_license_plate_numbers wlpn, mtl_system_items_kfv msik
603: where wlpn.lpn_id = p_lpn_id
604: and wlpn.inventory_item_id = msik.inventory_item_id(+);
605: END get_items_in_lpn;
606: