DBA Data[Home] [Help]

APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

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

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

Line 407: mtl_system_items_kfv msik

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

Line 601: from wms_license_plate_numbers wlpn, mtl_system_items_kfv msik

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