APPS.GME_GANTT_PKG dependencies on GME_MATERIAL_DETAILS

Line 228: ,gme_material_details m

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

Line 239: FROM gme_material_details

235:
236: CURSOR get_product_qty (p_batch_id NUMBER, p_inventory_item_id NUMBER)
237: IS
238: SELECT SUM (plan_qty), NVL (SUM (actual_qty), 0), dtl_um
239: FROM gme_material_details
240: WHERE batch_id = p_batch_id
241: AND line_type = 1
242: AND inventory_item_id = p_inventory_item_id
243: GROUP BY dtl_um;

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

Line 1781: # the GME_MATERIAL_DETAILS in Get_Batch_Properties

1777: END get_resources;
1778:
1779: /*======================================================================
1780: # Eddie Oumerretane 21-MAR-02 Bug # 2189705. Retrieve the UOM from
1781: # the GME_MATERIAL_DETAILS in Get_Batch_Properties
1782: #======================================================================*/
1783: PROCEDURE get_batch_properties (
1784: p_batch_id IN NUMBER
1785: ,x_batch_properties_str OUT NOCOPY VARCHAR2)