[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
307: END IF;
308:
309: -- Need to consider the following
310: -- 1. populateBulkItemChange when bulk updation done to item / category
311: -- Join with MTL_ITEM_BULKLOAD_RECS to get the changed
312: -- inventory_item_id and organization_id for the request_id passed in
313:
314: l_err_loc := 300;
315: IF (P_ENTITY_TYPE = 'ITEM') THEN
359: mparams.organization_id,
360: mparams.master_organization_id
361: FROM mtl_system_items_b mi,
362: mtl_parameters mparams,
363: mtl_item_bulkload_recs mbulk,
364: mtl_system_items_tl mitl,
365: mtl_item_categories mic,
366: mtl_units_of_measure muom,
367: financials_system_params_all fsp,
400: AND doc.source_type = ctx.source_type (+)
401: ORDER by doc.inventory_item_id;
402:
403: /* Bug 6900901: During item import, when the category set are controlled at
404: * master org level, mtl_item_bulkload_recs is only one record corresponding to
405: * master org, even if items are imported for all orgs. so, the inventory org is derived
406: * from master_org using the following condition.
407: * mbulk.category_set_id = msets.category_set_id
408: * AND msets.control_level = 1 -- Controlled at Master org level
457: mparams.organization_id,
458: mparams.master_organization_id
459: FROM mtl_system_items_b mi,
460: mtl_parameters mparams,
461: mtl_item_bulkload_recs mbulk,
462: mtl_system_items_tl mitl,
463: mtl_item_categories mic,
464: mtl_units_of_measure muom,
465: mtl_category_sets msets,
539: mparams.organization_id,
540: mparams.master_organization_id
541: FROM mtl_system_items_b mi,
542: mtl_parameters mparams,
543: mtl_item_bulkload_recs mbulk,
544: mtl_system_items_tl mitl,
545: mtl_item_categories mic,
546: mtl_units_of_measure muom,
547: mtl_category_sets msets,