APPS.INV_LOC_WMS_UTILS dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 2550: FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ,

2546: --TO_NUMBER(NULL) lpn_id,
2547: --moq.lpn_id lpn_id,
2548: wlpn.outermost_lpn_id lpn_id,
2549: TO_NUMBER(NULL) transaction_status
2550: FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ,
2551: mtl_item_locations mil,
2552: wms_license_plate_numbers wlpn
2553: WHERE moq.locator_id = mil.inventory_location_id
2554: AND mil.organization_id = moq.organization_id

Line 7146: FROM MTL_ONHAND_QUANTITIES_DETAIL

7142: IS
7143: cursor item_cnt
7144: is
7145: SELECT inventory_item_id
7146: FROM MTL_ONHAND_QUANTITIES_DETAIL
7147: WHERE LOCATOR_ID = p_locator_id
7148: and organization_id =p_org_id
7149: and inventory_item_id <> p_inventory_item_id
7150: and rownum <3

Line 7212: FROM MTL_ONHAND_QUANTITIES_DETAIL

7208: SELECT 1
7209: INTO l_chk_flag
7210: FROM dual
7211: WHERE EXISTS (SELECT 1
7212: FROM MTL_ONHAND_QUANTITIES_DETAIL
7213: WHERE LOCATOR_ID = P_LOCATOR_ID
7214: AND ORGANIZATION_ID = P_ORG_ID
7215: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
7216: );

Line 7225: FROM MTL_ONHAND_QUANTITIES_DETAIL

7221: SELECT 1
7222: INTO l_chk_flag
7223: FROM dual
7224: WHERE EXISTS (SELECT 1
7225: FROM MTL_ONHAND_QUANTITIES_DETAIL
7226: WHERE LOCATOR_ID = P_LOCATOR_ID
7227: AND ORGANIZATION_ID = P_ORG_ID
7228: AND INVENTORY_ITEM_ID <> P_INVENTORY_ITEM_ID
7229: );

Line 7330: FROM MTL_ONHAND_QUANTITIES_DETAIL

7326: FROM dual
7327: WHERE EXISTS (
7328: -- Onhand
7329: SELECT 1
7330: FROM MTL_ONHAND_QUANTITIES_DETAIL
7331: WHERE LOCATOR_ID = P_LOCATOR_ID
7332: AND ORGANIZATION_ID = P_ORG_ID
7333: AND INVENTORY_ITEM_ID <> P_INVENTORY_ITEM_ID
7334: AND SUBINVENTORY_CODE = l_subinventory_code --Added 3237709

Line 7894: FROM MTL_ONHAND_QUANTITIES_DETAIL

7890: END IF;
7891: begin
7892: SELECT sum(abs(primary_transaction_quantity))
7893: into l_units
7894: FROM MTL_ONHAND_QUANTITIES_DETAIL
7895: WHERE locator_id = l_inventory_location_id
7896: AND containerized_flag = 1
7897: AND locator_id >0
7898: AND organization_id =p_organization_id;

Line 7960: FROM MTL_ONHAND_QUANTITIES_DETAIL

7956: END IF;
7957: begin
7958: SELECT sum(abs(primary_transaction_quantity))
7959: into l_units
7960: FROM MTL_ONHAND_QUANTITIES_DETAIL
7961: WHERE locator_id = l_inventory_location_id
7962: AND containerized_flag = 1
7963: AND locator_id >0
7964: AND organization_id =p_organization_id;