APPS.BOMCUMYD dependencies on MTL_SYSTEM_ITEMS

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 198: UPDATE MTL_SYSTEM_ITEMS

194: -- by dividing by 24 or by line hours
195: /** Get the value of profile option BOM:LEAD TIME CALCULATION BASIS **/
196: fnd_profile.get('BOM:LEAD_TIME_CALCULATION_BASIS', v_Lead_Time_Profile_Val);
197: IF Flow_Line_Id is NULL THEN /*** Line is not specified ***/
198: UPDATE MTL_SYSTEM_ITEMS
199: SET FULL_LEAD_TIME = l_tpct/24,
200: FIXED_LEAD_TIME = l_tpct/24,
201: PROGRAM_UPDATE_DATE = SYSDATE
202: WHERE INVENTORY_ITEM_ID = item_id

Line 214: UPDATE MTL_SYSTEM_ITEMS

210:
211: l_line_hours := l_line_Seconds/3600;
212:
213: /**Update using Line hours**/
214: UPDATE MTL_SYSTEM_ITEMS
215: SET FULL_LEAD_TIME = l_tpct/l_line_hours,
216: FIXED_LEAD_TIME = l_tpct/l_line_hours,
217: PROGRAM_UPDATE_DATE = SYSDATE
218: WHERE INVENTORY_ITEM_ID = item_id

Line 221: UPDATE MTL_SYSTEM_ITEMS

217: PROGRAM_UPDATE_DATE = SYSDATE
218: WHERE INVENTORY_ITEM_ID = item_id
219: AND ORGANIZATION_ID = org_id;
220: ELSE
221: UPDATE MTL_SYSTEM_ITEMS
222: SET FULL_LEAD_TIME = l_tpct/24,
223: FIXED_LEAD_TIME = l_tpct/24,
224: PROGRAM_UPDATE_DATE = SYSDATE
225: WHERE INVENTORY_ITEM_ID = 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