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 224: ,mtl_system_items_kfv msi

220: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wt.ship_method_code)
221: ,wt.ship_method_code
222: FROM wsh_trips_ob_grp_v wt
223: ,wsh_trip_stops_ob_grp_v wts
224: ,mtl_system_items_kfv msi
225: WHERE wt.trip_id = p_trip_id
226: AND wt.trip_id = wts.trip_id
227: AND (wt.vehicle_item_id = msi.inventory_item_id(+)
228: AND msi.organization_id(+) = p_org_id)

Line 1138: ,mtl_system_items_kfv msik

1134: msik.description
1135: from wsh_delivery_details_ob_grp_v wdd
1136: ,wsh_delivery_assignments_v wda
1137: ,wsh_new_deliveries_ob_grp_v wnd
1138: ,mtl_system_items_kfv msik
1139: where wnd.delivery_id = p_delivery_id
1140: AND wnd.delivery_id = wda.delivery_id
1141: AND wda.delivery_detail_id = wdd.delivery_detail_id
1142: AND wdd.lpn_id is null

Line 3302: FROM mtl_system_items

3298: lot_divisible_flag
3299: INTO l_serial_ctrl_code,
3300: l_lot_ctrl_code,
3301: l_lot_divisible_flag
3302: FROM mtl_system_items
3303: WHERE inventory_item_id = l_item_id
3304: AND organization_id = p_org_id;
3305:
3306: IF (l_debug = 1) THEN

Line 5187: MTL_SYSTEM_ITEMS MSI

5183: ,l_delivery_detail_tab(i).LOT_CONTROL_CODE
5184: ,l_delivery_detail_tab(i).SERIAL_NUMBER_CONTROL_CODE
5185: FROM WMS_DIRECT_SHIP_TEMP WDS,
5186: WSH_DELIVERY_DETAILS WDD,
5187: MTL_SYSTEM_ITEMS MSI
5188: WHERE WDS.ORGANIZATION_ID = p_organization_id
5189: AND WDS.lpn_id = p_lpn_id
5190: AND WDS.ORDER_HEADER_ID = p_source_header_id
5191: AND WDS.ORDER_LINE_ID = p_source_line_id

Line 5235: , mtl_system_items msi

5231: , msi.serial_number_control_code
5232: FROM wms_direct_ship_temp wds
5233: , wms_license_plate_numbers wlpn
5234: , mtl_secondary_inventories sub
5235: , mtl_system_items msi
5236: WHERE wds.GROUP_ID = p_group_id
5237: AND wds.organization_id = p_organization_id
5238: AND wds.dock_door_id = p_dock_door_id
5239: AND wds.lpn_id = p_lpn_id

Line 5657: ' mtl_system_items msi ' ||

5653:
5654: l_sql_query := l_sql_query ||
5655: ' FROM wms_direct_ship_temp wds, ' ||
5656: ' wsh_delivery_details_ob_grp_v wdd, ' ||
5657: ' mtl_system_items msi ' ||
5658: ' WHERE wds.organization_id = :p_organization_id ' ||
5659: ' AND wds.lpn_id = :p_lpn_id ' ||
5660: ' AND wds.order_header_id = :p_order_header_id ' ||
5661: ' AND wds.order_line_id = :p_order_line_id ' ||

Line 7864: FROM mtl_system_items

7860: , serial_number_control_code
7861: INTO l_revision_control
7862: , l_lot_control
7863: , l_serial_control
7864: FROM mtl_system_items
7865: WHERE organization_id = p_organization_id
7866: AND inventory_item_id = p_inventory_item_id;
7867:
7868: IF (l_revision_control = 2) THEN

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

9001: x_return_status := fnd_api.g_ret_sts_success;
9002:
9003: SELECT COUNT(*)
9004: INTO l_count
9005: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, mtl_system_items_kfv msik
9006: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
9007: AND NVL(wdd.container_flag, 'N') = 'N'
9008: AND wda.delivery_id = p_delivery_id
9009: AND wdd.inventory_item_id = msik.inventory_item_id

Line 9369: , serial_control_code mtl_system_items_b.serial_number_control_code%TYPE

9365: , secondary_quantity wms_lpn_contents.secondary_quantity%TYPE
9366: , revision_control VARCHAR2(5)
9367: , lot_control VARCHAR2(5)
9368: , serial_control VARCHAR2(5)
9369: , serial_control_code mtl_system_items_b.serial_number_control_code%TYPE
9370: , reservable_type mtl_system_items_b.reservable_type%TYPE
9371: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
9372: , ont_pricing_qty_source VARCHAR2(30)
9373: );

Line 9370: , reservable_type mtl_system_items_b.reservable_type%TYPE

9366: , revision_control VARCHAR2(5)
9367: , lot_control VARCHAR2(5)
9368: , serial_control VARCHAR2(5)
9369: , serial_control_code mtl_system_items_b.serial_number_control_code%TYPE
9370: , reservable_type mtl_system_items_b.reservable_type%TYPE
9371: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
9372: , ont_pricing_qty_source VARCHAR2(30)
9373: );
9374: l_lpn_content_cur_rec l_lpn_content_cur_rec_typ;

Line 9508: ' , mtl_system_items_b msi ' ||

9504: ' , NULL ' ||
9505: ' , msi.ont_pricing_qty_source ' ||
9506: ' FROM wms_lpn_contents wlc ' ||
9507: ' , wms_license_plate_numbers wlpn ' ||
9508: ' , mtl_system_items_b msi ' ||
9509: ' WHERE msi.inventory_item_id = wlc.inventory_item_id ' ||
9510: ' AND wlpn.lpn_id = wlc.parent_lpn_id ' ||
9511: ' AND wlpn.outermost_lpn_id = :p_lpn_id ' ||
9512: ' AND wlpn.organization_id = :p_org_id ' ||

Line 9547: ' , mtl_system_items_b msi ' ||

9543: ' , msn.end_item_unit_number ' ||
9544: ' , msi.ont_pricing_qty_source ' ||
9545: ' FROM wms_lpn_contents wlc ' ||
9546: ' , wms_license_plate_numbers wlpn ' ||
9547: ' , mtl_system_items_b msi ' ||
9548: ' , (SELECT lpn_id ' ||
9549: ' , revision ' ||
9550: ' , lot_number ' ||
9551: ' , inventory_item_id ' ||

Line 9938: FROM oe_order_lines_all oel, mtl_system_items msi

9934: , msi.serial_number_control_code
9935: , oel.end_item_unit_number
9936: , oel.flow_status_code
9937: INTO l_order_line_rec
9938: FROM oe_order_lines_all oel, mtl_system_items msi
9939: WHERE msi.organization_id = p_org_id
9940: AND oel.inventory_item_id = msi.inventory_item_id
9941: AND line_id = l_mtl_reservation_tab(resv_index).demand_source_line_id;
9942: EXCEPTION

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

12483: , oel.end_item_unit_number
12484: , oel.request_date
12485: , msi.primary_uom_code
12486: , msi.secondary_uom_code
12487: FROM wms_direct_ship_temp wds, oe_order_lines_all oel, mtl_system_items_kfv msi
12488: WHERE wds.organization_id = p_org_id
12489: AND wds.GROUP_ID = g_group_id
12490: AND wds.dock_door_id = p_dock_door_id
12491: AND wds.lpn_id = p_lpn_id

Line 13833: , mtl_system_items msi

13829: AND wlpn.lpn_id = p_lpn_id
13830: AND EXISTS ( SELECT 'x'
13831: FROM wms_license_plate_numbers wlpn2
13832: , wms_lpn_contents wlc
13833: , mtl_system_items msi
13834: WHERE wlpn2.outermost_lpn_id = wlpn.outermost_lpn_id
13835: AND wlc.parent_lpn_id = wlpn2.lpn_id
13836: AND msi.inventory_item_id = wlc.inventory_item_id
13837: AND msi.organization_id = wlc.organization_id

Line 13890: FROM mtl_system_items msi, WMS_DS_CT_WT_GTEMP t

13886: t.PICKED_QUANTITY, t.PICKED_UOM_CODE, msi.primary_uom_code,
13887: NULL, NULL), 0)) PICKED_QUANTITY_IN_PRI_UOM
13888: ,t.SECONDARY_UOM_CODE
13889: ,t.SECONDARY_QUANTITY
13890: FROM mtl_system_items msi, WMS_DS_CT_WT_GTEMP t
13891: WHERE t.INVENTORY_ITEM_ID = C_INVENTORY_ITEM_ID /* THIS HAS INDEX */
13892: AND t.ORG_ID = C_ORG_ID
13893: AND msi.INVENTORY_ITEM_ID = t.INVENTORY_ITEM_ID
13894: AND msi.ORGANIZATION_ID = t.ORG_ID