DBA Data[Home] [Help]

APPS.GME_GANTT_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 172: FROM mtl_system_items_kfv i

168: multiple procedures */
169: CURSOR get_product_info (p_batch_id NUMBER)
170: IS
171: SELECT i.inventory_item_id, i.concatenated_segments, i.description
172: FROM mtl_system_items_kfv i
173: ,gme_batch_header b
174: ,gmd_recipe_validity_rules v
175: WHERE b.batch_id = p_batch_id
176: AND b.recipe_validity_rule_id = v.recipe_validity_rule_id

Line 183: FROM mtl_system_items_kfv i

179: /* This cursor is defined for the LCF batch */
180: CURSOR get_product_info_lcf (p_batch_id NUMBER)
181: IS
182: SELECT i.inventory_item_id, i.concatenated_segments, i.description
183: FROM mtl_system_items_kfv i
184: ,gme_batch_header b
185: ,gme_material_details m
186: WHERE b.batch_id = p_batch_id
187: AND b.batch_id = m.batch_id

Line 367: FROM mtl_system_items_kfv i, gme_material_details m

363: IS
364: CURSOR get_ingredient
365: IS
366: SELECT COUNT (*)
367: FROM mtl_system_items_kfv i, gme_material_details m
368: WHERE m.batch_id = p_batch_id
369: AND m.inventory_item_id = i.inventory_item_id
370: AND m.line_type = -1
371: AND m.organization_id = i.organization_id

Line 377: FROM mtl_system_items_kfv i, gme_material_details m

373:
374: CURSOR get_product
375: IS
376: SELECT COUNT (*)
377: FROM mtl_system_items_kfv i, gme_material_details m
378: WHERE m.batch_id = p_batch_id
379: AND m.inventory_item_id = i.inventory_item_id
380: AND m.organization_id = i.organization_id
381: AND m.line_type = 1