344: END IF;
345:
346: IF (material_org_count <> 1) THEN
347: SELECT COUNT(1) INTO material_org_count
348: FROM mtl_demand
349: WHERE inventory_item_id = p_item_id
350: AND organization_id = p_org_id
351: AND rownum = 1;
352:
350: AND organization_id = p_org_id
351: AND rownum = 1;
352:
353: --bug 7155924(7327865,7327866): setting lot-serial flag to be 1 in case
354: --rows exist in mtl_demand
355: IF(material_org_count = 1) THEN
356: material_org_count_ls := 1;
357: END IF;
358: END IF;
402:
403: --Check for pending transactions such as a booked order
404: IF (material_master_count <> 1) THEN
405: SELECT COUNT(1) INTO material_master_count
406: FROM mtl_demand md
407: WHERE md.inventory_item_id = p_item_id
408: AND EXISTS (SELECT 1
409: FROM mtl_parameters
410: WHERE master_organization_id = p_master_org
411: AND organization_id = md.organization_id)
412: AND rownum = 1;
413:
414: --bug 7155924(7327865,7327866): setting lot-serial flag
415: --to be 1 in case rows exist in mtl_demand
416: IF (material_master_count = 1) THEN
417: material_master_count_ls := 1;
418: END IF;
419: