APPS.BOMCUMYD dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 27: FROM mtl_system_items_b_kfv

23: Item_Specific_Not_Specified EXCEPTION;
24:
25: CURSOR Item_Range_Both is
26: SELECT inventory_item_id,concatenated_segments
27: FROM mtl_system_items_b_kfv
28: WHERE concatenated_segments BETWEEN item_low and item_high
29: AND organization_id = current_org_id;
30:
31: CURSOR Item_Range_Low is

Line 33: FROM mtl_system_items_b_kfv

29: AND organization_id = current_org_id;
30:
31: CURSOR Item_Range_Low is
32: SELECT inventory_item_id,concatenated_segments
33: FROM mtl_system_items_b_kfv
34: WHERE concatenated_segments >= item_low
35: AND organization_id = current_org_id;
36:
37: CURSOR Item_Range_High is

Line 39: FROM mtl_system_items_b_kfv

35: AND organization_id = current_org_id;
36:
37: CURSOR Item_Range_High is
38: SELECT inventory_item_id,concatenated_segments
39: FROM mtl_system_items_b_kfv
40: WHERE concatenated_segments <= item_high
41: AND organization_id = current_org_id;
42:
43: CURSOR Cur_Rtg(Item_Id NUMBER) IS

Line 137: FROM mtl_system_items_b_kfv

133: End If;
134: Else
135: SELECT concatenated_segments
136: INTO Item_Name
137: FROM mtl_system_items_b_kfv
138: WHERE inventory_item_id = Item_Id
139: AND organization_id = Current_Org_Id;
140:
141: For C1 in Cur_Rtg(Item_Id)

Line 310: MTL_SYSTEM_ITEMS_B_KFV.inventory_item_id%TYPE

306: conc_status BOOLEAN ;
307: Operation_Code VARCHAR2(4);
308:
309: TYPE item_id_tab_type IS TABLE of
310: MTL_SYSTEM_ITEMS_B_KFV.inventory_item_id%TYPE
311: INDEX by BINARY_INTEGER;
312:
313: TYPE item_name_tab_type IS TABLE of
314: MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE

Line 314: MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE

310: MTL_SYSTEM_ITEMS_B_KFV.inventory_item_id%TYPE
311: INDEX by BINARY_INTEGER;
312:
313: TYPE item_name_tab_type IS TABLE of
314: MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE
315: INDEX by BINARY_INTEGER;
316:
317: item_tab item_id_tab_type;
318: item_name_tab item_name_tab_type;

Line 332: FROM mtl_system_items_b_kfv

328: No_Event_On_Line EXCEPTION;
329:
330: CURSOR Item_Range_Both is
331: SELECT inventory_item_id,concatenated_segments
332: FROM mtl_system_items_b_kfv
333: WHERE concatenated_segments BETWEEN item_low and item_high
334: AND organization_id = current_org_id;
335:
336: CURSOR Item_Range_Low is

Line 338: FROM mtl_system_items_b_kfv

334: AND organization_id = current_org_id;
335:
336: CURSOR Item_Range_Low is
337: SELECT inventory_item_id,concatenated_segments
338: FROM mtl_system_items_b_kfv
339: WHERE concatenated_segments >= item_low
340: AND organization_id = current_org_id;
341:
342: CURSOR Item_Range_High is

Line 344: FROM mtl_system_items_b_kfv

340: AND organization_id = current_org_id;
341:
342: CURSOR Item_Range_High is
343: SELECT inventory_item_id,concatenated_segments
344: FROM mtl_system_items_b_kfv
345: WHERE concatenated_segments <= item_high
346: AND organization_id = current_org_id;
347:
348: CURSOR Cur_Line_Flow_Rtg (v_line NUMBER) is