DBA Data[Home] [Help]

APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on HR_ORGANIZATION_UNITS

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

3523:
3524: /*Added by sowsubra*/
3525: CURSOR c_get_default_loc_dtl(p_org_id IN NUMBER, p_dept_id IN NUMBER) IS
3526: SELECT ds.inv_locator_id, mtl.subinventory_code, mtl.CONCATENATED_SEGMENTS
3527: FROM ahl_department_shifts_v ds, hr_organization_units hou, mtl_item_locations_kfv mtl
3528: WHERE hou.organization_id = p_org_id
3529: AND hou.name = ds.organization_name
3530: AND ds.department_id = p_dept_id
3531: AND hou.organization_id = mtl.organization_id