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

Line 297: hr_locations hl,

293:
294: SELECT MAX(org.organization_code)
295: INTO x_to_organization_code
296: FROM rcv_transactions_interface rti,
297: hr_locations hl,
298: mtl_parameters org
299: -- BugFix 5219284, replaced org_organization_definitions with mtl_parameters for better performance.
300: WHERE rti.header_interface_id = x_header_interface_id
301: AND ( rti.ship_to_location_code = hl.location_code

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;

Line 1064: hr_locations hl,

1060: */
1061: SELECT COUNT(*)
1062: INTO x_count
1063: FROM rcv_transactions_interface rti,
1064: hr_locations hl,
1065: mtl_parameters org
1066: -- BugFix 5219284, replaced org_organization_definitions with mtl_parameters for better performance.
1067: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
1068: AND rti.to_organization_code IS NULL

Line 1084: above sql to avoid full table scans on hr_locations.

1080: ship to org than the header's org. Here we consider those RTI records
1081: which have to_organization_code and to_rganization_id as null and
1082: ship_to_location_code as not null. A seperate sql is written using
1083: ship_location_code instead of adding it to the the WHERE caluse of the
1084: above sql to avoid full table scans on hr_locations.
1085: */
1086: IF x_count = 0 THEN
1087: SELECT COUNT(*)
1088: INTO x_count

Line 1090: hr_locations hl,

1086: IF x_count = 0 THEN
1087: SELECT COUNT(*)
1088: INTO x_count
1089: FROM rcv_transactions_interface rti,
1090: hr_locations hl,
1091: mtl_parameters org
1092: -- BugFix 5219284, replaced org_organization_definitions with mtl_parameters for better performance.
1093: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
1094: AND rti.to_organization_code IS NULL