APPS.BOMCUMYD dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 28: FROM mtl_system_items_b_kfv

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

Line 34: FROM mtl_system_items_b_kfv

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

Line 40: FROM mtl_system_items_b_kfv

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

Line 167: FROM mtl_system_items_b_kfv

163: End If;
164: Else
165: SELECT concatenated_segments
166: INTO Item_Name
167: FROM mtl_system_items_b_kfv
168: WHERE inventory_item_id = Item_Id
169: AND organization_id = Current_Org_Id;
170:
171: For C1 in Cur_Rtg(Item_Id)

Line 352: MTL_SYSTEM_ITEMS_B_KFV.inventory_item_id%TYPE

348: conc_status BOOLEAN ;
349: Operation_Code VARCHAR2(4);
350:
351: TYPE item_id_tab_type IS TABLE of
352: MTL_SYSTEM_ITEMS_B_KFV.inventory_item_id%TYPE
353: INDEX by BINARY_INTEGER;
354:
355: TYPE item_name_tab_type IS TABLE of
356: MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE

Line 356: MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE

352: MTL_SYSTEM_ITEMS_B_KFV.inventory_item_id%TYPE
353: INDEX by BINARY_INTEGER;
354:
355: TYPE item_name_tab_type IS TABLE of
356: MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE
357: INDEX by BINARY_INTEGER;
358:
359: item_tab item_id_tab_type;
360: item_name_tab item_name_tab_type;

Line 374: FROM mtl_system_items_b_kfv

370: No_Event_On_Line EXCEPTION;
371:
372: CURSOR Item_Range_Both is
373: SELECT inventory_item_id,concatenated_segments
374: FROM mtl_system_items_b_kfv
375: WHERE concatenated_segments BETWEEN item_low and item_high
376: AND organization_id = current_org_id;
377:
378: CURSOR Item_Range_Low is

Line 380: FROM mtl_system_items_b_kfv

376: AND organization_id = current_org_id;
377:
378: CURSOR Item_Range_Low is
379: SELECT inventory_item_id,concatenated_segments
380: FROM mtl_system_items_b_kfv
381: WHERE concatenated_segments >= item_low
382: AND organization_id = current_org_id;
383:
384: CURSOR Item_Range_High is

Line 386: FROM mtl_system_items_b_kfv

382: AND organization_id = current_org_id;
383:
384: CURSOR Item_Range_High is
385: SELECT inventory_item_id,concatenated_segments
386: FROM mtl_system_items_b_kfv
387: WHERE concatenated_segments <= item_high
388: AND organization_id = current_org_id;
389:
390: CURSOR Cur_Line_Flow_Rtg (v_line NUMBER) is