DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on HR_LOCATIONS

Line 504: FROM hr_locations hrl

500: OPEN x_location FOR
501: SELECT location_code
502: , location_id
503: , description
504: FROM hr_locations hrl
505: WHERE (inventory_organization_id = p_organization_id
506: OR Nvl(inventory_organization_id,0) = 0)
507: AND receiving_site_flag = 'Y'
508: AND (inactive_date IS NULL OR inactive_date > Sysdate)

Line 7442: FROM hr_locations hr

7438: SELECT location_code, location_id, description
7439: FROM( SELECT hr.location_code location_code,
7440: hr.location_id location_id,
7441: hr.description
7442: FROM hr_locations hr
7443: WHERE NVL(inactive_date, SYSDATE+1) > SYSDATE
7444: UNION
7445: SELECT DECODE (
7446: inv_check_product_install.check_cse_install,