APPS.OE_HOLDS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 133: from mtl_system_items_kfv

129: and rownum = 1;
130:
131: CURSOR item_value_cur IS
132: select concatenated_segments
133: from mtl_system_items_kfv
134: where inventory_item_id = p_hold_entity_id;
135:
136: /* Following cursor has been changed to use direct TCA tables -Bug 1874065*/
137: /* CURSOR customer_value_cur IS

Line 2440: from mtl_system_items_kfv

2436: --ER#7479609 end
2437: ELSIF p_hold_source_rec.hold_entity_code = 'I' THEN
2438: SELECT 'Valid Entity'
2439: INTO l_dummy
2440: from mtl_system_items_kfv
2441: where inventory_item_id = p_hold_source_rec.hold_entity_id;
2442:
2443: --ER# 13331078 start
2444: ELSIF p_hold_source_rec.hold_entity_code = 'IC' THEN

Line 2465: from mtl_system_items_kfv

2461: --ER#7479609 start
2462: ELSIF p_hold_source_rec.hold_entity_code = 'TM' THEN
2463: SELECT 'Valid Entity'
2464: INTO l_dummy
2465: from mtl_system_items_kfv
2466: where inventory_item_id = p_hold_source_rec.hold_entity_id;
2467: ELSIF p_hold_source_rec.hold_entity_code = 'PR' THEN
2468: SELECT 'Valid Entity'
2469: INTO l_dummy

Line 2617: from mtl_system_items_kfv

2613: WHERE transaction_type_id = p_hold_source_rec.hold_entity_id2;
2614: ELSIF p_hold_source_rec.hold_entity_code2 = 'OI' THEN
2615: SELECT 'Valid Entity'
2616: INTO l_dummy
2617: from mtl_system_items_kfv
2618: where inventory_item_id = p_hold_source_rec.hold_entity_id2;
2619: ELSIF p_hold_source_rec.hold_entity_code2 = 'PT' THEN
2620: SELECT 'Valid Entity'
2621: INTO l_dummy