APPS.GME_MOVE_ORDERS_PVT dependencies on GME_MATERIAL_DETAILS

Line 790: from gme_material_details

786: process_mo_line_err EXCEPTION;
787: /*Bug#6446877 Cursor to fetch the allocation uom for the line */
788: CURSOR get_line_uom IS
789: select dtl_um
790: from gme_material_details
791: where material_detail_id = p_material_detail_id;
792: l_line_uom VARCHAR2(4);
793: BEGIN
794: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1008: p_mtl_dtl_rec IN gme_material_details%ROWTYPE

1004: RETURN FALSE;
1005: END pending_move_orders_exist;
1006:
1007: PROCEDURE get_pending_move_order_qty (
1008: p_mtl_dtl_rec IN gme_material_details%ROWTYPE
1009: ,x_pending_qty OUT NOCOPY NUMBER
1010: ,x_return_status OUT NOCOPY VARCHAR2)
1011: IS
1012: l_api_name CONSTANT VARCHAR2 (30) := 'get_pending_move_order_qty';

Line 1126: FROM gme_batch_header h, gme_material_details d

1122: CURSOR cur_batch_lines
1123: IS
1124: SELECT h.batch_id, h.move_order_header_id, d.material_detail_id
1125: ,d.move_order_line_id
1126: FROM gme_batch_header h, gme_material_details d
1127: WHERE h.organization_id = p_organization_id
1128: AND h.batch_id = p_batch_id
1129: AND d.batch_id = h.batch_id
1130: AND d.line_type = gme_common_pvt.g_line_type_ing;