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_ROI_HEADER_COMMON dependencies on HR_LOCATIONS_ALL

Line 699: /* Changed hr_locations to hr_locations_all since we are searching

695: AND p_header_record.header_record.location_id IS NULL
696: AND p_header_record.header_record.transaction_type <> 'CANCEL'
697: AND -- added for support of cancel
698: p_header_record.header_record.ship_to_organization_id IS NOT NULL THEN
699: /* Changed hr_locations to hr_locations_all since we are searching
700: * using inventory_organization_id and for drop ship POs inventory
701: * orgid does not have any meaning.
702: */
703: SELECT MAX(hr_locations_all.location_id),

Line 703: SELECT MAX(hr_locations_all.location_id),

699: /* Changed hr_locations to hr_locations_all since we are searching
700: * using inventory_organization_id and for drop ship POs inventory
701: * orgid does not have any meaning.
702: */
703: SELECT MAX(hr_locations_all.location_id),
704: COUNT(*)
705: INTO x_location_id,
706: x_count
707: FROM hr_locations_all

Line 707: FROM hr_locations_all

703: SELECT MAX(hr_locations_all.location_id),
704: COUNT(*)
705: INTO x_location_id,
706: x_count
707: FROM hr_locations_all
708: WHERE hr_locations_all.inventory_organization_id = p_header_record.header_record.ship_to_organization_id
709: AND NVL(hr_locations_all.inactive_date, x_sysdate + 1) > x_sysdate
710: AND NVL(hr_locations_all.receiving_site_flag, 'N') = 'Y';
711:

Line 708: WHERE hr_locations_all.inventory_organization_id = p_header_record.header_record.ship_to_organization_id

704: COUNT(*)
705: INTO x_location_id,
706: x_count
707: FROM hr_locations_all
708: WHERE hr_locations_all.inventory_organization_id = p_header_record.header_record.ship_to_organization_id
709: AND NVL(hr_locations_all.inactive_date, x_sysdate + 1) > x_sysdate
710: AND NVL(hr_locations_all.receiving_site_flag, 'N') = 'Y';
711:
712: IF (g_asn_debug = 'Y') THEN

Line 709: AND NVL(hr_locations_all.inactive_date, x_sysdate + 1) > x_sysdate

705: INTO x_location_id,
706: x_count
707: FROM hr_locations_all
708: WHERE hr_locations_all.inventory_organization_id = p_header_record.header_record.ship_to_organization_id
709: AND NVL(hr_locations_all.inactive_date, x_sysdate + 1) > x_sysdate
710: AND NVL(hr_locations_all.receiving_site_flag, 'N') = 'Y';
711:
712: IF (g_asn_debug = 'Y') THEN
713: asn_debug.put_line('count in hr_locations_all ' || x_count);

Line 710: AND NVL(hr_locations_all.receiving_site_flag, 'N') = 'Y';

706: x_count
707: FROM hr_locations_all
708: WHERE hr_locations_all.inventory_organization_id = p_header_record.header_record.ship_to_organization_id
709: AND NVL(hr_locations_all.inactive_date, x_sysdate + 1) > x_sysdate
710: AND NVL(hr_locations_all.receiving_site_flag, 'N') = 'Y';
711:
712: IF (g_asn_debug = 'Y') THEN
713: asn_debug.put_line('count in hr_locations_all ' || x_count);
714: END IF;

Line 713: asn_debug.put_line('count in hr_locations_all ' || x_count);

709: AND NVL(hr_locations_all.inactive_date, x_sysdate + 1) > x_sysdate
710: AND NVL(hr_locations_all.receiving_site_flag, 'N') = 'Y';
711:
712: IF (g_asn_debug = 'Y') THEN
713: asn_debug.put_line('count in hr_locations_all ' || x_count);
714: END IF;
715:
716: IF x_count = 1 THEN
717: p_header_record.header_record.location_id := x_location_id;