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.GME_POST_MIGRATION dependencies on GME_MATERIAL_DETAILS

Line 64: FROM gme_material_details_mig

60: ORDER BY batch_id;
61:
62: CURSOR Cur_get_materials(v_batch_id NUMBER) IS
63: SELECT *
64: FROM gme_material_details_mig
65: WHERE batch_id = v_batch_id
66: ORDER BY line_type, line_no;
67:
68: CURSOR Cur_item_mst(v_item_id NUMBER) IS

Line 315: INSERT INTO gme_material_details VALUES l_mtl_dtl_tbl(a);

311: l_mtl_dtl_tbl(i).revision := NULL;
312: END LOOP;
313:
314: FORALL a IN 1..l_mtl_dtl_tbl.count
315: INSERT INTO gme_material_details VALUES l_mtl_dtl_tbl(a);
316: IF (g_debug <= gme_debug.g_log_statement) THEN
317: gme_debug.put_line('After materials');
318: END IF;
319:

Line 529: UPDATE gme_material_details

525: SET move_order_header_id = l_batch_header.move_order_header_id
526: WHERE batch_id = l_batch_header.batch_id;
527:
528: FOR a IN 1..l_mtl_dtl_tbl.count LOOP
529: UPDATE gme_material_details
530: SET move_order_line_id = l_mtl_dtl_tbl(a).move_order_line_id,
531: material_requirement_date = l_mtl_dtl_tbl(a).material_requirement_date
532: WHERE material_detail_id = l_mtl_dtl_tbl(a).material_detail_id;
533: END LOOP;

Line 1246: FROM gme_material_details_mig m, gme_material_details d

1242: FUNCTION get_new_mat_id(p_old_mat_id IN NUMBER,
1243: p_new_batch_id IN NUMBER) RETURN NUMBER IS
1244: CURSOR Cur_get_mat IS
1245: SELECT d.material_detail_id
1246: FROM gme_material_details_mig m, gme_material_details d
1247: WHERE m.material_detail_id = p_old_mat_id
1248: AND d.batch_id = p_new_batch_id
1249: AND d.line_type = m.line_type
1250: AND d.line_no = m.line_no;

Line 1518: FROM gme_material_details d, gme_batch_mapping_mig m

1514: PROCEDURE create_phantom_links IS
1515: CURSOR Cur_get_phantoms IS
1516: SELECT d.material_detail_id new_ing_line_id, d.phantom_id old_phantom_id, d.inventory_item_id,
1517: m.plant_code, m.new_batch_no
1518: FROM gme_material_details d, gme_batch_mapping_mig m
1519: WHERE d.batch_id = m.new_batch_id
1520: AND d.line_type = -1
1521: AND d.phantom_id > 0
1522: AND d.phantom_id NOT IN (SELECT new_batch_id FROM gme_batch_mapping_mig);

Line 1531: FROM gme_material_details

1527: WHERE old_batch_id = v_batch_id;
1528:
1529: CURSOR Cur_new_phant_prod(v_batch_id NUMBER, v_inventory_item_id NUMBER) IS
1530: SELECT material_detail_id
1531: FROM gme_material_details
1532: WHERE batch_id = v_batch_id
1533: AND line_type = gme_common_pvt.g_line_type_prod
1534: AND inventory_item_id = v_inventory_item_id
1535: ORDER BY line_no;

Line 1565: UPDATE gme_material_details

1561: RAISE new_phant_prod_not_found;
1562: END IF;
1563: CLOSE Cur_new_phant_prod;
1564: /* Update Phantom ing */
1565: UPDATE gme_material_details
1566: SET phantom_id = l_new_phantom_id,
1567: phantom_line_id = l_new_prod_line_id
1568: WHERE material_detail_id = get_phantoms.new_ing_line_id;
1569: /* Update phantom batch hdr */

Line 1574: UPDATE gme_material_details

1570: UPDATE gme_batch_header
1571: SET parentline_id = get_phantoms.new_ing_line_id
1572: WHERE batch_id = l_new_phantom_id;
1573: /* Update phantom product */
1574: UPDATE gme_material_details
1575: SET phantom_line_id = get_phantoms.new_ing_line_id
1576: WHERE material_detail_id = l_new_prod_line_id;
1577: EXCEPTION
1578: WHEN new_phant_batch_not_found THEN

Line 1652: FROM gme_material_details d, gme_material_details_mig dm, gme_batch_mapping_mig hmap

1648: -- Bug 13706812 - Use old batch id to make use of index.
1649: -- Bug - Get the mismatching wip plan qty.
1650: CURSOR Cur_get_wip_plan(v_old_batch_id NUMBER, v_new_batch_id NUMBER) IS
1651: SELECT d.material_detail_id, dm.wip_plan_qty
1652: FROM gme_material_details d, gme_material_details_mig dm, gme_batch_mapping_mig hmap
1653: WHERE d.line_type = dm.line_type
1654: AND d.line_no = dm.line_no
1655: AND d.item_id = dm.item_id
1656: AND d.batch_id = hmap.new_batch_id

Line 1666: FROM gme_material_details

1662: CURSOR Cur_verify_phantoms(v_batch_id NUMBER) IS
1663: SELECT 1
1664: FROM DUAL
1665: WHERE EXISTS (SELECT batch_id
1666: FROM gme_material_details
1667: WHERE batch_id = v_batch_id
1668: AND phantom_type > 0
1669: AND phantom_id NOT IN (SELECT new_batch_id FROM gme_batch_mapping_mig));
1670:

Line 1754: UPDATE gme_material_details

1750:
1751: -- Bug 12609227 - Get the mismatching wip plan qty.
1752: FOR get_wip_plan IN Cur_get_wip_plan(get_wip_batches.old_batch_id, l_batch_header.batch_id) LOOP
1753: BEGIN
1754: UPDATE gme_material_details
1755: SET wip_plan_qty = get_wip_plan.wip_plan_qty
1756: WHERE material_detail_id = get_wip_plan.material_detail_id;
1757: END;
1758: END LOOP;

Line 2237: FROM gme_material_details d, mtl_system_items_b i

2233: CURSOR Cur_mtl_dtl(v_material_detail_id NUMBER) IS
2234: SELECT d.*, i.mtl_transactions_enabled_flag, i.reservable_type, i.segment1, i.lot_control_code,
2235: i.revision_qty_control_code, i.primary_uom_code, i.secondary_uom_code, i.restrict_subinventories_code,
2236: NVL(i.location_control_code,1) location_control_code, i.restrict_locators_code, i.segment1 item_no
2237: FROM gme_material_details d, mtl_system_items_b i
2238: WHERE d.material_detail_id = v_material_detail_id
2239: AND i.organization_id = d.organization_id
2240: AND i.inventory_item_id = d.inventory_item_id;
2241: CURSOR Cur_lot_mst(v_lot_id NUMBER) IS

Line 2250: l_mtl_dtl_rec gme_material_details%ROWTYPE;

2246: l_batch_hdr gme_batch_header%ROWTYPE;
2247: l_mtl_rec Cur_mtl_dtl%ROWTYPE;
2248: l_mmti_rec mtl_transactions_interface%ROWTYPE;
2249: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
2250: l_mtl_dtl_rec gme_material_details%ROWTYPE;
2251: l_plot_out_rec gme_pending_product_lots%ROWTYPE;
2252: l_plot_in_rec gme_pending_product_lots%ROWTYPE;
2253: l_mmt_rec mtl_material_transactions%ROWTYPE;
2254: l_mmln_rec gme_common_pvt.mtl_trans_lots_num_tbl;

Line 3878: FROM gme_batch_step_items bsi, gme_material_details gmdn,

3874: AND s.step_status = gme_common_pvt.g_step_completed
3875: ORDER BY s.batch_id, s.batchstep_no;
3876: CURSOR Cur_verify_txns(v_batchstep_id NUMBER, v_old_batch_id NUMBER) IS
3877: SELECT 1
3878: FROM gme_batch_step_items bsi, gme_material_details gmdn,
3879: gme_material_details gmdo, gme_batch_txns_mig txn, ic_tran_pnd itp
3880: WHERE bsi.batchstep_id = v_batchstep_id
3881: AND gmdn.material_detail_id = bsi.material_detail_id
3882: AND gmdo.batch_id = v_old_batch_id

Line 3879: gme_material_details gmdo, gme_batch_txns_mig txn, ic_tran_pnd itp

3875: ORDER BY s.batch_id, s.batchstep_no;
3876: CURSOR Cur_verify_txns(v_batchstep_id NUMBER, v_old_batch_id NUMBER) IS
3877: SELECT 1
3878: FROM gme_batch_step_items bsi, gme_material_details gmdn,
3879: gme_material_details gmdo, gme_batch_txns_mig txn, ic_tran_pnd itp
3880: WHERE bsi.batchstep_id = v_batchstep_id
3881: AND gmdn.material_detail_id = bsi.material_detail_id
3882: AND gmdo.batch_id = v_old_batch_id
3883: AND gmdo.line_type = gmdn.line_type

Line 3979: FROM gme_material_details d

3975: WHERE i.organization_id = v_organization_id
3976: AND i.inventory_item_id = v_inventory_item_id;
3977: CURSOR Cur_mtl_dtl(v_material_detail_id NUMBER) IS
3978: SELECT d.*
3979: FROM gme_material_details d
3980: WHERE d.material_detail_id = v_material_detail_id;
3981: l_curr_batch_id NUMBER;
3982: l_curr_detail_id NUMBER;
3983: l_mat_detail_id NUMBER;

Line 3994: l_mtl_rec gme_material_details%ROWTYPE;

3990: l_new_data VARCHAR2(500);
3991: l_msg_data VARCHAR2(2000);
3992: l_item_rec Cur_item_dtl%ROWTYPE;
3993: l_batch_hdr gme_batch_header%ROWTYPE;
3994: l_mtl_rec gme_material_details%ROWTYPE;
3995: l_plot_out_rec gme_pending_product_lots%ROWTYPE;
3996: l_plot_in_rec gme_pending_product_lots%ROWTYPE;
3997: batch_fetch_err EXCEPTION;
3998: create_pp_lot_err EXCEPTION;