[Home] [Help]
17: g_mtl_category_id NUMBER;
18: g_inventory_item_id NUMBER;
19: g_organization_id NUMBER;
20: g_request_id NUMBER;
21: g_entity_type mtl_item_bulkload_recs.entity_type%TYPE;
22: g_start_rowid ROWID;
23: g_end_rowid ROWID;
24:
25: PROCEDURE openOnlineItemCatgDeleteCursor
309: END IF;
310:
311: -- Need to consider the following
312: -- 1. populateBulkItemChange when bulk updation done to item / category
313: -- Join with MTL_ITEM_BULKLOAD_RECS to get the changed
314: -- inventory_item_id and organization_id for the request_id passed in
315:
316: l_err_loc := 300;
317: IF (P_ENTITY_TYPE = 'ITEM') THEN
362: mparams.organization_id,
363: mparams.master_organization_id
364: FROM mtl_system_items_b mi,
365: mtl_parameters mparams,
366: mtl_item_bulkload_recs mbulk,
367: mtl_system_items_tl mitl,
368: mtl_item_categories mic,
369: mtl_units_of_measure muom,
370: financials_system_params_all fsp,
403: AND doc.source_type = ctx.source_type (+)
404: ORDER by doc.inventory_item_id;
405:
406: /* Bug 6900901: During item import, when the category set are controlled at
407: * master org level, mtl_item_bulkload_recs is only one record corresponding to
408: * master org, even if items are imported for all orgs. so, the inventory org is derived
409: * from master_org using the following condition.
410: * mbulk.category_set_id = msets.category_set_id
411: * AND msets.control_level = 1 -- Controlled at Master org level
461: mparams.organization_id,
462: mparams.master_organization_id
463: FROM mtl_system_items_b mi,
464: mtl_parameters mparams,
465: mtl_item_bulkload_recs mbulk,
466: mtl_system_items_tl mitl,
467: mtl_item_categories mic,
468: mtl_units_of_measure muom,
469: mtl_category_sets msets,
544: mparams.organization_id,
545: mparams.master_organization_id
546: FROM mtl_system_items_b mi,
547: mtl_parameters mparams,
548: mtl_item_bulkload_recs mbulk,
549: mtl_system_items_tl mitl,
550: mtl_item_categories mic,
551: mtl_units_of_measure muom,
552: mtl_category_sets msets,