DBA Data[Home] [Help]

APPS.QA_FLEX_UTIL dependencies on MTL_SYSTEM_ITEMS_KFV

Line 16: FROM mtl_system_items_kfv

12: --
13: l_value varchar2(2000);
14: CURSOR c IS
15: SELECT concatenated_segments
16: FROM mtl_system_items_kfv
17: WHERE inventory_item_id = p_item_id AND
18: organization_id = p_org_id;
19:
20: BEGIN

Line 68: from mtl_system_items_kfv

64:
65: -- Bug 5245271 and 5245135. Modified query to consider EAM maint org.
66: cursor c(c_org_id NUMBER,c_item_id NUMBER) IS
67: select concatenated_segments
68: from mtl_system_items_kfv
69: where inventory_item_id = c_item_id
70: and organization_id = c_org_id
71: and rownum=1
72: UNION ALL

Line 74: from mtl_system_items_kfv msikfv,mtl_parameters mp

70: and organization_id = c_org_id
71: and rownum=1
72: UNION ALL
73: select concatenated_segments
74: from mtl_system_items_kfv msikfv,mtl_parameters mp
75: where msikfv.inventory_item_id = c_item_id
76: and msikfv.organization_id = mp.organization_id
77: and mp.maint_organization_id = c_org_id
78: and rownum=1;

Line 116: from mtl_system_items_kfv

112: --
113:
114: /*
115: select inventory_item_id into id
116: from mtl_system_items_kfv
117: where concatenated_segments = x_item
118: and organization_id = x_org_id
119: and rownum = 1;
120: