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 1205: from wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd, mtl_system_items_kfv msik

1201: /* select wstt.trip_id, wstt.delivery_id, wstt.delivery_detail_id, wstt.inventory_item_id, wstt.quantity, wstt.outermost_lpn,
1202: wstt.parent_lpn_id, wstt.parent_lpn, wdd.serial_number,
1203: msik.concatenated_segments, msik.serial_number_control_code, wdd.requested_quantity,
1204: wdd.subinventory, wdd.revision, wdd.locator_id, wdd.lot_number
1205: from wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd, mtl_system_items_kfv msik
1206: where wstt.delivery_detail_id = wdd.delivery_detail_id
1207: and wstt.outermost_lpn_id = p_outermost_lpn_id
1208: and msik.inventory_item_id = wdd.inventory_item_id
1209: and msik.organization_id = wdd.organization_id

Line 1218: mtl_system_items_kfv msik,

1214: msik.concatenated_segments,
1215: msik.serial_number_control_code, wdd.requested_quantity,wdd.subinventory, wdd.revision,
1216: wdd.locator_id, wdd.lot_number,wdd.picked_quantity
1217: from wms_license_plate_numbers wlpn, wms_license_plate_numbers wlpn2, wsh_delivery_details_ob_grp_v wdd,
1218: mtl_system_items_kfv msik,
1219: wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2
1220: where wlpn.outermost_lpn_id = p_outermost_lpn_id
1221: and wlpn.lpn_id = wdd2.lpn_id
1222: and wdd2.lpn_id is not null -- for performance, bug 2418639

Line 1453: from mtl_system_items_kfv msik

1449: and wstt.inventory_item_id = l_inventory_item_id;
1450:
1451: select distinct msik.concatenated_segments
1452: into l_item_name
1453: from mtl_system_items_kfv msik
1454: where msik.inventory_item_id = l_inventory_item_id;
1455:
1456: exit sum_delivery_details_loop;
1457: else

Line 3305: , mtl_system_items_kfv msik

3301: from wsh_delivery_details_ob_grp_v wdd
3302: , wsh_delivery_assignments_v wda
3303: , wsh_delivery_legs_ob_grp_v wdl
3304: , wsh_Trip_stops_ob_grp_v pickup_stop
3305: , mtl_system_items_kfv msik
3306: where
3307: wda.delivery_id = wdl.delivery_id
3308: AND wda.delivery_detail_id = wdd.delivery_detail_id
3309: and wdl.pick_up_stop_id = pickup_stop.stop_id

Line 3339: , mtl_system_items_kfv msik

3335: , wsh_delivery_assignments_v wda
3336: , wsh_new_deliveries_ob_grp_v wnd
3337: , wsh_delivery_legs_ob_grp_v wdl
3338: , wsh_trip_Stops_ob_grp_v pickup_stop
3339: , mtl_system_items_kfv msik
3340: where wnd.delivery_id = wda.delivery_id
3341: AND wda.delivery_id = wdl.delivery_id
3342: AND wda.delivery_detail_id = wdd.delivery_detail_id
3343: and wdl.pick_up_stop_id = pickup_stop.stop_id

Line 3359: , mtl_system_items_kfv msik

3355: select count(*)
3356: into l_count
3357: from wsh_delivery_details_ob_grp_v wdd
3358: , wsh_delivery_assignments_v wda
3359: , mtl_system_items_kfv msik
3360: where
3361: wda.delivery_detail_id = wdd.delivery_detail_id
3362: and wda.delivery_id in (select distinct delivery_id
3363: from wms_shipping_transaction_temp

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

3393: open x_missing_item FOR select 1 from dual;
3394: return;
3395: END;
3396:
3397: /*Bug#5612236. In the below query, replaced 'MTL_SYSTEM_ITEMS_KFV' with
3398: 'MTL_SYSTEM_ITEMS_VL'.*/
3399: open x_missing_item FOR
3400: select wnd.name
3401: ,wdd.delivery_detail_id

Line 5139: from mtl_system_items_kfv msik, mtl_material_statuses_vl mst

5135: l_serial_status_enabled VARCHAR2(1);
5136: begin
5137: select nvl(msik.serial_status_enabled,'N'), nvl(msik.default_Serial_status_id, -1), mst.status_code
5138: into l_serial_status_enabled, l_serial_status_id, l_serial_status_code
5139: from mtl_system_items_kfv msik, mtl_material_statuses_vl mst
5140: where msik.organization_id = p_organization_id
5141: and msik.inventory_item_id = p_inventory_item_id
5142: and msik.default_serial_status_id = mst.status_id(+);
5143:

Line 5768: mtl_system_items_kfv msik

5764: wsh_delivery_assignments_v wda,
5765: wsh_new_deliveries_ob_grp_v wnd,
5766: wsh_delivery_legs_ob_grp_v wdl,
5767: wsh_trip_Stops_ob_grp_v pickup_stop,
5768: mtl_system_items_kfv msik
5769: WHERE wnd.delivery_id = wda.delivery_id
5770: AND wda.delivery_id = wdl.delivery_id
5771: AND wda.delivery_detail_id = wdd.delivery_detail_id
5772: AND wdl.pick_up_stop_id = pickup_stop.stop_id

Line 5801: mtl_system_items_kfv msik

5797: wsh_delivery_assignments_v wda,
5798: wsh_new_deliveries_ob_grp_v wnd,
5799: wsh_delivery_legs_ob_grp_v wdl,
5800: wsh_trip_stops_ob_grp_v pickup_stop,
5801: mtl_system_items_kfv msik
5802: WHERE wnd.delivery_id = wda.delivery_id
5803: AND wda.delivery_id = wdl.delivery_id
5804: AND wda.delivery_detail_id = wdd.delivery_detail_id
5805: AND wdl.pick_up_stop_id = pickup_stop.stop_id

Line 5818: mtl_system_items_kfv

5814: SELECT COUNT(*)
5815: INTO l_count
5816: FROM wsh_delivery_details_ob_grp_v wdd,
5817: wsh_delivery_assignments_v wda,
5818: mtl_system_items_kfv
5819: msik, wsh_new_deliveries_ob_grp_v wnd
5820: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
5821: AND wdd.lpn_id IS NULL
5822: AND wda.delivery_id IN (SELECT DISTINCT delivery_id

Line 5863: mtl_system_items_kfv

5859: msik.concatenated_segments,
5860: msik.description
5861: FROM wsh_delivery_details_ob_grp_v wdd,
5862: wsh_delivery_assignments_v wda,
5863: mtl_system_items_kfv
5864: msik, wsh_new_deliveries_ob_grp_v wnd
5865: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
5866: AND wdd.lpn_id IS NULL
5867: AND wda.delivery_id IN (SELECT DISTINCT delivery_id

Line 5914: , mtl_system_items_kfv msi

5910: , wlpn.gross_weight_uom_code
5911: , wlpn.tare_weight
5912: , wlpn.tare_weight_uom_code
5913: FROM wms_license_plate_numbers wlpn
5914: , mtl_system_items_kfv msi
5915: WHERE wlpn.organization_id = p_organization_id
5916: AND wlpn.license_plate_number LIKE (p_lpn)
5917: AND wlpn.lpn_context = 1 /* Resides in Inventory */
5918: AND wlpn.parent_lpn_id is null

Line 5940: , mtl_system_items_kfv msi

5936: , wlpn.gross_weight_uom_code
5937: , wlpn.tare_weight
5938: , wlpn.tare_weight_uom_code
5939: FROM wms_license_plate_numbers wlpn
5940: , mtl_system_items_kfv msi
5941: WHERE wlpn.organization_id = p_organization_id
5942: AND wlpn.license_plate_number LIKE (p_lpn)
5943: AND wlpn.lpn_context = 1 /* Resides in Inventory */
5944: AND wlpn.parent_lpn_id is null

Line 6083: , mtl_system_items_kfv msik

6079: , wdd.REQUESTED_QUANTITY_UOM2
6080: , NVL(wds.secondary_processed_qty,0) secondary_processed_qty
6081: FROM oe_order_lines_all oel
6082: , wsh_delivery_details_ob_grp_v wdd
6083: , mtl_system_items_kfv msik
6084: , wms_direct_ship_temp wds
6085: WHERE oel.header_id =p_header_id
6086: and oel.ship_from_org_id = p_org_id
6087: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')

Line 6187: , mtl_system_items_kfv msik

6183: , wdd.REQUESTED_QUANTITY_UOM2
6184: , 0 secondary_processed_qty
6185: FROM oe_order_lines_all oel
6186: , wsh_delivery_details_ob_grp_v wdd
6187: , mtl_system_items_kfv msik
6188: , wms_direct_ship_temp wds
6189: WHERE oel.header_id =p_header_id
6190: and oel.ship_from_org_id = p_org_id
6191: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')

Line 6298: , mtl_system_items_kfv msik

6294: , wdd.REQUESTED_QUANTITY_UOM2
6295: , NVL(wds.secondary_processed_qty,0) secondary_processed_qty
6296: FROM oe_order_lines_all oel
6297: , wsh_delivery_details_ob_grp_v wdd
6298: , mtl_system_items_kfv msik
6299: , wms_direct_ship_temp wds
6300: WHERE oel.header_id =p_header_id
6301: and oel.ship_from_org_id = p_org_id
6302: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')

Line 6403: , mtl_system_items_kfv msik

6399: , wdd.REQUESTED_QUANTITY_UOM2
6400: , 0 secondary_processed_qty
6401: FROM oe_order_lines_all oel
6402: , wsh_delivery_details_ob_grp_v wdd
6403: , mtl_system_items_kfv msik
6404: , wms_direct_ship_temp wds
6405: WHERE oel.header_id =p_header_id
6406: and oel.ship_from_org_id = p_org_id
6407: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')

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

7001: x_return_status := 'S';
7002:
7003: SELECT wlc.parent_lpn_id, wlc.inventory_item_id
7004: bulk collect INTO l_parent_lpn_id, l_inventory_item_id
7005: from wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_system_items_kfv msik
7006: where wlc.organization_id = p_org_id
7007: and msik.organization_id = p_org_id
7008: and wlpn.organization_id = wlc.organization_id
7009: AND wlpn.outermost_lpn_id = p_outermost_lpn_id