DBA Data[Home] [Help]

APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on HR_ORGANIZATION_UNITS

Line 3573: FROM ahl_department_shifts_v ds, hr_organization_units hou, mtl_item_locations_kfv mtl

3569:
3570: /*Added by sowsubra*/
3571: CURSOR c_get_default_loc_dtl(p_org_id IN NUMBER, p_dept_id IN NUMBER) IS
3572: SELECT ds.inv_locator_id, mtl.subinventory_code, mtl.CONCATENATED_SEGMENTS
3573: FROM ahl_department_shifts_v ds, hr_organization_units hou, mtl_item_locations_kfv mtl
3574: WHERE hou.organization_id = p_org_id
3575: AND hou.name = ds.organization_name
3576: AND ds.department_id = p_dept_id
3577: AND hou.organization_id = mtl.organization_id