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.GME_GANTT_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 215: FROM mtl_system_items_kfv i

211: multiple procedures */
212: CURSOR get_product_info (p_batch_id NUMBER)
213: IS
214: SELECT i.inventory_item_id, i.concatenated_segments, i.description
215: FROM mtl_system_items_kfv i
216: ,gme_batch_header b
217: ,gmd_recipe_validity_rules v
218: WHERE b.batch_id = p_batch_id
219: AND b.recipe_validity_rule_id = v.recipe_validity_rule_id

Line 226: FROM mtl_system_items_kfv i

222: /* This cursor is defined for the LCF batch */
223: CURSOR get_product_info_lcf (p_batch_id NUMBER)
224: IS
225: SELECT i.inventory_item_id, i.concatenated_segments, i.description
226: FROM mtl_system_items_kfv i
227: ,gme_batch_header b
228: ,gme_material_details m
229: WHERE b.batch_id = p_batch_id
230: AND b.batch_id = m.batch_id

Line 856: FROM mtl_system_items_kfv i, gme_material_details m

852: IS
853: CURSOR get_ingredient
854: IS
855: SELECT COUNT (*)
856: FROM mtl_system_items_kfv i, gme_material_details m
857: WHERE m.batch_id = p_batch_id
858: AND m.inventory_item_id = i.inventory_item_id
859: AND m.line_type = -1
860: AND m.organization_id = i.organization_id

Line 866: FROM mtl_system_items_kfv i, gme_material_details m

862:
863: CURSOR get_product
864: IS
865: SELECT COUNT (*)
866: FROM mtl_system_items_kfv i, gme_material_details m
867: WHERE m.batch_id = p_batch_id
868: AND m.inventory_item_id = i.inventory_item_id
869: AND m.organization_id = i.organization_id
870: AND m.line_type = 1