APPS.GME_CREATE_BATCH_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 255: l_item_master mtl_system_items_kfv%ROWTYPE;

251: l_in_batch_header gme_batch_header%ROWTYPE;
252: l_formula_master fm_form_mst%ROWTYPE;
253: l_formula_material fm_matl_dtl%ROWTYPE;
254: l_recipe_validity_rule gmd_recipe_validity_rules%ROWTYPE;
255: l_item_master mtl_system_items_kfv%ROWTYPE;
256: l_gme_material_detail gme_material_details%ROWTYPE;
257: l_text_header gme_text_header%ROWTYPE;
258: l_text_string gme_text_table.text%TYPE;
259: l_material_details gme_common_pvt.material_details_tab;

Line 332: l_new_item_rec mtl_system_items_kfv%ROWTYPE;

328: material_dtl_fetch_failure EXCEPTION;
329:
330: --FPBug#4351032
331: l_formula_tbl gmdfmval_pub.formula_detail_tbl;
332: l_new_item_rec mtl_system_items_kfv%ROWTYPE;
333: --5698727
334: l_in_batch_header1 gme_batch_header%ROWTYPE;
335: l_doc_timestamp VARCHAR2(50);
336: l_assignment_type NUMBER;

Line 384: FROM mtl_system_items_kfv

380: IS
381: SELECT inventory_item_id, concatenated_segments,
382: eng_item_flag, process_execution_enabled_flag,
383: primary_uom_code, inventory_item_status_code
384: FROM mtl_system_items_kfv
385: WHERE inventory_item_id = v_inventory_item_id
386: AND organization_id = v_org_id;
387:
388: -- Bug 13811289 - Fetch item description..

Line 392: FROM mtl_system_items_kfv

388: -- Bug 13811289 - Fetch item description..
389: CURSOR item_master_descr_cursor (v_inventory_item_id NUMBER)
390: IS
391: SELECT DISTINCT concatenated_segments
392: FROM mtl_system_items_kfv
393: WHERE inventory_item_id = v_inventory_item_id
394: AND rownum = 1;
395:
396: -- Bug 11815699 - Fetch process execution enabled setting for item ststus.

Line 413: FROM mtl_system_items_kfv

409: -- pawan kumar added this cursor for bug 4917631
410: CURSOR item_master_cursor_sub (v_inventory_item_id NUMBER, v_org_id NUMBER)
411: IS
412: SELECT primary_uom_code, eng_item_flag, process_execution_enabled_flag
413: FROM mtl_system_items_kfv
414: WHERE inventory_item_id = v_inventory_item_id
415: AND organization_id = v_org_id;
416: */
417:

Line 504: FROM mtl_system_items_kfv

500:
501: CURSOR cur_item_no (v_inventory_item_id NUMBER, v_org_id NUMBER)
502: IS
503: SELECT concatenated_segments
504: FROM mtl_system_items_kfv
505: WHERE inventory_item_id = v_inventory_item_id
506: AND organization_id = v_org_id;
507:
508: -- nsinghi bug#5674398 Added the Cursor