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_REPORT_UTILS_PVT dependencies on CSI_ITEM_INSTANCES

Line 454: CSI_ITEM_INSTANCES inst

450: CURSOR c_get_count(c_instance_id NUMBER) IS
451: SELECT COUNT(distinct aig.name)
452: FROM AHL_ITEM_ASSOCIATIONS_B ata,
453: AHL_ITEM_GROUPS_B aig,
454: CSI_ITEM_INSTANCES inst
455: WHERE inst.instance_id = c_instance_id
456: AND ata.inventory_item_id = inst.inventory_item_id
457: AND ata.inventory_org_id = inst.inv_master_organization_id --AJPRASAN:: Added this where clause
458: AND ata.item_group_id = aig.item_group_id

Line 1062: SELECT concatenated_segments INTO x_position FROM mtl_item_locations_kfv k WHERE inventory_location_id = (SELECT INV_LOCATOR_ID FROM csi_item_instances WHERE instance_id = P_INSTANCE_ID);

1058: IF(l_position_ref_cd IS NOT NULL) THEN
1059: SELECT meaning INTO x_position FROM fnd_lookups fnd WHERE fnd.lookup_type = 'AHL_POSITION_REFERENCE' AND fnd.lookup_code = l_position_ref_cd;
1060: END IF;
1061: IF(x_position IS NULL) THEN
1062: SELECT concatenated_segments INTO x_position FROM mtl_item_locations_kfv k WHERE inventory_location_id = (SELECT INV_LOCATOR_ID FROM csi_item_instances WHERE instance_id = P_INSTANCE_ID);
1063: END IF;
1064: RETURN x_position;
1065: END Get_Position;
1066: