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.CSD_RETURNS_UTIL dependencies on CSI_ITEM_INSTANCES

Line 1610: FROM csi_item_instances

1606: THEN
1607: BEGIN
1608: SELECT 'Y',instance_id,owner_party_id
1609: INTO l_ib_exists,x_instance_id,l_current_party_id
1610: FROM csi_item_instances
1611: WHERE inventory_item_id = p_item_ids(i)
1612: AND serial_number = p_serial_nums(i);
1613: EXCEPTION
1614: WHEN NO_DATA_FOUND THEN

Line 1626: FROM csi_item_instances

1622: THEN
1623: BEGIN
1624: SELECT 'Y',instance_id,owner_party_id
1625: INTO l_ib_exists,x_instance_id,l_current_party_id
1626: FROM csi_item_instances
1627: WHERE inventory_item_id = p_item_ids(i)
1628: AND external_reference = p_external_refs(i);
1629: EXCEPTION
1630: WHEN NO_DATA_FOUND THEN