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 GME_PENDING_PRODUCT_LOTS

Line 346: FROM gme_pending_product_lots

342:
343: -- Bug# 3927768 Kapil M
344: CURSOR Cur_get_lab_material (p_lot_id NUMBER) IS
345: SELECT quantity
346: FROM gme_pending_product_lots
347: WHERE batch_id = P_batch_id
348: AND pending_product_lot_id = p_lot_id;
349:
350: -- Bug# 3927768 Kapil M

Line 353: FROM gme_pending_product_lots e

349:
350: -- Bug# 3927768 Kapil M
351: CURSOR Cur_get_del_lines (V_material_detail_id NUMBER) IS
352: SELECT material_detail_id, pending_product_lot_id
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

Line 364: FROM gme_pending_product_lots

360: AND line_type = 3);
361:
362: CURSOR Cur_get_product_lot (V_material_detail_id NUMBER) IS
363: SELECT pending_product_lot_id
364: FROM gme_pending_product_lots
365: WHERE batch_id = P_batch_id
366: AND material_detail_id = V_material_detail_id;
367:
368: CURSOR Cur_get_text IS

Line 384: l_pending_in_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;

380: l_material_out GME_MATERIAL_DETAILS%ROWTYPE;
381: l_material_rec GME_MATERIAL_DETAILS%ROWTYPE;
382: x_def_tran_row GME_INVENTORY_TXNS_GTMP%ROWTYPE;
383: x_material_row GME_MATERIAL_DETAILS%ROWTYPE;
384: l_pending_in_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
385: l_pending_out_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
386: l_labrec Cur_get_lablot%ROWTYPE;
387: type text_table is table of NUMBER(10) index by binary_integer;
388: x_text_tab text_table;

Line 385: l_pending_out_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;

381: l_material_rec GME_MATERIAL_DETAILS%ROWTYPE;
382: x_def_tran_row GME_INVENTORY_TXNS_GTMP%ROWTYPE;
383: x_material_row GME_MATERIAL_DETAILS%ROWTYPE;
384: l_pending_in_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
385: l_pending_out_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
386: l_labrec Cur_get_lablot%ROWTYPE;
387: type text_table is table of NUMBER(10) index by binary_integer;
388: x_text_tab text_table;
389: x_cnt NUMBER default 0;