DBA Data[Home] [Help]

APPS.BOM_DELETE_ENTITY dependencies on MTL_SYSTEM_ITEMS

Line 263: FROM mtl_system_items

259: RETURN VARCHAR2
260: IS
261: CURSOR descr is
262: select description
263: FROM mtl_system_items
264: where inventory_item_id = assembly_id and
265: organization_id = org_id;
266: BEGIN
267: FOR c_descr IN descr LOOP

Line 279: FROM mtl_system_items_vl

275: RETURN VARCHAR2
276: IS
277: CURSOR concat is
278: select concatenated_segments
279: FROM mtl_system_items_vl
280: where inventory_item_id = assembly_id and
281: organization_id = org_id;
282: BEGIN
283: FOR c_concat IN concat LOOP

Line 296: FROM mtl_system_items

292: RETURN NUMBER
293: IS
294: CURSOR item IS
295: SELECT inventory_item_id
296: FROM mtl_system_items
297: where inventory_item_id = assembly_id and
298: organization_id = current_org;
299:
300: BEGIN