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

Line 1604: FROM hr_locations hrl, hr_organization_units hou

1600:
1601: BEGIN
1602: SELECT location_code
1603: INTO x_org_location
1604: FROM hr_locations hrl, hr_organization_units hou
1605: WHERE hou.location_id = hrl.location_id
1606: AND hou.organization_id = p_org_id;
1607: EXCEPTION
1608: WHEN OTHERS THEN

Line 1836: FROM hr_locations hrl, hr_organization_units hou

1832: -- set default org location
1833: BEGIN
1834: SELECT location_code
1835: INTO x_org_location
1836: FROM hr_locations hrl, hr_organization_units hou
1837: WHERE hou.location_id = hrl.location_id
1838: AND hou.organization_id = p_organization_id;
1839:
1840: l_progress := '40';

Line 4681: FROM po_distributions_all pda,po_lines_all pol, po_line_locations_all pll, hr_locations hl

4677: BEGIN
4678: /* bug 14305407 modified the query to improve the performance */
4679: SELECT distinct(hl.location_code)
4680: INTO x_location_code
4681: FROM po_distributions_all pda,po_lines_all pol, po_line_locations_all pll, hr_locations hl
4682: WHERE pda.po_header_id = pll.po_header_id
4683: AND pda.line_location_id = pll.line_location_id
4684: AND pda.po_line_id = pll.po_line_id
4685: AND pda.po_header_id = pol.po_header_id

Line 4714: FROM hr_locations hl, po_line_locations poll,po_lines pol

4710: -- bug 864331
4711: /* bug 14305407 modified the query to improve the performance */
4712: SELECT distinct( hl.location_code )
4713: INTO x_location_code
4714: FROM hr_locations hl, po_line_locations poll,po_lines pol
4715: WHERE hl.location_id = poll.ship_to_location_id
4716: AND poll.po_header_id = pol.po_header_id
4717: AND poll.po_line_id = pol.po_line_id
4718: AND poll.po_header_id = p_po_header_id

Line 4738: FROM hr_locations hl, rcv_shipment_lines rsl

4734: END IF;
4735: ELSIF p_shipment_header_id IS NOT NULL THEN
4736: SELECT distinct( hl.location_code )
4737: into x_location_code
4738: FROM hr_locations hl, rcv_shipment_lines rsl
4739: WHERE hl.location_id = nvl(rsl.deliver_to_location_id,rsl.ship_to_location_id)--bug10349270 for ASN receipt,we should get the default location against RSL.ship_to_location
4740: AND rsl.shipment_header_id = p_shipment_header_id
4741: AND rsl.item_id = NVL(p_item_id, rsl.item_id)
4742: AND rsl.to_organization_id = p_organization_id

Line 7572: --from hr_locations using location_id in mtl_secondary_inventories for that sub

7568: RETURN;
7569: END;
7570:
7571: --If the LPN has a subinventory associated, get the location_code
7572: --from hr_locations using location_id in mtl_secondary_inventories for that sub
7573: IF (l_debug = 1) THEN
7574: print_debug('get_rcv_sub_loc: 20: values from WLPN - context: ' || x_lpn_context ||
7575: ', sub_code: ' || l_sub_code || ', loc_id: ' || l_locator_id, 4);
7576: END IF;

Line 7655: from hr_locations hl

7651: SELECT location_code
7652: , location_id
7653: INTO x_location_code
7654: , x_location_id
7655: from hr_locations hl
7656: WHERE EXISTS
7657: ( SELECT 1
7658: FROM mtl_secondary_inventories msi
7659: WHERE organization_id = p_organization_id

Line 7675: FROM hr_locations hl

7671: SELECT location_code
7672: , location_id
7673: INTO x_location_code
7674: , x_location_id
7675: FROM hr_locations hl
7676: WHERE location_id = l_location_id
7677: AND ROWNUM = 1;
7678: EXCEPTION
7679: WHEN OTHERS THEN