DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 846: ,p_item_master_rec IN mtl_system_items_kfv%ROWTYPE

842: END get_yield_defaults;
843:
844: PROCEDURE construct_material_detail (
845: p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
846: ,p_item_master_rec IN mtl_system_items_kfv%ROWTYPE
847: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
848: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
849: ,x_return_status OUT NOCOPY VARCHAR2)
850: IS

Line 2230: FROM mtl_system_items_kfv

2226:
2227: CURSOR cur_item_no (v_org_id NUMBER, v_inventory_item_id NUMBER)
2228: IS
2229: SELECT concatenated_segments
2230: FROM mtl_system_items_kfv
2231: WHERE organization_id = v_org_id
2232: AND inventory_item_id = v_inventory_item_id;
2233:
2234: l_validity_rec gmd_recipe_validity_rules%ROWTYPE;

Line 2505: FROM mtl_system_items_kfv

2501: IS
2502: SELECT concatenated_segments, NVL(location_control_code,1) location_control_code,
2503: restrict_locators_code, primary_uom_code,
2504: reservable_type
2505: FROM mtl_system_items_kfv
2506: WHERE organization_id = v_org_id
2507: AND inventory_item_id = v_inventory_item_id;
2508:
2509: CURSOR cur_get_onhand (

Line 2568: --l_item_rec mtl_system_items_kfv%ROWTYPE;

2564: l_subinventory VARCHAR2 (10);
2565: l_return_status VARCHAR2 (1);
2566: l_mtl_dtl_rec gme_material_details%ROWTYPE;
2567: --FPbug#4912179
2568: --l_item_rec mtl_system_items_kfv%ROWTYPE;
2569: l_item_rec cur_get_item%ROWTYPE;
2570: l_exception_rec gme_exceptions_gtmp%ROWTYPE;
2571: setup_failure EXCEPTION;
2572: get_open_qty_err EXCEPTION;