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_DIRECT_SHIP_PVT dependencies on MTL_SYSTEM_ITEMS

Line 183: ,mtl_system_items_kfv msi

179: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wt.ship_method_code)
180: ,wt.ship_method_code
181: FROM wsh_trips_ob_grp_v wt
182: ,wsh_trip_stops_ob_grp_v wts
183: ,mtl_system_items_kfv msi
184: WHERE wt.trip_id = p_trip_id
185: AND wt.trip_id = wts.trip_id
186: AND (wt.vehicle_item_id = msi.inventory_item_id(+)
187: AND msi.organization_id(+) = p_org_id)

Line 1055: ,mtl_system_items_kfv msik

1051: msik.description
1052: from wsh_delivery_details_ob_grp_v wdd
1053: ,wsh_delivery_assignments_v wda
1054: ,wsh_new_deliveries_ob_grp_v wnd
1055: ,mtl_system_items_kfv msik
1056: where wnd.delivery_id = p_delivery_id
1057: AND wnd.delivery_id = wda.delivery_id
1058: AND wda.delivery_detail_id = wdd.delivery_detail_id
1059: AND wdd.lpn_id is null

Line 3126: FROM mtl_system_items

3122: lot_divisible_flag
3123: INTO l_serial_ctrl_code,
3124: l_lot_ctrl_code,
3125: l_lot_divisible_flag
3126: FROM mtl_system_items
3127: WHERE inventory_item_id = l_item_id
3128: AND organization_id = p_org_id;
3129:
3130: IF (l_debug = 1) THEN

Line 4699: mtl_system_items msi

4695: , l_lot_control_code
4696: , l_serial_number_control_code
4697: FROM wms_direct_ship_temp wds,
4698: wsh_delivery_details wdd,
4699: mtl_system_items msi
4700: WHERE wds.organization_id = p_organization_id
4701: AND wds.lpn_id = p_lpn_id
4702: AND wds.order_header_id = p_source_header_id
4703: AND wds.order_line_id = p_source_line_id

Line 4910: MTL_SYSTEM_ITEMS MSI

4906: ,l_delivery_detail_tab(i).LOT_CONTROL_CODE
4907: ,l_delivery_detail_tab(i).SERIAL_NUMBER_CONTROL_CODE
4908: FROM WMS_DIRECT_SHIP_TEMP WDS,
4909: WSH_DELIVERY_DETAILS WDD,
4910: MTL_SYSTEM_ITEMS MSI
4911: WHERE WDS.ORGANIZATION_ID = p_organization_id
4912: AND WDS.lpn_id = p_lpn_id
4913: AND WDS.ORDER_HEADER_ID = p_source_header_id
4914: AND WDS.ORDER_LINE_ID = p_source_line_id

Line 4957: , mtl_system_items msi

4953: , msi.serial_number_control_code
4954: FROM wms_direct_ship_temp wds
4955: , wms_license_plate_numbers wlpn
4956: , mtl_secondary_inventories sub
4957: , mtl_system_items msi
4958: WHERE wds.GROUP_ID = p_group_id
4959: AND wds.organization_id = p_organization_id
4960: AND wds.dock_door_id = p_dock_door_id
4961: AND wds.lpn_id = p_lpn_id

Line 5337: ' mtl_system_items msi ' ||

5333:
5334: l_sql_query := l_sql_query ||
5335: ' FROM wms_direct_ship_temp wds, ' ||
5336: ' wsh_delivery_details_ob_grp_v wdd, ' ||
5337: ' mtl_system_items msi ' ||
5338: ' WHERE wds.organization_id = :p_organization_id ' ||
5339: ' AND wds.lpn_id = :p_lpn_id ' ||
5340: ' AND wds.order_header_id = :p_order_header_id ' ||
5341: ' AND wds.order_line_id = :p_order_line_id ' ||

Line 6758: FROM mtl_system_items

6754: , serial_number_control_code
6755: INTO l_revision_control
6756: , l_lot_control
6757: , l_serial_control
6758: FROM mtl_system_items
6759: WHERE organization_id = p_organization_id
6760: AND inventory_item_id = p_inventory_item_id;
6761:
6762: IF (l_revision_control = 2) THEN

Line 7908: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, mtl_system_items_kfv msik

7904: x_return_status := fnd_api.g_ret_sts_success;
7905:
7906: SELECT COUNT(*)
7907: INTO l_count
7908: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, mtl_system_items_kfv msik
7909: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
7910: AND NVL(wdd.container_flag, 'N') = 'N'
7911: AND wda.delivery_id = p_delivery_id
7912: AND wdd.inventory_item_id = msik.inventory_item_id

Line 8251: , serial_control_code mtl_system_items_b.serial_number_control_code%TYPE

8247: , quantity wms_lpn_contents.quantity%TYPE
8248: , revision_control VARCHAR2(5)
8249: , lot_control VARCHAR2(5)
8250: , serial_control VARCHAR2(5)
8251: , serial_control_code mtl_system_items_b.serial_number_control_code%TYPE
8252: , reservable_type mtl_system_items_b.reservable_type%TYPE
8253: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
8254: , ont_pricing_qty_source VARCHAR2(30)
8255: );

Line 8252: , reservable_type mtl_system_items_b.reservable_type%TYPE

8248: , revision_control VARCHAR2(5)
8249: , lot_control VARCHAR2(5)
8250: , serial_control VARCHAR2(5)
8251: , serial_control_code mtl_system_items_b.serial_number_control_code%TYPE
8252: , reservable_type mtl_system_items_b.reservable_type%TYPE
8253: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
8254: , ont_pricing_qty_source VARCHAR2(30)
8255: );
8256: l_lpn_content_cur_rec l_lpn_content_cur_rec_typ;

Line 8394: ' , mtl_system_items_b msi ' ||

8390:
8391: l_sql_query := l_sql_query ||
8392: ' FROM wms_lpn_contents wlc ' ||
8393: ' , wms_license_plate_numbers wlpn ' ||
8394: ' , mtl_system_items_b msi ' ||
8395: ' , (SELECT lpn_id ' ||
8396: ' , revision ' ||
8397: ' , lot_number ' ||
8398: ' , inventory_item_id ' ||

Line 8745: FROM oe_order_lines_all oel, mtl_system_items msi

8741: , msi.serial_number_control_code
8742: , oel.end_item_unit_number
8743: , oel.flow_status_code
8744: INTO l_order_line_rec
8745: FROM oe_order_lines_all oel, mtl_system_items msi
8746: WHERE msi.organization_id = p_org_id
8747: AND oel.inventory_item_id = msi.inventory_item_id
8748: AND line_id = l_mtl_reservation_tab(resv_index).demand_source_line_id;
8749: EXCEPTION

Line 10701: FROM wms_direct_ship_temp wds, oe_order_lines_all oel, mtl_system_items_kfv msi

10697: , oel.item_revision revision
10698: , oel.end_item_unit_number
10699: , oel.request_date
10700: , msi.primary_uom_code
10701: FROM wms_direct_ship_temp wds, oe_order_lines_all oel, mtl_system_items_kfv msi
10702: WHERE wds.organization_id = p_org_id
10703: AND wds.GROUP_ID = g_group_id
10704: AND wds.dock_door_id = p_dock_door_id
10705: AND wds.lpn_id = p_lpn_id

Line 11844: FROM mtl_system_items msi, WMS_DS_CT_WT_GTEMP t

11840: t.PICKED_QUANTITY, t.PICKED_UOM_CODE, msi.primary_uom_code,
11841: NULL, NULL), 0)) PICKED_QUANTITY_IN_PRI_UOM
11842: ,t.SECONDARY_UOM_CODE
11843: ,t.SECONDARY_QUANTITY
11844: FROM mtl_system_items msi, WMS_DS_CT_WT_GTEMP t
11845: WHERE t.INVENTORY_ITEM_ID = C_INVENTORY_ITEM_ID /* THIS HAS INDEX */
11846: AND t.ORG_ID = C_ORG_ID
11847: AND msi.INVENTORY_ITEM_ID = t.INVENTORY_ITEM_ID
11848: AND msi.ORGANIZATION_ID = t.ORG_ID