APPS.OE_HOLDS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 79: from mtl_system_items_kfv

75: and rownum = 1;
76:
77: CURSOR item_value_cur IS
78: select concatenated_segments
79: from mtl_system_items_kfv
80: where inventory_item_id = p_hold_entity_id;
81:
82: /* Following cursor has been changed to use direct TCA tables -Bug 1874065*/
83: /* CURSOR customer_value_cur IS

Line 2003: from mtl_system_items_kfv

1999: --ER#7479609 end
2000: ELSIF p_hold_source_rec.hold_entity_code = 'I' THEN
2001: SELECT 'Valid Entity'
2002: INTO l_dummy
2003: from mtl_system_items_kfv
2004: where inventory_item_id = p_hold_source_rec.hold_entity_id;
2005: ELSIF p_hold_source_rec.hold_entity_code = 'W' THEN
2006: SELECT 'Valid Entity'
2007: INTO l_dummy

Line 2020: from mtl_system_items_kfv

2016: --ER#7479609 start
2017: ELSIF p_hold_source_rec.hold_entity_code = 'TM' THEN
2018: SELECT 'Valid Entity'
2019: INTO l_dummy
2020: from mtl_system_items_kfv
2021: where inventory_item_id = p_hold_source_rec.hold_entity_id;
2022: ELSIF p_hold_source_rec.hold_entity_code = 'PR' THEN
2023: SELECT 'Valid Entity'
2024: INTO l_dummy

Line 2162: from mtl_system_items_kfv

2158: WHERE transaction_type_id = p_hold_source_rec.hold_entity_id2;
2159: ELSIF p_hold_source_rec.hold_entity_code2 = 'OI' THEN
2160: SELECT 'Valid Entity'
2161: INTO l_dummy
2162: from mtl_system_items_kfv
2163: where inventory_item_id = p_hold_source_rec.hold_entity_id2;
2164: ELSIF p_hold_source_rec.hold_entity_code2 = 'PT' THEN
2165: SELECT 'Valid Entity'
2166: INTO l_dummy