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.RCV_RETURN_SV dependencies on HR_LOCATIONS

Line 510: from hr_locations

506: begin
507: x_progress := 120;
508: select location_code
509: into x_receiving_location
510: from hr_locations
511: where location_id = x_receiving_location_id;
512: --Bug#2253273. Added this exception as the hr_locations view which
513: --was a join of hr_locations_all and hz_locations has been changed.
514: --Now hr_locations dose not contain hz_locations table.So added the

Line 512: --Bug#2253273. Added this exception as the hr_locations view which

508: select location_code
509: into x_receiving_location
510: from hr_locations
511: where location_id = x_receiving_location_id;
512: --Bug#2253273. Added this exception as the hr_locations view which
513: --was a join of hr_locations_all and hz_locations has been changed.
514: --Now hr_locations dose not contain hz_locations table.So added the
515: --following condition to take care of the RMA.
516: exception

Line 513: --was a join of hr_locations_all and hz_locations has been changed.

509: into x_receiving_location
510: from hr_locations
511: where location_id = x_receiving_location_id;
512: --Bug#2253273. Added this exception as the hr_locations view which
513: --was a join of hr_locations_all and hz_locations has been changed.
514: --Now hr_locations dose not contain hz_locations table.So added the
515: --following condition to take care of the RMA.
516: exception
517: WHEN NO_DATA_FOUND then

Line 514: --Now hr_locations dose not contain hz_locations table.So added the

510: from hr_locations
511: where location_id = x_receiving_location_id;
512: --Bug#2253273. Added this exception as the hr_locations view which
513: --was a join of hr_locations_all and hz_locations has been changed.
514: --Now hr_locations dose not contain hz_locations table.So added the
515: --following condition to take care of the RMA.
516: exception
517: WHEN NO_DATA_FOUND then
518: PO_SHIPMENTS_SV2.get_drop_ship_cust_locations(x_receiving_location_id,

Line 528: from hr_locations

524: begin
525: x_progress := 130;
526: select location_code
527: into x_final_location
528: from hr_locations
529: where location_id = x_final_location_id;
530: --Bug#2253273.
531: exception
532: WHEN NO_DATA_FOUND then