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 JTF_DIAGNOSTIC_COREAPI

Line 72: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

68:
69: BEGIN
70: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
71: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
72: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
73: -- accept input
74: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
75: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ScriptName',inputs);
76: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);

Line 127: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Transactions with Incorrect Account Period in MMT ');

123: end if;
124:
125: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
126:
127: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Transactions with Incorrect Account Period in MMT ');
128:
129: elsif l_script = 'lotleading' then
130: sqltxt :='select mp.organization_code|| '' (''||mln.organization_id ||'')'' "Organization|Code (Id)" '||
131: ',mif.item_number|| '' (''||mln.inventory_item_id||'')'' "Item (Id)" , '||

Line 144: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Lot Number with leading space in mtl_lot_numbers ');

140: if l_org_id is not null then
141: sqltxt :=sqltxt||' and mln.organization_id = '||l_org_id;
142: end if;
143:
144: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Lot Number with leading space in mtl_lot_numbers ');
145:
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" '||

Line 160: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Lot Number with leading space in mtl_transaction_lot_numbers ');

156: if l_org_id is not null then
157: sqltxt :=sqltxt||' and mtln.organization_id = '||l_org_id;
158: end if;
159:
160: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Lot Number with leading space in mtl_transaction_lot_numbers ');
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" '||

Line 176: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Lot Number with leading space in mtl_onhand_quantities_detail ');

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" '||

Line 192: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Lot Number with leading space in mtl_reservations ');

188: if l_org_id is not null then
189: sqltxt :=sqltxt||' and mr.organization_id = '||l_org_id;
190: end if;
191:
192: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Lot Number with leading space in mtl_reservations ');
193:
194: elsif l_script = 'neg_bal' then
195: sqltxt :='select mp.organization_code|| '' (''||mti.organization_id ||'')'' "OrganizationCode (Id)" '||
196: ',mif.item_number|| '' (''||mti.inventory_item_id||'')'' item '||

Line 218: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Onhand Information Associated with Transactions stuck in MTI with Negative Balance Error');

214:
215: if l_org_id is not null then
216: sqltxt :=sqltxt||' and mti.organization_id = '||l_org_id;
217: end if;
218: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Onhand Information Associated with Transactions stuck in MTI with Negative Balance Error');
219:
220: sqltxt := 'select mp.organization_code|| '' (''||mti.organization_id ||'')'' "OrganizationCode (Id)" '||
221: ',mif.item_number|| '' (''||mti.inventory_item_id||'')'' item '||
222: ',rev,sub,onhand,qty_avail,transaction_quantity '||

Line 243: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Onhand Information Associated with Transactions stuck in MMTT with Negative Balance Error');

239:
240: if l_org_id is not null then
241: sqltxt :=sqltxt||' and mti.organization_id = '||l_org_id;
242: end if;
243: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Onhand Information Associated with Transactions stuck in MMTT with Negative Balance Error');
244:
245:
246: elsif l_script = 'mut_dups' then
247: sqltxt :='select * from ( '||

Line 262: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Duplicate Transactions in MTL_UNIT_TRANSACTIONS (max count: '||row_limit||' )');

258: 'group by mut.transaction_id,mut.serial_number,mif.item_number,mut.inventory_item_id ,mp.organization_code,mut.organization_id '||
259: 'having count(*) > 1) '||
260: 'where rownum <= '||row_limit;
261:
262: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Duplicate Transactions in MTL_UNIT_TRANSACTIONS (max count: '||row_limit||' )');
263:
264: elsif l_script = 'overshipped' then
265: sqltxt :='select mp.organization_code|| '' (''||mmt.organization_id ||'')'' "Organization|Code (Id)" '||
266: ',mif.item_number|| '' (''||mmt.inventory_item_id||'')'' "Item (Id)" , '||

Line 293: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Order Lines with Shipped Qty < Interfaced Qty (MMT) ');

289:
290: if l_org_id is not null then
291: sqltxt :=sqltxt||' and mmt.organization_id = '||l_org_id;
292: end if;
293: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Order Lines with Shipped Qty < Interfaced Qty (MMT) ');
294:
295: for c1 in c_overshipline
296: loop
297: sqltxt:= 'select mif.item_number|| '' (''||mif.inventory_item_id||'')'' "Item (Id)" , '||

Line 327: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Receipt details for ship line id '||c1.source_line_id);

323: 'and rsl.item_id = mif.inventory_item_id(+) '||
324: 'and rsl.to_organization_id = mif.organization_id(+) '||
325: 'and oel.line_id = '||c1.source_line_id;
326:
327: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Receipt details for ship line id '||c1.source_line_id);
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" '||

Line 338: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Organization Default Cost Group Id ');

334:
335: if l_org_id is not null then
336: sqltxt :=sqltxt||' and mp.organization_id = '||l_org_id;
337: end if;
338: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Organization Default Cost Group Id ');
339:
340: -- Bug 6690548: Added the where clause to check that the organization's primary cost method is not standard.
341: sqltxt :='SELECT mp.organization_code|| '' (''||moqd.organization_id ||'')'' "Organization|Code (Id)" '||
342: ',mif.item_number|| '' (''||moqd.inventory_item_id||'')'' "Item (Id)" '||

Line 358: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Cost_group_id in MOQD is not the same as the default cost group id of the org ');

354:
355: if l_org_id is not null then
356: sqltxt :=sqltxt||' and moqd.organization_id = '||l_org_id;
357: end if;
358: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Cost_group_id in MOQD is not the same as the default cost group id of the org ');
359:
360: for c2 in c_cstgrp
361: loop
362: sqltxt :='select count(1) '||

Line 367: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Count of records in cst_item_costs for the item-org '||c2.inventory_item_id||'-'||c2.organization_id);

363: ' from cst_item_costs cic '||
364: ' where cic.inventory_item_id = '||c2.inventory_item_id||
365: ' and cic.cost_type_id = '||c2.organization_id;
366:
367: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Count of records in cst_item_costs for the item-org '||c2.inventory_item_id||'-'||c2.organization_id);
368:
369: -- Bug 6690548: Modified the where clause to retrieve only those records which have incorrect cost_group_id.
370: sqltxt :='select layer_id "Layer Id", '||
371: ' mp.organization_code|| '' (''||cql.organization_id ||'')'' "Organization|Code (Id)" '||

Line 408: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Records in cst_quantity_layers for the item-org with incorrect cost_group '||c2.inventory_item_id||'-'||c2.organization_id);

404: 'and cql.organization_id = mif.organization_id (+)';
405:
406: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
407:
408: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Records in cst_quantity_layers for the item-org with incorrect cost_group '||c2.inventory_item_id||'-'||c2.organization_id);
409:
410: sqltxt :='SELECT cicd.cost_element_id, '||
411: ' cicd.level_type, '||
412: ' cicd.last_update_date, '||

Line 427: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Records in cst_item_cost_details for the item-org '||c2.inventory_item_id||'-'||c2.organization_id);

423: 'AND cicd.cost_type_id = 2';
424:
425: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
426:
427: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Records in cst_item_cost_details for the item-org '||c2.inventory_item_id||'-'||c2.organization_id);
428:
429: end loop;
430:
431: elsif l_script = 'txn_src_mismatch' then

Line 484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Txns in MMT not having source type of Internal Requistion for Internal order sub-transfer');

480:
481: if l_org_id is not null then
482: sqltxt :=sqltxt||' and mmt.organization_id = '||l_org_id;
483: end if;
484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Txns in MMT not having source type of Internal Requistion for Internal order sub-transfer');
485:
486: sqltxt :='select mmt.transaction_id "Txn Id" '||
487: ', mif.item_number ||'' (''|| mmt.inventory_item_id ||'')'' "Item (Id)" '||
488: ', mmt.transaction_date "Txn Date" '||

Line 531: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Txns in MMT not having source type of Internal Requistion for Internal order Intransit receipt');

527:
528: if l_org_id is not null then
529: sqltxt :=sqltxt||' and mmt.organization_id = '||l_org_id;
530: end if;
531: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Txns in MMT not having source type of Internal Requistion for Internal order Intransit receipt');
532:
533: elsif l_script = 'duplicat_txn' then
534: sqltxt :='select a.transaction_interface_id , '||
535: 'a.picking_line_id from '||

Line 544: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Transactions duplicate in MMT and MTI ');

540: 'and b.transaction_type_id = a.transaction_type_id '||
541: 'and b.transaction_source_type_id in (2,8) '||
542: 'and b.picking_line_id is not null';
543:
544: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Transactions duplicate in MMT and MTI ');
545:
546: sqltxt :='select a.transaction_interface_id , '||
547: 'a.picking_line_id from '||
548: 'mtl_material_transactions_temp b, mtl_transactions_interface a '||

Line 557: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Transactions duplicate in MMTT and MTI');

553: 'and b.transaction_source_type_id in (2,8) '||
554: 'and b.picking_line_id is not null ';
555:
556:
557: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Transactions duplicate in MMTT and MTI');
558:
559: sqltxt := 'select a.transaction_temp_id, '||
560: 'a.picking_line_id from '||
561: 'mtl_material_transactions b, mtl_material_transactions_temp a '||

Line 570: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Transactions duplicate in MMTT and MTT');

566: 'and b.transaction_source_type_id in ( 2,8) '||
567: 'and b.picking_line_id is not null';
568:
569:
570: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Transactions duplicate in MMTT and MTT');
571:
572: elsif l_script = 'transfer_txn' then
573: sqltxt :='select a.transaction_id "Issue txn id" '||
574: ', b.transaction_id "Receipt txn id" '||

Line 601: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Transfer Transaction null');

597:
598: if l_org_id is not null then
599: sqltxt :=sqltxt||' and a.organization_id = '||l_org_id;
600: end if;
601: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Transfer Transaction null');
602:
603:
604: end if;
605: