eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1152: from wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd, mtl_system_items_kfv msik

1148: /* select wstt.trip_id, wstt.delivery_id, wstt.delivery_detail_id, wstt.inventory_item_id, wstt.quantity, wstt.outermost_lpn,
1149: wstt.parent_lpn_id, wstt.parent_lpn, wdd.serial_number,
1150: msik.concatenated_segments, msik.serial_number_control_code, wdd.requested_quantity,
1151: wdd.subinventory, wdd.revision, wdd.locator_id, wdd.lot_number
1152: from wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd, mtl_system_items_kfv msik
1153: where wstt.delivery_detail_id = wdd.delivery_detail_id
1154: and wstt.outermost_lpn_id = p_outermost_lpn_id
1155: and msik.inventory_item_id = wdd.inventory_item_id
1156: and msik.organization_id = wdd.organization_id

Line 1165: mtl_system_items_kfv msik,

1161: msik.concatenated_segments,
1162: msik.serial_number_control_code, wdd.requested_quantity,wdd.subinventory, wdd.revision,
1163: wdd.locator_id, wdd.lot_number,wdd.picked_quantity
1164: from wms_license_plate_numbers wlpn, wms_license_plate_numbers wlpn2, wsh_delivery_details_ob_grp_v wdd,
1165: mtl_system_items_kfv msik,
1166: wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2
1167: where wlpn.outermost_lpn_id = p_outermost_lpn_id
1168: and wlpn.lpn_id = wdd2.lpn_id
1169: and wdd2.lpn_id is not null -- for performance, bug 2418639

Line 1395: from mtl_system_items_kfv msik

1391: and wstt.inventory_item_id = l_inventory_item_id;
1392:
1393: select distinct msik.concatenated_segments
1394: into l_item_name
1395: from mtl_system_items_kfv msik
1396: where msik.inventory_item_id = l_inventory_item_id;
1397:
1398: exit sum_delivery_details_loop;
1399: else

Line 3244: , mtl_system_items_kfv msik

3240: from wsh_delivery_details_ob_grp_v wdd
3241: , wsh_delivery_assignments_v wda
3242: , wsh_delivery_legs_ob_grp_v wdl
3243: , wsh_Trip_stops_ob_grp_v pickup_stop
3244: , mtl_system_items_kfv msik
3245: where
3246: wda.delivery_id = wdl.delivery_id
3247: AND wda.delivery_detail_id = wdd.delivery_detail_id
3248: and wdl.pick_up_stop_id = pickup_stop.stop_id

Line 3278: , mtl_system_items_kfv msik

3274: , wsh_delivery_assignments_v wda
3275: , wsh_new_deliveries_ob_grp_v wnd
3276: , wsh_delivery_legs_ob_grp_v wdl
3277: , wsh_trip_Stops_ob_grp_v pickup_stop
3278: , mtl_system_items_kfv msik
3279: where wnd.delivery_id = wda.delivery_id
3280: AND wda.delivery_id = wdl.delivery_id
3281: AND wda.delivery_detail_id = wdd.delivery_detail_id
3282: and wdl.pick_up_stop_id = pickup_stop.stop_id

Line 3298: , mtl_system_items_kfv msik

3294: select count(*)
3295: into l_count
3296: from wsh_delivery_details_ob_grp_v wdd
3297: , wsh_delivery_assignments_v wda
3298: , mtl_system_items_kfv msik
3299: where
3300: wda.delivery_detail_id = wdd.delivery_detail_id
3301: and wda.delivery_id in (select distinct delivery_id
3302: from wms_shipping_transaction_temp

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

3332: open x_missing_item FOR select 1 from dual;
3333: return;
3334: END;
3335:
3336: /*Bug#5612236. In the below query, replaced 'MTL_SYSTEM_ITEMS_KFV' with
3337: 'MTL_SYSTEM_ITEMS_VL'.*/
3338: open x_missing_item FOR
3339: select wnd.name
3340: ,wdd.delivery_detail_id

Line 4979: from mtl_system_items_kfv msik, mtl_material_statuses_vl mst

4975: l_serial_status_enabled VARCHAR2(1);
4976: begin
4977: select nvl(msik.serial_status_enabled,'N'), nvl(msik.default_Serial_status_id, -1), mst.status_code
4978: into l_serial_status_enabled, l_serial_status_id, l_serial_status_code
4979: from mtl_system_items_kfv msik, mtl_material_statuses_vl mst
4980: where msik.organization_id = p_organization_id
4981: and msik.inventory_item_id = p_inventory_item_id
4982: and msik.default_serial_status_id = mst.status_id(+);
4983:

Line 5591: mtl_system_items_kfv msik

5587: wsh_delivery_assignments_v wda,
5588: wsh_new_deliveries_ob_grp_v wnd,
5589: wsh_delivery_legs_ob_grp_v wdl,
5590: wsh_trip_Stops_ob_grp_v pickup_stop,
5591: mtl_system_items_kfv msik
5592: WHERE wnd.delivery_id = wda.delivery_id
5593: AND wda.delivery_id = wdl.delivery_id
5594: AND wda.delivery_detail_id = wdd.delivery_detail_id
5595: AND wdl.pick_up_stop_id = pickup_stop.stop_id

Line 5624: mtl_system_items_kfv msik

5620: wsh_delivery_assignments_v wda,
5621: wsh_new_deliveries_ob_grp_v wnd,
5622: wsh_delivery_legs_ob_grp_v wdl,
5623: wsh_trip_stops_ob_grp_v pickup_stop,
5624: mtl_system_items_kfv msik
5625: WHERE wnd.delivery_id = wda.delivery_id
5626: AND wda.delivery_id = wdl.delivery_id
5627: AND wda.delivery_detail_id = wdd.delivery_detail_id
5628: AND wdl.pick_up_stop_id = pickup_stop.stop_id

Line 5641: mtl_system_items_kfv

5637: SELECT COUNT(*)
5638: INTO l_count
5639: FROM wsh_delivery_details_ob_grp_v wdd,
5640: wsh_delivery_assignments_v wda,
5641: mtl_system_items_kfv
5642: msik, wsh_new_deliveries_ob_grp_v wnd
5643: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
5644: AND wdd.lpn_id IS NULL
5645: AND wda.delivery_id IN (SELECT DISTINCT delivery_id

Line 5686: mtl_system_items_kfv

5682: msik.concatenated_segments,
5683: msik.description
5684: FROM wsh_delivery_details_ob_grp_v wdd,
5685: wsh_delivery_assignments_v wda,
5686: mtl_system_items_kfv
5687: msik, wsh_new_deliveries_ob_grp_v wnd
5688: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
5689: AND wdd.lpn_id IS NULL
5690: AND wda.delivery_id IN (SELECT DISTINCT delivery_id

Line 5735: , mtl_system_items_kfv msi

5731: , wlpn.gross_weight_uom_code
5732: , wlpn.tare_weight
5733: , wlpn.tare_weight_uom_code
5734: FROM wms_license_plate_numbers wlpn
5735: , mtl_system_items_kfv msi
5736: WHERE wlpn.organization_id = p_organization_id
5737: AND wlpn.license_plate_number LIKE (p_lpn)
5738: AND wlpn.lpn_context = 1 /* Resides in Inventory */
5739: AND wlpn.parent_lpn_id is null

Line 5859: , mtl_system_items_kfv msik

5855: , NVL(wds.processed_quantity,0) processed_quantity
5856: , wdd.src_requested_quantity_uom
5857: FROM oe_order_lines_all oel
5858: , wsh_delivery_details_ob_grp_v wdd
5859: , mtl_system_items_kfv msik
5860: , wms_direct_ship_temp wds
5861: WHERE oel.header_id =p_header_id
5862: and oel.ship_from_org_id = p_org_id
5863: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')

Line 5956: , mtl_system_items_kfv msik

5952: , 0 processed_quantity
5953: , wdd.src_requested_quantity_uom
5954: FROM oe_order_lines_all oel
5955: , wsh_delivery_details_ob_grp_v wdd
5956: , mtl_system_items_kfv msik
5957: , wms_direct_ship_temp wds
5958: WHERE oel.header_id =p_header_id
5959: and oel.ship_from_org_id = p_org_id
5960: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')

Line 6061: , mtl_system_items_kfv msik

6057: , NVL(wds.processed_quantity,0) processed_quantity
6058: , wdd.src_requested_quantity_uom
6059: FROM oe_order_lines_all oel
6060: , wsh_delivery_details_ob_grp_v wdd
6061: , mtl_system_items_kfv msik
6062: , wms_direct_ship_temp wds
6063: WHERE oel.header_id =p_header_id
6064: and oel.ship_from_org_id = p_org_id
6065: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')

Line 6159: , mtl_system_items_kfv msik

6155: , 0 processed_quantity
6156: , wdd.src_requested_quantity_uom
6157: FROM oe_order_lines_all oel
6158: , wsh_delivery_details_ob_grp_v wdd
6159: , mtl_system_items_kfv msik
6160: , wms_direct_ship_temp wds
6161: WHERE oel.header_id =p_header_id
6162: and oel.ship_from_org_id = p_org_id
6163: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')

Line 6758: from wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_system_items_kfv msik

6754: x_return_status := 'S';
6755:
6756: SELECT wlc.parent_lpn_id, wlc.inventory_item_id
6757: bulk collect INTO l_parent_lpn_id, l_inventory_item_id
6758: from wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_system_items_kfv msik
6759: where wlc.organization_id = p_org_id
6760: and msik.organization_id = p_org_id
6761: and wlpn.organization_id = wlc.organization_id
6762: AND wlpn.outermost_lpn_id = p_outermost_lpn_id