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 502: from hr_locations

498: begin
499: x_progress := 120;
500: select location_code
501: into x_receiving_location
502: from hr_locations
503: where location_id = x_receiving_location_id;
504: --Bug#2253273. Added this exception as the hr_locations view which
505: --was a join of hr_locations_all and hz_locations has been changed.
506: --Now hr_locations dose not contain hz_locations table.So added the

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

500: select location_code
501: into x_receiving_location
502: from hr_locations
503: where location_id = x_receiving_location_id;
504: --Bug#2253273. Added this exception as the hr_locations view which
505: --was a join of hr_locations_all and hz_locations has been changed.
506: --Now hr_locations dose not contain hz_locations table.So added the
507: --following condition to take care of the RMA.
508: exception

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

501: into x_receiving_location
502: from hr_locations
503: where location_id = x_receiving_location_id;
504: --Bug#2253273. Added this exception as the hr_locations view which
505: --was a join of hr_locations_all and hz_locations has been changed.
506: --Now hr_locations dose not contain hz_locations table.So added the
507: --following condition to take care of the RMA.
508: exception
509: WHEN NO_DATA_FOUND then

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

502: from hr_locations
503: where location_id = x_receiving_location_id;
504: --Bug#2253273. Added this exception as the hr_locations view which
505: --was a join of hr_locations_all and hz_locations has been changed.
506: --Now hr_locations dose not contain hz_locations table.So added the
507: --following condition to take care of the RMA.
508: exception
509: WHEN NO_DATA_FOUND then
510: PO_SHIPMENTS_SV2.get_drop_ship_cust_locations(x_receiving_location_id,

Line 520: from hr_locations

516: begin
517: x_progress := 130;
518: select location_code
519: into x_final_location
520: from hr_locations
521: where location_id = x_final_location_id;
522: --Bug#2253273.
523: exception
524: WHEN NO_DATA_FOUND then