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 4194: FROM hr_locations hl, po_line_locations poll,po_lines pol

4190:
4191: IF p_po_header_id IS NOT NULL THEN
4192: SELECT distinct( hl.location_code )
4193: into x_location_code
4194: FROM hr_locations hl, po_line_locations poll,po_lines pol
4195: WHERE hl.location_id = poll.ship_to_location_id
4196: AND poll.po_header_id = p_po_header_id
4197: AND poll.po_line_id = NVL(p_po_line_id, poll.po_line_id)
4198: AND Nvl(pol.item_id,-9999) = NVL(p_item_id,Nvl(pol.item_id,-9999))--BUG 4500676

Line 4215: FROM hr_locations hl, rcv_shipment_lines rsl

4211: END IF;
4212: ELSIF p_shipment_header_id IS NOT NULL THEN
4213: SELECT distinct( hl.location_code )
4214: into x_location_code
4215: FROM hr_locations hl, rcv_shipment_lines rsl
4216: WHERE hl.location_id = rsl.deliver_to_location_id
4217: AND rsl.shipment_header_id = p_shipment_header_id
4218: AND rsl.item_id = NVL(p_item_id, rsl.item_id)
4219: AND rsl.to_organization_id = p_organization_id

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

7036: RETURN;
7037: END;
7038:
7039: --If the LPN has a subinventory associated, get the location_code
7040: --from hr_locations using location_id in mtl_secondary_inventories for that sub
7041: IF (l_debug = 1) THEN
7042: print_debug('get_rcv_sub_loc: 20: values from WLPN - context: ' || x_lpn_context ||
7043: ', sub_code: ' || l_sub_code || ', loc_id: ' || l_locator_id, 4);
7044: END IF;

Line 7123: from hr_locations hl

7119: SELECT location_code
7120: , location_id
7121: INTO x_location_code
7122: , x_location_id
7123: from hr_locations hl
7124: WHERE EXISTS
7125: ( SELECT 1
7126: FROM mtl_secondary_inventories msi
7127: WHERE organization_id = p_organization_id

Line 7143: FROM hr_locations hl

7139: SELECT location_code
7140: , location_id
7141: INTO x_location_code
7142: , x_location_id
7143: FROM hr_locations hl
7144: WHERE location_id = l_location_id
7145: AND ROWNUM = 1;
7146: EXCEPTION
7147: WHEN OTHERS THEN