eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SPREADSHEET_UPDATE dependencies on GMD_MATERIAL_DETAILS_GTMP

Line 109: FROM gmd_material_details_gtmp

105: WHERE formula_id = P_formula_id;
106:
107: CURSOR Cur_get_dtl IS
108: SELECT formulaline_id, last_update_date
109: FROM gmd_material_details_gtmp
110: WHERE line_type <> 3
111: ORDER BY line_type, line_no;
112: l_last_update_date DATE;
113: l_return_status VARCHAR2(10);

Line 253: FROM gmd_material_details_gtmp

249: WHERE batch_id = P_batch_id;
250:
251: CURSOR Cur_get_dtl IS
252: SELECT material_detail_id, last_update_date
253: FROM gmd_material_details_gtmp
254: WHERE line_type <> 3
255: ORDER BY line_type, line_no;
256: l_last_update_date DATE;
257: l_return_status VARCHAR2(10);

Line 319: FROM gmd_material_details_gtmp g

315: FROM gme_material_details e
316: WHERE batch_id = P_batch_id
317: AND line_type <> 1
318: AND NOT EXISTS (SELECT 1
319: FROM gmd_material_details_gtmp g
320: WHERE line_type <> 3
321: AND g.material_detail_id = e.material_detail_id);
322:
323: CURSOR Cur_get_material IS

Line 325: FROM gmd_material_details_gtmp

321: AND g.material_detail_id = e.material_detail_id);
322:
323: CURSOR Cur_get_material IS
324: SELECT *
325: FROM gmd_material_details_gtmp
326: WHERE line_type <> 3
327: ORDER BY line_type, line_no;
328:
329: CURSOR Cur_get_detail_id(V_material_detail_id NUMBER) IS

Line 339: FROM gmd_material_details_gtmp

335: -- Bug# 3927768 Kapil M
336: -- Changed the below three cursors
337: CURSOR Cur_get_lablot (V_material_detail_id NUMBER ) IS
338: SELECT *
339: FROM gmd_material_details_gtmp
340: WHERE line_type = 3
341: AND material_detail_id = V_material_detail_id;
342:
343: -- Bug# 3927768 Kapil M

Line 357: FROM gmd_material_details_gtmp g

353: FROM gme_pending_product_lots e
354: WHERE batch_id = P_batch_id
355: AND material_detail_id = V_material_detail_id
356: AND NOT EXISTS (SELECT 1
357: FROM gmd_material_details_gtmp g
358: WHERE parent_line_id = V_material_detail_id
359: AND g.trans_id = e.pending_product_lot_id
360: AND line_type = 3);
361:

Line 370: FROM gmd_material_details_gtmp

366: AND material_detail_id = V_material_detail_id;
367:
368: CURSOR Cur_get_text IS
369: SELECT material_detail_id,text_code,orginal_text_code
370: FROM gmd_material_details_gtmp
371: WHERE text_code <> NVL(orginal_text_code,0);
372:
373: l_batch_row GME_BATCH_HEADER%ROWTYPE;
374: l_batch_rec GME_BATCH_HEADER%ROWTYPE;

Line 495: UPDATE gmd_material_details_gtmp

491: gmd_debug.put_line(' Insert material line error: Item:'||l_material_detail.inventory_item_id);
492: RAISE insert_line_err;
493: ELSE
494: l_matl_rec.material_detail_id := l_material_out.material_detail_id;
495: UPDATE gmd_material_details_gtmp
496: SET material_detail_id = l_matl_rec.material_detail_id,
497: parent_line_id = l_matl_rec.material_detail_id
498: WHERE parent_line_id = l_matl_rec.parent_line_id;
499: END IF;

Line 540: -- Those lots which are not found in gmd_material_details_gtmp should be deleted.

536: l_batch_rec.batch_id := P_batch_id;
537: l_material_rec.material_detail_id := l_matl_rec.material_detail_id;
538: FOR l_del_rec IN Cur_get_del_lines (l_matl_rec.material_detail_id) LOOP
539: -- Bug# 3927768 Kapil M
540: -- Those lots which are not found in gmd_material_details_gtmp should be deleted.
541: l_pending_in_rec.pending_product_lot_id := l_del_rec.pending_product_lot_id;
542:
543: gme_api_pub.delete_pending_product_lot (p_api_version => 2.0,
544: x_message_count => l_message_count,

Line 638: update gmd_material_details_gtmp a

634: GMA_EDITTEXT_PKG.Delete_Text(l_rec.orginal_text_code,'GME_TEXT_TABLE_TL');
635: END IF;
636: END LOOP;
637:
638: update gmd_material_details_gtmp a
639: set last_update_date = (select last_update_date
640: FROM gme_material_details
641: WHERE material_detail_id = a.material_detail_id);
642: EXCEPTION

Line 678: FROM gmd_material_details_gtmp g

674: WHERE demand_source_header_id = P_batch_id
675: AND demand_source_line_id = V_material_detail_id
676: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
677: AND NOT EXISTS (SELECT 1
678: FROM gmd_material_details_gtmp g
679: WHERE parent_line_id = V_material_detail_id
680: AND line_type = 3
681: AND g.reservation_id = e.reservation_id);
682:

Line 685: FROM gmd_material_details_gtmp

681: AND g.reservation_id = e.reservation_id);
682:
683: CURSOR Cur_get_lines (V_material_detail_id NUMBER) IS
684: SELECT *
685: FROM gmd_material_details_gtmp
686: WHERE parent_line_id = V_material_detail_id
687: AND line_type = 3
688: AND transaction_id IS NULL
689: ORDER BY line_no desc;

Line 693: FROM gmd_material_details_gtmp

689: ORDER BY line_no desc;
690:
691: CURSOR Cur_get_line_revision (V_material_detail_id NUMBER) IS
692: SELECT revision,inventory_item_id
693: FROM gmd_material_details_gtmp
694: WHERE material_detail_id = V_material_detail_id;
695:
696: CURSOR Cur_get_rev_control (V_item_id NUMBER) IS
697: SELECT revision_qty_control_code

Line 721: FROM gmd_material_details_gtmp

717: WHERE material_detail_id = P_material_detail_id;
718:
719: CURSOR Cur_get_new_qty IS
720: SELECT qty,transaction_id,lot_number
721: FROM gmd_material_details_gtmp
722: WHERE material_detail_id = P_material_detail_id
723: AND lot_number IS NOT NULL;
724:
725: CURSOR Cur_get_old_qty (V_transaction_id NUMBER, V_lot_number VARCHAR2) IS