eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_DIAG_DTXN dependencies on MTL_PARAMETERS

Line 61: mtl_parameters mp

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
65: and moqd.organization_id = mp.organization_id

Line 107: ',mtl_parameters mp '||

103: ',mtl_item_flexfields mif '||
104: ',mfg_lookups ml '||
105: ',mtl_item_locations_kfv mil '||
106: ',org_acct_periods oap '||
107: ',mtl_parameters mp '||
108: 'WHERE mmt.transaction_type_id=mtt.transaction_type_id '||
109: 'AND mmt.transaction_source_Type_id = mtst.transaction_source_type_id '||
110: 'AND mmt.organization_id=mif.organization_id(+) '||
111: 'AND mmt.inventory_item_id=mif.inventory_item_id(+) '||

Line 134: 'mtl_parameters mp,mtl_item_flexfields mif '||

130: sqltxt :='select mp.organization_code|| '' (''||mln.organization_id ||'')'' "Organization|Code (Id)" '||
131: ',mif.item_number|| '' (''||mln.inventory_item_id||'')'' "Item (Id)" , '||
132: 'lot_number "Lot number" '||
133: 'from mtl_lot_numbers mln, '||
134: 'mtl_parameters mp,mtl_item_flexfields mif '||
135: 'where lot_number <> ltrim(lot_number) '||
136: 'and mln.organization_id = mp.organization_id(+) '||
137: 'and mln.inventory_item_id = mif.inventory_item_id(+) '||
138: 'and mln.organization_id = mif.organization_id(+)';

Line 150: 'mtl_parameters mp,mtl_item_flexfields mif '||

146: sqltxt :='select mp.organization_code|| '' (''||mtln.organization_id ||'')'' "Organization|Code (Id)" '||
147: ',mif.item_number|| '' (''||mtln.inventory_item_id||'')'' "Item (Id)", '||
148: 'lot_number "Lot number" '||
149: 'from mtl_transaction_lot_numbers mtln, '||
150: 'mtl_parameters mp,mtl_item_flexfields mif '||
151: 'where lot_number <> ltrim(lot_number) '||
152: 'and mtln.organization_id = mp.organization_id(+) '||
153: 'and mtln.inventory_item_id = mif.inventory_item_id(+) '||
154: 'and mtln.organization_id = mif.organization_id(+)';

Line 166: 'mtl_parameters mp,mtl_item_flexfields mif '||

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(+) '||
170: 'and moqd.organization_id = mif.organization_id(+)';

Line 182: 'mtl_parameters mp,mtl_item_flexfields mif '||

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" '||
181: 'from mtl_reservations mr, '||
182: 'mtl_parameters mp,mtl_item_flexfields mif '||
183: 'where lot_number <> ltrim(lot_number) '||
184: 'and mr.organization_id = mp.organization_id(+) '||
185: 'and mr.inventory_item_id = mif.inventory_item_id(+) '||
186: 'and mr.organization_id = mif.organization_id(+)';

Line 208: ', mtl_parameters mp '||

204: ' from mtl_transactions_interface mti '||
205: ' group by mti.inventory_item_id,mti.organization_id,mti.revision, '||
206: ' mti.subinventory_code,mti.locator_id,transaction_quantity '||
207: ' order by mti.inventory_item_id) mti '||
208: ', mtl_parameters mp '||
209: ',mtl_item_flexfields mif '||
210: 'where qty_avail < 0 '||
211: 'and mti.organization_id = mp.organization_id '||
212: 'and mti.inventory_item_id = mif.inventory_item_id '||

Line 233: ', mtl_parameters mp '||

229: ' from mtl_material_transactions_temp mti '||
230: ' group by mti.inventory_item_id,mti.organization_id,mti.revision, '||
231: ' mti.subinventory_code,mti.locator_id,transaction_quantity '||
232: ' order by mti.inventory_item_id) mti '||
233: ', mtl_parameters mp '||
234: ',mtl_item_flexfields mif '||
235: 'where qty_avail < 0 '||
236: 'and mti.organization_id = mp.organization_id '||
237: 'and mti.inventory_item_id = mif.inventory_item_id '||

Line 253: 'mtl_parameters mp '||

249: 'mif.item_number ||'' (''||mut.inventory_item_id ||'')'' "Item (Id)", '||
250: 'mp.organization_code ||'' (''|| mut.organization_id||'')'' "Org code (Id)" ,count(*) '||
251: 'from mtl_unit_transactions mut, '||
252: 'mtl_item_flexfields mif , '||
253: 'mtl_parameters mp '||
254: 'where mut.inventory_item_id = mif.inventory_item_id(+) '||
255: 'and mut.organization_id = mif.organization_id (+) '||
256: 'and mut.organization_id = mp.organization_id (+) '||
257: 'and transaction_id >0 '||

Line 281: ' mtl_parameters mp,mtl_item_flexfields mif '||

277: ' where wdd.source_code = ''OE'' '||
278: ' and wdd.released_status = ''C'' '||
279: ' and wdd.serial_number is null '||
280: ' group by wdd.source_header_number, wdd.source_line_id, wdd.inventory_item_id, wdd.organization_id) wdd1, '||
281: ' mtl_parameters mp,mtl_item_flexfields mif '||
282: ' where mmt.mmt_qty > wdd1.shp_qty '||
283: ' and mmt.trx_source_line_id = wdd1.source_line_id '||
284: ' and mmt.inventory_item_id = wdd1.inventory_item_id '||
285: ' and mmt.organization_id = wdd1.organization_id '||

Line 332: 'FROM mtl_parameters mp '||

328: end loop;
329: elsif l_script = 'invfixcg' then
330: sqltxt :='SELECT mp.organization_code||'' (''||organization_id||'')'' "Organization code (Id)" '||
331: ', default_cost_group_id "Default Cost group Id" '||
332: 'FROM mtl_parameters mp '||
333: 'WHERE mp.primary_cost_method <> 1 ';
334:
335: if l_org_id is not null then
336: sqltxt :=sqltxt||' and mp.organization_id = '||l_org_id;

Line 347: 'mtl_parameters mp, '||

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 '||
351: 'and moqd.organization_id = mp.organization_id '||

Line 398: 'mtl_parameters mp, '||

394: ' BURDEN_COST, '||
395: ' CREATE_TRANSACTION_ID '||
396: 'from '||
397: 'cst_quantity_layers CQL, '||
398: 'mtl_parameters mp, '||
399: 'mtl_item_flexfields mif '||
400: 'WHERE cql.organization_id = '||c2.organization_id ||
401: 'AND cql.cost_group_id <> '||c2.default_cost_group_id ||
402: 'AND cql.inventory_item_id = '||c2.inventory_item_id ||

Line 581: ' mtl_parameters mp1, '||

577: ', mtt.transaction_type_name ||'' (''||a.transaction_type_id||'')'' "Txn Type (Id)" '||
578: ',a.costed_flag "Costed flag" '||
579: ',mif.item_number ||'' (''||a.inventory_item_id||'')'' "Item (Id)" '||
580: ' from mtl_material_transactions a,mtl_material_transactions b , '||
581: ' mtl_parameters mp1, '||
582: ' mtl_parameters mp2, '||
583: ' mtl_item_flexfields mif, '||
584: ' mtl_transaction_types mtt '||
585: ' WHERE '||

Line 582: ' mtl_parameters mp2, '||

578: ',a.costed_flag "Costed flag" '||
579: ',mif.item_number ||'' (''||a.inventory_item_id||'')'' "Item (Id)" '||
580: ' from mtl_material_transactions a,mtl_material_transactions b , '||
581: ' mtl_parameters mp1, '||
582: ' mtl_parameters mp2, '||
583: ' mtl_item_flexfields mif, '||
584: ' mtl_transaction_types mtt '||
585: ' WHERE '||
586: ' a.inventory_item_id = mif.inventory_item_id(+) '||