DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 646: FROM mtl_interorg_parameters a, mtl_parameters b, hr_all_organization_units c

642: SELECT a.to_organization_id
643: , b.organization_code
644: , c.NAME
645: , a.intransit_type
646: FROM mtl_interorg_parameters a, mtl_parameters b, hr_all_organization_units c
647: WHERE a.from_organization_id = p_from_organization_id
648: AND a.to_organization_id = b.organization_id
649: AND a.to_organization_id = c.organization_id
650: AND a.internal_order_required_flag = 2