DBA Data[Home] [Help]

APPS.GME_CREATE_BATCH_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

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 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