APPS.GME_GANTT_PKG dependencies on GME_MATERIAL_DETAILS

Line 185: ,gme_material_details m

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
188: AND m.organization_id = i.organization_id
189: AND m.inventory_item_id = i.inventory_item_id

Line 196: FROM gme_material_details

192:
193: CURSOR get_product_qty (p_batch_id NUMBER, p_inventory_item_id NUMBER)
194: IS
195: SELECT SUM (plan_qty), NVL (SUM (actual_qty), 0), dtl_um
196: FROM gme_material_details
197: WHERE batch_id = p_batch_id
198: AND line_type = 1
199: AND inventory_item_id = p_inventory_item_id
200: GROUP BY dtl_um;

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

Line 1291: # the GME_MATERIAL_DETAILS in Get_Batch_Properties

1287: END get_resources;
1288:
1289: /*======================================================================
1290: # Eddie Oumerretane 21-MAR-02 Bug # 2189705. Retrieve the UOM from
1291: # the GME_MATERIAL_DETAILS in Get_Batch_Properties
1292: #======================================================================*/
1293: PROCEDURE get_batch_properties (
1294: p_batch_id IN NUMBER
1295: ,x_batch_properties_str OUT NOCOPY VARCHAR2)