APPS.WMS_XDOCK_PEGGING_PUB dependencies on MTL_SYSTEM_ITEMS

Line 223: FROM mtl_system_items

219: IF (NOT g_item_routing_id_tb.EXISTS(p_item_id)) THEN
220: BEGIN
221: SELECT receiving_routing_id
222: INTO g_item_routing_id_tb(p_item_id)
223: FROM mtl_system_items
224: WHERE inventory_item_id = p_item_id
225: AND organization_id = p_organization_id;
226: EXCEPTION
227: WHEN NO_DATA_FOUND THEN

Line 2970: FROM mtl_system_items

2966: BEGIN
2967: SELECT primary_uom_code, NVL(reservable_type, 1),
2968: NVL(lot_control_code, 1), NVL(lot_divisible_flag, 'Y'), item_type
2969: INTO l_item_params_tb(l_inventory_item_id)
2970: FROM mtl_system_items
2971: WHERE inventory_item_id = l_inventory_item_id
2972: AND organization_id = l_organization_id;
2973: EXCEPTION
2974: WHEN OTHERS THEN

Line 6613: FROM mtl_txn_request_lines mtrl, mtl_system_items msi, wms_license_plate_numbers wlpn

6609: NVL(msi.reservable_type, 1) AS reservable_type,
6610: NVL(msi.lot_control_code, 1) AS lot_control_code,
6611: NVL(msi.lot_divisible_flag, 'Y') AS lot_divisible_flag,
6612: wlpn.lpn_context AS lpn_context
6613: FROM mtl_txn_request_lines mtrl, mtl_system_items msi, wms_license_plate_numbers wlpn
6614: WHERE mtrl.line_id = p_move_order_line_id
6615: AND mtrl.organization_id = l_organization_id
6616: -- Modified the line below to use an IN instead of <>
6617: -- AND mtrl.line_status <> inv_globals.g_to_status_closed