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.INVIDIT3 dependencies on MTL_DEMAND

Line 362: FROM mtl_demand

358: END IF;
359:
360: IF (material_org_count <> 1) THEN
361: SELECT COUNT(1) INTO material_org_count
362: FROM mtl_demand
363: WHERE inventory_item_id = p_item_id
364: AND organization_id = p_org_id
365: AND rownum = 1;
366:

Line 368: --rows exist in mtl_demand

364: AND organization_id = p_org_id
365: AND rownum = 1;
366:
367: --bug 7155924(7327865,7327866): setting lot-serial flag to be 1 in case
368: --rows exist in mtl_demand
369: IF(material_org_count = 1) THEN
370: material_org_count_ls := 1;
371: END IF;
372: END IF;

Line 420: FROM mtl_demand md

416:
417: --Check for pending transactions such as a booked order
418: IF (material_master_count <> 1) THEN
419: SELECT COUNT(1) INTO material_master_count
420: FROM mtl_demand md
421: WHERE md.inventory_item_id = p_item_id
422: AND EXISTS (SELECT 1
423: FROM mtl_parameters
424: WHERE master_organization_id = p_master_org

Line 429: --to be 1 in case rows exist in mtl_demand

425: AND organization_id = md.organization_id)
426: AND rownum = 1;
427:
428: --bug 7155924(7327865,7327866): setting lot-serial flag
429: --to be 1 in case rows exist in mtl_demand
430: IF (material_master_count = 1) THEN
431: material_master_count_ls := 1;
432: END IF;
433: