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_ITEM dependencies on JTF_DIAGNOSTIC_COREAPI

Line 21: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;

17: report OUT NOCOPY JTF_DIAG_REPORT,
18: reportClob OUT NOCOPY CLOB) IS
19: reportStr LONG;
20: counter NUMBER;
21: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;
22: c_userid VARCHAR2(50);
23: statusStr VARCHAR2(50);
24: errStr VARCHAR2(4000);
25: fixInfo VARCHAR2(4000);

Line 55: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

51: BEGIN
52:
53: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
54: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
55: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
56:
57: /* -- check whether user has 'Inventory' responsibilty to execute diagnostics script.
58: IF NOT INV_DIAG_GRP.check_responsibility(p_responsibility_name => l_resp) THEN -- l_resp = 'Inventory'
59: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' You do not have the privilege to run this Diagnostics.');

Line 59: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' You do not have the privilege to run this Diagnostics.');

55: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
56:
57: /* -- check whether user has 'Inventory' responsibilty to execute diagnostics script.
58: IF NOT INV_DIAG_GRP.check_responsibility(p_responsibility_name => l_resp) THEN -- l_resp = 'Inventory'
59: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' You do not have the privilege to run this Diagnostics.');
60: statusStr := 'FAILURE';
61: errStr := 'This test requires Inventory Responsibility Role';
62: fixInfo := 'Please contact your sysadmin to get Inventory Responsibility';
63: isFatal := 'FALSE';

Line 81: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Item and Organization Combination');

77: CLOSE c_item_valid;
78: END IF;
79:
80: IF l_count IS NULL OR l_count <> 1 THEN
81: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Item and Organization Combination');
82: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Invalid Input Arguments');
83: statusStr := 'FAILURE';
84: errStr := 'Invalid Item and Organization Combination';
85: fixInfo := 'Please enter right combination of Item and Organization';

Line 82: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Invalid Input Arguments');

78: END IF;
79:
80: IF l_count IS NULL OR l_count <> 1 THEN
81: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Item and Organization Combination');
82: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Invalid Input Arguments');
83: statusStr := 'FAILURE';
84: errStr := 'Invalid Item and Organization Combination';
85: fixInfo := 'Please enter right combination of Item and Organization';
86: isFatal := 'FALSE';

Line 112: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item descriptions in all installed languages');

108: ' WHERE organization_id = '||l_org_id||
109: ' AND inventory_item_id = '||l_item_id||
110: ' ORDER BY language';
111:
112: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item descriptions in all installed languages');
113:
114: sqltxt := 'SELECT mp.organization_code||'' (''||mp.organization_id||'')'' "Organization|Code (Id)" '||
115: ',mpm.organization_code||'' (''||mp.master_organization_id||'' )'' "Master Org| Code (Id)" '||
116: ',mpc.organization_code||'' (''||mp.cost_organization_id||'' )'' "Cost Org|Code (Id)" '||

Line 142: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Inventory organization information ');

138: 'AND mp.organization_id IN (SELECT organization_id '||
139: ' FROM mtl_system_items_b '||
140: ' WHERE inventory_item_id='||l_item_id||' )';
141:
142: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Inventory organization information ');
143: sqltxt :='SELECT user_group_name "Group" '||
144: ', user_attribute_name "Attribute Name" '||
145: ', control_level_dsp "Controlled at" '||
146: ', user_attribute_value "Attribute Value" '||

Line 152: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item attribute values');

148: 'WHERE organization_id = '||l_org_id||
149: 'AND inventory_item_id = '||l_item_id||
150: 'ORDER BY user_group_name, user_attribute_name';
151:
152: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item attribute values');
153:
154: -- displaying restricted subinventory information when the item is restricted pre-defined list of subinventories
155: IF NVL(l_item.restrict_subinventories_code,1) = 1 THEN
156:

Line 193: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Subinventories the item is restricted to');

189: ' FROM mtl_item_sub_inventories misi ' ||
190: ' WHERE misi.organization_id =' ||l_org_id ||
191: ' AND inventory_item_id ='||l_item_id || ')' ;
192:
193: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Subinventories the item is restricted to');
194:
195: END IF;
196:
197: sqltxt :='SELECT msi.secondary_inventory_name "Name" ' ||

Line 234: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Onhand Subinventory Information ');

230: ' WHERE moq.organization_id = '|| l_org_id ||
231: ' AND moq.inventory_item_id = '|| l_item_id ||')' ||
232: ' ORDER BY msi.secondary_inventory_name';
233:
234: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Onhand Subinventory Information ');
235:
236: sqltxt := ' SELECT micv.category_set_name "Category Set" ' ||
237: ' , micv.category_set_id "Category Set Id" ' ||
238: ' , DECODE( micv.control_level, 1, ''Master'', 2, ''Org'', micv.control_level ) ' ||

Line 246: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item categories');

242: ' FROM mtl_item_categories_v micv ' ||
243: ' WHERE micv.organization_id = '|| l_org_id ||
244: ' AND micv.inventory_item_id = '|| l_item_id;
245:
246: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item categories');
247:
248: sqltxt :=' SELECT micgv.concatenated_segments "Group Name" ' ||
249: ' , msi.item_catalog_group_id "Group id" ' ||
250: ' , micgv.description "Description" ' ||

Line 261: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Catalogs item assigned to');

257: ' AND inventory_item_id = '|| l_item_id ||
258: ' AND msi.item_catalog_group_id = micgv.item_catalog_group_id ' ||
259: ' ORDER BY 1,2';
260:
261: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Catalogs item assigned to');
262:
263: sqltxt :=' SELECT mdev.element_sequence "Element|Sequence" ' ||
264: ' , mdev.element_name "Element Name" ' ||
265: ' , mdev.element_value "Element Value" ' ||

Line 280: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Catalog descriptive elements');

276: ' AND mde.element_name = mdev.element_name ' ||
277: ' AND mdev.element_value IS NOT NULL ' ||
278: ' ORDER BY mdev.element_sequence';
279:
280: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Catalog descriptive elements');
281:
282: -- Displaying serial information only for serial conrolled item
283: IF NVL(l_item.serial_number_control_code,2) <> 1 THEN
284:

Line 306: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Serial number');

302: ' AND ''SERIAL_NUM_STATUS'' = ml.lookup_type(+) ' ||
303: ' ORDER BY msn.last_update_date DESC ' ||
304: ' ) WHERE ROWNUM <= ' || l_row_limit ;
305:
306: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Serial number');
307:
308: END IF;
309:
310: -- Displaying item revision only for revision controlled item

Line 325: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item revisions');

321: ' AND inventory_item_id = '|| l_item_id ||
322: ' ORDER BY revision ' ||
323: ' ) WHERE ROWNUM <= ' || l_row_limit ;
324:
325: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item revisions');
326:
327: END IF;
328:
329: -- Displaying lot information only for lote controlled item

Line 344: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Lot Number' );

340: ' AND inventory_item_id = '|| l_item_id ||
341: ' ORDER BY lot_number ' ||
342: ' ) WHERE ROWNUM <= ' || l_row_limit ;
343:
344: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Lot Number' );
345:
346: END IF;
347:
348: sqltxt := 'SELECT subinventory_code "Subinventory" ' ||

Line 358: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item transactions defaults: subinventory' );

354: ' WHERE organization_id = '|| l_org_id ||
355: ' AND inventory_item_id = '|| l_item_id ||
356: ' ORDER BY subinventory_code, default_type';
357:
358: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item transactions defaults: subinventory' );
359:
360: sqltxt := 'SELECT mild.subinventory_code "Subinventory" ' ||
361: ' , milv.concatenated_segments "Locator" ' ||
362: ' , milv.inventory_location_id "Locator Id" ' ||

Line 376: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item transactions defaults: locators');

372: ' AND mild.organization_id = milv.organization_id ' ||
373: ' AND mild.locator_id = milv.inventory_location_id ' ||
374: ' ORDER BY mild.subinventory_code, milv.concatenated_segments' ;
375:
376: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item transactions defaults: locators');
377:
378: sqltxt := ' SELECT mif.item_number "Item" ' ||
379: ' , moq.inventory_item_id "Item Id" ' ||
380: ' , SUM( moq.transaction_quantity ) "Txn Qty" ' ||

Line 405: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item Onhand Quantity');

401: ' , moq.subinventory_code, moq.locator_id ' ||
402: ' , mil.concatenated_segments, mil.description ' ||
403: ' , moq.revision, moq.lot_number ';
404:
405: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item Onhand Quantity');
406:
407: sqltxt := ' SELECT * FROM ( ' ||
408: ' SELECT TO_CHAR( requirement_date, ''DD-MON-RR'' ) "REQUIREMENT_DATE" ' ||
409: ' , reservation_id ' ||

Line 432: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item Reservations');

428: ' AND inventory_item_id = ' || l_item_id ||
429: ' ORDER BY requirement_date DESC ' ||
430: ' ) WHERE ROWNUM <= ' || l_row_limit ;
431:
432: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item Reservations');
433:
434: sqltxt := ' SELECT demand_id ' ||
435: ' , demand_source_name ' ||
436: ' , inventory_item_id ' ||

Line 454: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item Demand');

450: ' WHERE organization_id = ' || l_org_id ||
451: ' AND inventory_item_id = ' || l_item_id ||
452: ' ORDER BY requirement_date ';
453:
454: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item Demand');
455:
456: -- intentionally not joining to MIF due ot performance
457: sqltxt := ' SELECT * FROM ( ' ||
458: ' SELECT mtiv.transaction_interface_id "Transaction|Interface Id" ' ||

Line 477: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item transactions at Interface');

473: ' AND mtiv.inventory_item_id = ' || l_item_id ||
474: ' AND mtiv.transaction_type_id = mttv.transaction_type_id ' ||
475: ' ) WHERE ROWNUM <= ' || l_row_limit ;
476:
477: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item transactions at Interface');
478:
479: sqltxt := ' SELECT * FROM ( ' ||
480: ' SELECT transaction_header_id "Txn|Header Id" ' ||
481: ' ,transaction_temp_id "Txn|Temp Id" ' ||

Line 535: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Pending Item Transactions ');

531: ' AND mmtt.organization_id=mil.organization_id(+) ' ||
532: ' ORDER BY 1,2 ' ||
533: ' ) WHERE ROWNUM <= ' || l_row_limit ;
534:
535: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Pending Item Transactions ');
536:
537: sqltxt := ' SELECT * FROM ( ' ||
538: ' SELECT mmt.transaction_id "Txn Id" ' ||
539: ' , TO_CHAR( mmt.transaction_date, ''DD-MON-RR'' ) "Txn Date" ' ||

Line 583: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Uncosted Transactions ');

579: ' AND mmt.transaction_source_type_id = st.transaction_source_type_id(+) ' ||
580: ' ORDER BY mmt.transaction_id ' ||
581: ' ) WHERE ROWNUM <= ' || l_row_limit ;
582:
583: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Uncosted Transactions ');
584:
585: sqltxt := ' SELECT DISTINCT( mpi.physical_inventory_name ) "PhyInv.|Name" ' ||
586: ' , mpi.physical_inventory_id "PhyInv.|Id" ' ||
587: ' , TO_CHAR( mpi.physical_inventory_date, ''DD-MON-RR'' ) "PhyInv.|Date" ' ||

Line 600: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item Physical Inventory Adjustments');

596: ' AND mpa.approval_status = 3 ' ||
597: ' GROUP BY mpi.physical_inventory_name, mpi.physical_inventory_id ' ||
598: ' , mpi.physical_inventory_date, mpa.approval_status ';
599:
600: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item Physical Inventory Adjustments');
601:
602: sqltxt := ' SELECT mcch.cycle_count_header_name "Cycle Count|Name" ' ||
603: ' , mcce.cycle_count_header_id "Cycle Count|Id" ' ||
604: ' , mac.abc_class_name "ABC Class|Name" ' ||

Line 625: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item Cycle Count');

621: ' , mac.abc_class_name, mcci.abc_class_id ' ||
622: ' , mcci.item_last_schedule_date ' ||
623: ' ORDER BY mcch.cycle_count_header_name ';
624:
625: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Item Cycle Count');
626:
627:
628:
629: reportStr := 'The test completed as expected';

Line 647: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

643: END IF;
644:
645: EXCEPTION
646: when others then
647: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
648: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
649: statusStr := 'FAILURE';
650: errStr := sqlerrm ||' occurred in script Exception handled';
651: fixInfo := 'Unexpected Exception in INVDI01B.pls';

Line 648: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');

644:
645: EXCEPTION
646: when others then
647: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
648: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
649: statusStr := 'FAILURE';
650: errStr := sqlerrm ||' occurred in script Exception handled';
651: fixInfo := 'Unexpected Exception in INVDI01B.pls';
652: isFatal := 'FALSE';