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 674: FROm csi_item_instances csi, mtl_system_items_kfv mtl,cs_incidents_all_b cs

670:
671: BEGIN
672: SELECT mtl.concatenated_segments,csi.serial_number
673: INTO x_create_nr_output_rec.item_number,x_create_nr_output_rec.serial_number
674: FROm csi_item_instances csi, mtl_system_items_kfv mtl,cs_incidents_all_b cs
675: WHERE csi.instance_id = cs.customer_product_id
676: and csi.inventory_item_id = mtl.inventory_item_id
677: and mtl.organization_id = csi.inv_master_organization_id
678: AND cs.incident_id = p_nr_task_rec.incident_id;

Line 854: FROm csi_item_instances csi, mtl_system_items_kfv mtl

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