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 60: FROM gme_material_details_mig

56: AND organization_id IS NOT NULL
57: ORDER BY batch_id;
58: CURSOR Cur_get_materials(v_batch_id NUMBER) IS
59: SELECT *
60: FROM gme_material_details_mig
61: WHERE batch_id = v_batch_id
62: ORDER BY line_type, line_no;
63: CURSOR Cur_item_mst(v_item_id NUMBER) IS
64: SELECT item_no

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

230: l_mtl_dtl_tbl(i).revision := NULL;
231: END LOOP;
232:
233: FORALL a IN 1..l_mtl_dtl_tbl.count
234: INSERT INTO gme_material_details VALUES l_mtl_dtl_tbl(a);
235: IF (g_debug <= gme_debug.g_log_statement) THEN
236: gme_debug.put_line('After materials');
237: END IF;
238: /* Process batch step records */

Line 422: UPDATE gme_material_details

418: SET move_order_header_id = l_batch_header.move_order_header_id
419: WHERE batch_id = l_batch_header.batch_id;
420:
421: FOR a IN 1..l_mtl_dtl_tbl.count LOOP
422: UPDATE gme_material_details
423: SET move_order_line_id = l_mtl_dtl_tbl(a).move_order_line_id,
424: material_requirement_date = l_mtl_dtl_tbl(a).material_requirement_date
425: WHERE material_detail_id = l_mtl_dtl_tbl(a).material_detail_id;
426: END LOOP;

Line 1116: FROM gme_material_details_mig m, gme_material_details d

1112: FUNCTION get_new_mat_id(p_old_mat_id IN NUMBER,
1113: p_new_batch_id IN NUMBER) RETURN NUMBER IS
1114: CURSOR Cur_get_mat IS
1115: SELECT d.material_detail_id
1116: FROM gme_material_details_mig m, gme_material_details d
1117: WHERE m.material_detail_id = p_old_mat_id
1118: AND d.batch_id = p_new_batch_id
1119: AND d.line_type = m.line_type
1120: AND d.line_no = m.line_no;

Line 1387: FROM gme_material_details d, gme_batch_mapping_mig m

1383: PROCEDURE create_phantom_links IS
1384: CURSOR Cur_get_phantoms IS
1385: SELECT d.material_detail_id new_ing_line_id, d.phantom_id old_phantom_id, d.inventory_item_id,
1386: m.plant_code, m.new_batch_no
1387: FROM gme_material_details d, gme_batch_mapping_mig m
1388: WHERE d.batch_id = m.new_batch_id
1389: AND d.line_type = -1
1390: AND d.phantom_id > 0
1391: AND d.phantom_id NOT IN (SELECT new_batch_id FROM gme_batch_mapping_mig);

Line 1398: FROM gme_material_details

1394: FROM gme_batch_mapping_mig
1395: WHERE old_batch_id = v_batch_id;
1396: CURSOR Cur_new_phant_prod(v_batch_id NUMBER, v_inventory_item_id NUMBER) IS
1397: SELECT material_detail_id
1398: FROM gme_material_details
1399: WHERE batch_id = v_batch_id
1400: AND line_type = gme_common_pvt.g_line_type_prod
1401: AND inventory_item_id = v_inventory_item_id
1402: ORDER BY line_no;

Line 1431: UPDATE gme_material_details

1427: RAISE new_phant_prod_not_found;
1428: END IF;
1429: CLOSE Cur_new_phant_prod;
1430: /* Update Phantom ing */
1431: UPDATE gme_material_details
1432: SET phantom_id = l_new_phantom_id,
1433: phantom_line_id = l_new_prod_line_id
1434: WHERE material_detail_id = get_phantoms.new_ing_line_id;
1435: /* Update phantom batch hdr */

Line 1440: UPDATE gme_material_details

1436: UPDATE gme_batch_header
1437: SET parentline_id = get_phantoms.new_ing_line_id
1438: WHERE batch_id = l_new_phantom_id;
1439: /* Update phantom product */
1440: UPDATE gme_material_details
1441: SET phantom_line_id = get_phantoms.new_ing_line_id
1442: WHERE material_detail_id = l_new_prod_line_id;
1443: EXCEPTION
1444: WHEN new_phant_batch_not_found THEN

Line 1516: FROM gme_material_details

1512: CURSOR Cur_verify_phantoms(v_batch_id NUMBER) IS
1513: SELECT 1
1514: FROM DUAL
1515: WHERE EXISTS (SELECT batch_id
1516: FROM gme_material_details
1517: WHERE batch_id = v_batch_id
1518: AND phantom_type > 0
1519: AND phantom_id NOT IN (SELECT new_batch_id FROM gme_batch_mapping_mig));
1520: l_date DATE;

Line 2020: FROM gme_material_details d, mtl_system_items_b i

2016: CURSOR Cur_mtl_dtl(v_material_detail_id NUMBER) IS
2017: SELECT d.*, i.mtl_transactions_enabled_flag, i.reservable_type, i.segment1, i.lot_control_code,
2018: i.revision_qty_control_code, i.primary_uom_code, i.secondary_uom_code, i.restrict_subinventories_code,
2019: NVL(i.location_control_code,1) location_control_code, i.restrict_locators_code, i.segment1 item_no
2020: FROM gme_material_details d, mtl_system_items_b i
2021: WHERE d.material_detail_id = v_material_detail_id
2022: AND i.organization_id = d.organization_id
2023: AND i.inventory_item_id = d.inventory_item_id;
2024: CURSOR Cur_lot_mst(v_lot_id NUMBER) IS

Line 2032: l_mtl_dtl_rec gme_material_details%ROWTYPE;

2028: l_batch_hdr gme_batch_header%ROWTYPE;
2029: l_mtl_rec Cur_mtl_dtl%ROWTYPE;
2030: l_mmti_rec mtl_transactions_interface%ROWTYPE;
2031: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
2032: l_mtl_dtl_rec gme_material_details%ROWTYPE;
2033: l_plot_out_rec gme_pending_product_lots%ROWTYPE;
2034: l_plot_in_rec gme_pending_product_lots%ROWTYPE;
2035: l_mmt_rec mtl_material_transactions%ROWTYPE;
2036: l_mmln_rec gme_common_pvt.mtl_trans_lots_num_tbl;

Line 3328: FROM gme_batch_step_items bsi, gme_material_details gmdn,

3324: AND s.step_status = gme_common_pvt.g_step_completed
3325: ORDER BY s.batch_id, s.batchstep_no;
3326: CURSOR Cur_verify_txns(v_batchstep_id NUMBER, v_old_batch_id NUMBER) IS
3327: SELECT 1
3328: FROM gme_batch_step_items bsi, gme_material_details gmdn,
3329: gme_material_details gmdo, gme_batch_txns_mig txn, ic_tran_pnd itp
3330: WHERE bsi.batchstep_id = v_batchstep_id
3331: AND gmdn.material_detail_id = bsi.material_detail_id
3332: AND gmdo.batch_id = v_old_batch_id

Line 3329: gme_material_details gmdo, gme_batch_txns_mig txn, ic_tran_pnd itp

3325: ORDER BY s.batch_id, s.batchstep_no;
3326: CURSOR Cur_verify_txns(v_batchstep_id NUMBER, v_old_batch_id NUMBER) IS
3327: SELECT 1
3328: FROM gme_batch_step_items bsi, gme_material_details gmdn,
3329: gme_material_details gmdo, gme_batch_txns_mig txn, ic_tran_pnd itp
3330: WHERE bsi.batchstep_id = v_batchstep_id
3331: AND gmdn.material_detail_id = bsi.material_detail_id
3332: AND gmdo.batch_id = v_old_batch_id
3333: AND gmdo.line_type = gmdn.line_type

Line 3429: FROM gme_material_details d

3425: WHERE i.organization_id = v_organization_id
3426: AND i.inventory_item_id = v_inventory_item_id;
3427: CURSOR Cur_mtl_dtl(v_material_detail_id NUMBER) IS
3428: SELECT d.*
3429: FROM gme_material_details d
3430: WHERE d.material_detail_id = v_material_detail_id;
3431: l_curr_batch_id NUMBER;
3432: l_curr_detail_id NUMBER;
3433: l_mat_detail_id NUMBER;

Line 3444: l_mtl_rec gme_material_details%ROWTYPE;

3440: l_new_data VARCHAR2(500);
3441: l_msg_data VARCHAR2(2000);
3442: l_item_rec Cur_item_dtl%ROWTYPE;
3443: l_batch_hdr gme_batch_header%ROWTYPE;
3444: l_mtl_rec gme_material_details%ROWTYPE;
3445: l_plot_out_rec gme_pending_product_lots%ROWTYPE;
3446: l_plot_in_rec gme_pending_product_lots%ROWTYPE;
3447: batch_fetch_err EXCEPTION;
3448: create_pp_lot_err EXCEPTION;