DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on HR_LOCATIONS

Line 532: FROM hr_locations hrl

528: OPEN x_location FOR
529: SELECT location_code
530: , location_id
531: , description
532: FROM hr_locations hrl
533: WHERE (inventory_organization_id = p_organization_id
534: OR Nvl(inventory_organization_id,0) = 0)
535: AND receiving_site_flag = 'Y'
536: AND (inactive_date IS NULL OR inactive_date > Sysdate)

Line 8502: FROM hr_locations hr

8498: SELECT location_code, location_id, description
8499: FROM( SELECT hr.location_code location_code,
8500: hr.location_id location_id,
8501: hr.description
8502: FROM hr_locations hr
8503: WHERE NVL(inactive_date, SYSDATE+1) > SYSDATE
8504: UNION
8505: SELECT DECODE (
8506: inv_check_product_install.check_cse_install,