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_CREATE_BATCH_PVT dependencies on MTL_SYSTEM_ITEMS

Line 184: l_item_master mtl_system_items_kfv%ROWTYPE;

180: l_in_batch_header gme_batch_header%ROWTYPE;
181: l_formula_master fm_form_mst%ROWTYPE;
182: l_formula_material fm_matl_dtl%ROWTYPE;
183: l_recipe_validity_rule gmd_recipe_validity_rules%ROWTYPE;
184: l_item_master mtl_system_items_kfv%ROWTYPE;
185: l_gme_material_detail gme_material_details%ROWTYPE;
186: l_text_header gme_text_header%ROWTYPE;
187: l_text_string gme_text_table.text%TYPE;
188: l_material_details gme_common_pvt.material_details_tab;

Line 259: l_new_item_rec mtl_system_items_kfv%ROWTYPE;

255: material_dtl_fetch_failure EXCEPTION;
256:
257: --FPBug#4351032
258: l_formula_tbl gmdfmval_pub.formula_detail_tbl;
259: l_new_item_rec mtl_system_items_kfv%ROWTYPE;
260: --5698727
261: l_in_batch_header1 gme_batch_header%ROWTYPE;
262: l_doc_timestamp VARCHAR2(50);
263: l_assignment_type NUMBER;

Line 299: FROM mtl_system_items_kfv

295: CURSOR item_master_cursor (v_inventory_item_id NUMBER, v_org_id NUMBER)
296: IS
297: SELECT inventory_item_id, concatenated_segments,
298: eng_item_flag, process_execution_enabled_flag
299: FROM mtl_system_items_kfv
300: WHERE inventory_item_id = v_inventory_item_id
301: AND organization_id = v_org_id;
302: -- pawan kumar added this cursor for bug 4917631
303: CURSOR item_master_cursor_sub (v_inventory_item_id NUMBER, v_org_id NUMBER)

Line 306: FROM mtl_system_items_kfv

302: -- pawan kumar added this cursor for bug 4917631
303: CURSOR item_master_cursor_sub (v_inventory_item_id NUMBER, v_org_id NUMBER)
304: IS
305: SELECT primary_uom_code, eng_item_flag, process_execution_enabled_flag
306: FROM mtl_system_items_kfv
307: WHERE inventory_item_id = v_inventory_item_id
308: AND organization_id = v_org_id;
309: CURSOR production_rules_cursor (
310: v_inventory_item_id NUMBER

Line 314: FROM mtl_system_items_b

310: v_inventory_item_id NUMBER
311: ,v_org_id NUMBER)
312: IS
313: SELECT std_lot_size, primary_uom_code
314: FROM mtl_system_items_b
315: WHERE inventory_item_id = v_inventory_item_id
316: AND organization_id = v_org_id;
317:
318: CURSOR cur_get_doc_ord (v_org_id NUMBER, v_batch_type NUMBER)

Line 376: FROM mtl_system_items_kfv

372:
373: CURSOR cur_item_no (v_inventory_item_id NUMBER, v_org_id NUMBER)
374: IS
375: SELECT concatenated_segments
376: FROM mtl_system_items_kfv
377: WHERE inventory_item_id = v_inventory_item_id
378: AND organization_id = v_org_id;
379:
380: -- nsinghi bug#5674398 Added the Cursor

Line 1662: FROM mtl_system_items_b

1658: x_batch_header_rec.due_date := p_batch_header_rec.due_date;
1659:
1660: SELECT primary_uom_code
1661: INTO l_prim_item_um
1662: FROM mtl_system_items_b
1663: WHERE inventory_item_id = l_recipe_validity_rule.inventory_item_id
1664: AND organization_id = x_batch_header_rec.organization_id;
1665:
1666: OPEN get_prim_prod (x_batch_header_rec.batch_id

Line 2643: mtl_system_items iim,

2639: FROM fm_form_mst ffm,
2640: fm_matl_dtl fmd,
2641: fm_rout_hdr frh,
2642: fm_rout_dtl frd,
2643: mtl_system_items iim,
2644: gme_batch_header gbh,
2645: gmd_recipe_validity_rules ffe
2646: WHERE gbh.batch_id = x_batch_id
2647: AND ffm.formula_id = gbh.formula_id