DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 756: ,p_item_master_rec IN mtl_system_items_kfv%ROWTYPE

752: END get_yield_defaults;
753:
754: PROCEDURE construct_material_detail (
755: p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
756: ,p_item_master_rec IN mtl_system_items_kfv%ROWTYPE
757: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
758: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
759: ,x_return_status OUT NOCOPY VARCHAR2)
760: IS

Line 2124: FROM mtl_system_items_kfv

2120:
2121: CURSOR cur_item_no (v_org_id NUMBER, v_inventory_item_id NUMBER)
2122: IS
2123: SELECT concatenated_segments
2124: FROM mtl_system_items_kfv
2125: WHERE organization_id = v_org_id
2126: AND inventory_item_id = v_inventory_item_id;
2127:
2128: l_validity_rec gmd_recipe_validity_rules%ROWTYPE;

Line 2390: FROM mtl_system_items_kfv

2386: IS
2387: SELECT concatenated_segments, NVL(location_control_code,1) location_control_code,
2388: restrict_locators_code, primary_uom_code,
2389: reservable_type
2390: FROM mtl_system_items_kfv
2391: WHERE organization_id = v_org_id
2392: AND inventory_item_id = v_inventory_item_id;
2393:
2394: CURSOR cur_get_onhand (

Line 2443: --l_item_rec mtl_system_items_kfv%ROWTYPE;

2439: l_subinventory VARCHAR2 (10);
2440: l_return_status VARCHAR2 (1);
2441: l_mtl_dtl_rec gme_material_details%ROWTYPE;
2442: --FPbug#4912179
2443: --l_item_rec mtl_system_items_kfv%ROWTYPE;
2444: l_item_rec cur_get_item%ROWTYPE;
2445: l_exception_rec gme_exceptions_gtmp%ROWTYPE;
2446: setup_failure EXCEPTION;
2447: get_open_qty_err EXCEPTION;