2631: ,mil2.volume_uom_code
2632: ,mil2.location_maximum_units
2633: ,mil2.max_weight
2634: ,mil2.max_cubic_area
2635: FROM mtl_onhand_quantities_detail moq
2636: ,mtl_item_locations mil
2637: ,mtl_item_locations mil2
2638: ,wms_license_plate_numbers wlpn
2639: WHERE moq.locator_id = mil.inventory_location_id
7662: IS
7663: cursor item_cnt
7664: is
7665: SELECT inventory_item_id
7666: FROM MTL_ONHAND_QUANTITIES_DETAIL
7667: WHERE LOCATOR_ID = p_locator_id
7668: and organization_id =p_org_id
7669: and inventory_item_id <> p_inventory_item_id
7670: and rownum <3
7728: SELECT 1
7729: INTO l_chk_flag
7730: FROM dual
7731: WHERE EXISTS (SELECT 1
7732: FROM MTL_ONHAND_QUANTITIES_DETAIL
7733: WHERE LOCATOR_ID = P_LOCATOR_ID
7734: AND ORGANIZATION_ID = P_ORG_ID
7735: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
7736: );
7741: SELECT 1
7742: INTO l_chk_flag
7743: FROM dual
7744: WHERE EXISTS (SELECT 1
7745: FROM MTL_ONHAND_QUANTITIES_DETAIL
7746: WHERE LOCATOR_ID = P_LOCATOR_ID
7747: AND ORGANIZATION_ID = P_ORG_ID
7748: AND INVENTORY_ITEM_ID <> P_INVENTORY_ITEM_ID
7749: );
7846: FROM dual
7847: WHERE EXISTS (
7848: -- Onhand
7849: SELECT 1
7850: FROM MTL_ONHAND_QUANTITIES_DETAIL
7851: WHERE LOCATOR_ID = P_LOCATOR_ID
7852: AND ORGANIZATION_ID = P_ORG_ID
7853: AND INVENTORY_ITEM_ID <> P_INVENTORY_ITEM_ID
7854: AND SUBINVENTORY_CODE = l_subinventory_code --Added 3237709
8410: END IF;
8411: begin
8412: SELECT sum(abs(primary_transaction_quantity))
8413: into l_units
8414: FROM MTL_ONHAND_QUANTITIES_DETAIL
8415: WHERE locator_id = l_inventory_location_id
8416: AND containerized_flag = 1
8417: AND locator_id >0
8418: AND organization_id =p_organization_id;
8476: END IF;
8477: begin
8478: SELECT sum(abs(primary_transaction_quantity))
8479: into l_units
8480: FROM MTL_ONHAND_QUANTITIES_DETAIL
8481: WHERE locator_id = l_inventory_location_id
8482: AND containerized_flag = 1
8483: AND locator_id >0
8484: AND organization_id =p_organization_id;
8770: IF p_content_lpn_id IS NOT NULL THEN
8771: BEGIN
8772: SELECT 1
8773: INTO l_onhand_for_others
8774: FROM mtl_onhand_quantities_detail
8775: WHERE locator_id = p_locator_id
8776: AND organization_id = p_organization_id
8777: AND (
8778: lpn_id <> p_content_lpn_id
8802: ||p_locator_id , 'get_source_type', 4);
8803: IF (p_inventory_item_id > 0) THEN
8804: SELECT 1 --COUNT(DISTINCT inventory_item_id) fixing bug 14489644
8805: INTO l_item_count
8806: FROM mtl_onhand_quantities_detail
8807: WHERE locator_id = p_locator_id
8808: AND organization_id = p_organization_id
8809: AND inventory_item_id <> p_inventory_item_id
8810: AND (p_content_lpn_id IS NULL OR (p_content_lpn_id IS NOT NULL AND lpn_id <> p_content_lpn_id)) -- Bug 12682322
8824: ELSE
8825: BEGIN
8826: SELECT SUM(primary_transaction_quantity)
8827: INTO l_onhand_qty_for_item
8828: FROM mtl_onhand_quantities_detail
8829: WHERE locator_id = p_locator_id
8830: AND organization_id = p_organization_id
8831: AND inventory_item_id = p_inventory_item_id;
8832: