DBA Data[Home] [Help]

APPS.GME_CREATE_BATCH_PVT dependencies on MTL_SYSTEM_ITEMS

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 402: AND attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG';

398: IS
399: SELECT NVL(st.attribute_value, 'N')
400: FROM mtl_stat_attrib_values_all_v st
401: WHERE st.inventory_item_status_code = v_inventory_item_status_code
402: AND attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG';
403:
404: l_status_exec_enabled VARCHAR2(1);
405:
406: -- Bug 7578476 - Remove redundant cursor introduced by 4917631

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 423: FROM mtl_system_items_b

419: v_inventory_item_id NUMBER
420: ,v_org_id NUMBER)
421: IS
422: SELECT std_lot_size, primary_uom_code
423: FROM mtl_system_items_b
424: WHERE inventory_item_id = v_inventory_item_id
425: AND organization_id = v_org_id;
426:
427: CURSOR cur_get_doc_ord (v_org_id NUMBER, v_batch_type NUMBER)

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

Line 1891: FROM mtl_system_items_b

1887: x_batch_header_rec.due_date := p_batch_header_rec.due_date;
1888:
1889: SELECT primary_uom_code
1890: INTO l_prim_item_um
1891: FROM mtl_system_items_b
1892: WHERE inventory_item_id = l_recipe_validity_rule.inventory_item_id
1893: AND organization_id = x_batch_header_rec.organization_id;
1894:
1895: OPEN get_prim_prod (x_batch_header_rec.batch_id

Line 2958: mtl_system_items iim,

2954: FROM fm_form_mst ffm,
2955: fm_matl_dtl fmd,
2956: fm_rout_hdr frh,
2957: fm_rout_dtl frd,
2958: mtl_system_items iim,
2959: gme_batch_header gbh,
2960: gmd_recipe_validity_rules ffe
2961: WHERE gbh.batch_id = x_batch_id
2962: AND ffm.formula_id = gbh.formula_id