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.AHL_PRD_NONROUTINE_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 659: FROm csi_item_instances csi, mtl_system_items_kfv mtl,cs_incidents_all_b cs

655:
656: BEGIN
657: SELECT mtl.concatenated_segments,csi.serial_number
658: INTO x_create_nr_output_rec.item_number,x_create_nr_output_rec.serial_number
659: FROm csi_item_instances csi, mtl_system_items_kfv mtl,cs_incidents_all_b cs
660: WHERE csi.instance_id = cs.customer_product_id
661: and csi.inventory_item_id = mtl.inventory_item_id
662: and mtl.organization_id = csi.inv_master_organization_id
663: AND cs.incident_id = p_nr_task_rec.incident_id;

Line 851: FROm csi_item_instances csi, mtl_system_items_kfv mtl

847: END IF;
848: BEGIN
849: SELECT mtl.concatenated_segments,csi.serial_number
850: INTO x_create_nr_output_rec.ITEM_NUMBER,x_create_nr_output_rec.SERIAL_NUMBER
851: FROm csi_item_instances csi, mtl_system_items_kfv mtl
852: WHERE csi.instance_id = p_sr_task_rec.instance_id
853: and csi.inventory_item_id = mtl.inventory_item_id
854: and mtl.organization_id = csi.INV_MASTER_ORGANIZATION_ID;
855: EXCEPTION