APPS.GME_MOVE_ORDERS_PVT dependencies on GME_MATERIAL_DETAILS

Line 868: from gme_material_details

864: process_mo_line_err EXCEPTION;
865: /*Bug#6446877 Cursor to fetch the allocation uom for the line */
866: CURSOR get_line_uom IS
867: select dtl_um, inventory_item_id, organization_id
868: from gme_material_details
869: where material_detail_id = p_material_detail_id;
870: l_line_uom VARCHAR2(4);
871: BEGIN
872: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1205: p_mtl_dtl_rec IN gme_material_details%ROWTYPE

1201: RETURN FALSE;
1202: END pending_move_orders_exist;
1203:
1204: PROCEDURE get_pending_move_order_qty (
1205: p_mtl_dtl_rec IN gme_material_details%ROWTYPE
1206: ,x_pending_qty OUT NOCOPY NUMBER
1207: ,x_return_status OUT NOCOPY VARCHAR2)
1208: IS
1209: l_api_name CONSTANT VARCHAR2 (30) := 'get_pending_move_order_qty';

Line 1327: FROM gme_batch_header h, gme_material_details d

1323: CURSOR cur_batch_lines
1324: IS
1325: SELECT h.batch_id, h.move_order_header_id, d.material_detail_id
1326: ,d.move_order_line_id
1327: FROM gme_batch_header h, gme_material_details d
1328: WHERE h.organization_id = p_organization_id
1329: AND h.batch_id = p_batch_id
1330: AND d.batch_id = h.batch_id
1331: AND d.line_type = gme_common_pvt.g_line_type_ing;