[Home] [Help]
56: -- of the following query as it was causing performance issues. And also added
57: -- the where clause to check that the organization's primary cost method is not standard.
58: cursor c_cstgrp is
59: SELECT DISTINCT moqd.inventory_item_id,mp.organization_id, mp.default_cost_group_id
60: FROM mtl_onhand_quantities_detail moqd,
61: mtl_parameters mp
62: --mtl_item_flexfields mif
63: WHERE moqd.organization_id = nvl(l_org_id, moqd.organization_id)
64: AND moqd.cost_group_id <> mp.default_cost_group_id
161:
162: sqltxt :='select mp.organization_code|| '' (''||moqd.organization_id ||'')'' "Organization|Code (Id)" '||
163: ',mif.item_number|| '' (''||moqd.inventory_item_id||'')'' "Item (Id)" , '||
164: 'lot_number "Lot number" '||
165: 'from mtl_onhand_quantities_detail moqd, '||
166: 'mtl_parameters mp,mtl_item_flexfields mif '||
167: 'where lot_number <> ltrim(lot_number) '||
168: 'and moqd.organization_id = mp.organization_id(+) '||
169: 'and moqd.inventory_item_id = mif.inventory_item_id(+) '||
172: if l_org_id is not null then
173: sqltxt :=sqltxt||' and moqd.organization_id = '||l_org_id;
174: end if;
175:
176: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Lot Number with leading space in mtl_onhand_quantities_detail ');
177:
178: sqltxt :='select mp.organization_code|| '' (''||mr.organization_id ||'')'' "Organization|Code (Id)" '||
179: ',mif.item_number|| '' (''||mr.inventory_item_id||'')'' "Item (Id)", '||
180: 'lot_number "Lot number" '||
342: ',mif.item_number|| '' (''||moqd.inventory_item_id||'')'' "Item (Id)" '||
343: ',moqd.cost_group_id "Cost group Id" '||
344: ',mp.default_cost_group_id "Default Cost Group Id" '||
345: 'FROM '||
346: 'mtl_onhand_quantities_detail moqd, '||
347: 'mtl_parameters mp, '||
348: 'mtl_item_flexfields mif '||
349: 'WHERE moqd.cost_group_id <> mp.default_cost_group_id '||
350: 'and moqd.inventory_item_id = mif.inventory_item_id '||